Community Forum     Helping YOU do what YOU want with YOUR data.
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Alex Blount  
#1 Posted : Tuesday, June 30, 2009 8:00:37 PM(UTC)
Alex Blount
Rank: Newbie

Reputation:

Groups: Registered
Posts: 0
Location: Melbourne, Aus

Alex Blount  
#2 Posted : Tuesday, June 30, 2009 8:06:26 PM(UTC)
Alex Blount
Rank: Newbie

Reputation:

Groups: Registered
Posts: 0
Location: Melbourne, Aus

In the chemistry output table/report, the sample_date_time seems to automatically format to "dd mm yyy" which omits any time data?

Whilst we can't customise the excel template itself, is it possible to control the format of this via the database field?  Or can we only display the time data by manually formatting the excel output after export?

Warwick Wood  
#3 Posted : Tuesday, June 30, 2009 8:27:30 PM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 506
Man
Location: Byron Bay

Was thanked: 19 time(s) in 19 post(s)

The Sample Date-Time in the Chemistry Output Tables defaults to your regional settings (under control panel on your PC). 

It is correct that you can't specify a different date format via the template as the location of the Sample_Date-Time will be inconsistent, depending on your export selections.

Only the date component is shown in the chemistry output tables.  The time component is exported but the cell formatting is such that it isn't displayed.  We will address this issue so that the formatting shows the time component, where present.  In the interim it needs to be fixed by changing the cell formatting in Excel using the standard method (Format Cells).  This can only be done post-export.

This issue only effects Chemistry Output Tables, not other exports to Excel.

 

 

 

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.