Copy to Excel date format mask bug

[Stuart Hunter]

There is a bug in the Copy to Excel function.

The custom date mask used is invalid, instead of displaying AM or PM the mask cause the display of mixed alpha codes with imbedded short month

mm/dd/yyyy h:mm:ss AmPm

example displays as

07/08/2001 19:00:46 A7P7

the mask should be

mm/dd/yyyy h:mm:ss AM/PM

 

[Marco Kalter]

We'll check it out.

 

[Jonathan Taylor]

The latest version (6.0.1.848) seems to differ to an earlier version (6.0.0.816) in the way it copies dates (with time element) to Excel.

The latest version includes the seconds, the earlier one does not. This may or may not be a consequence of correcting the above problem.

However, copying a date/time to Excel with a "short" title (e.g. SELECT SYSDATE FROM DUAL) causes the field to be sized incorrectly, and it displays as ###########.

There also appears to be a problem with copying long text columns to Excel. They sometimes also display as ##################. If the format of the Cell in Excel is changed from Text to General, this problem goes away.

 

[Marco Kalter]

We'll check out the #### issue. The am/pm format issue will be fixed for 6.0.2. You can already download a pre-release . Let me know if this fixes the date format.