9.0 Date Export to Excel - Different Format in .xls and .xlsx - Allround Automations forums

Register Log In

Forums Products PL/SQL Developer 9.0 Date Export to Excel - Different Format in .xls and .xlsx

Print Thread

Page 2 of 2

1

2

Re: 9.0 Date Export to Excel - Different Format in .xls and .xlsx jlcox #42949 12/15/11 01:22 PM
Joined: Aug 1999 Posts: 22,220 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,220	Could you try again with this version? plsqldev903.1643.exe if it still fails, please let me know the windows date and time format. Marco Kalter Allround Automations

Re: 9.0 Date Export to Excel - Different Format in .xls and .xlsx Marco Kalter #42961 12/16/11 02:43 PM
Joined: Mar 2000 Posts: 204 Akron, OH, USA jlcox Member
jlcox Member Joined: Mar 2000 Posts: 204 Akron, OH, USA	That version fixes the problem for me.

Re: 9.0 Date Export to Excel - Different Format in .xls and .xlsx jlcox #42971 12/17/11 11:48 AM
Joined: Aug 1999 Posts: 22,220 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,220	Okay, thanks for letting me know. Marco Kalter Allround Automations

Re: 9.0 Date Export to Excel - Different Format in .xls and .xlsx Marco Kalter #43029 12/28/11 02:12 PM
Joined: Jan 2010 Posts: 6 B bsullivan Member
bsullivan Member B Joined: Jan 2010 Posts: 6	Looks like this is working for me as well. Thanks!

Re: 9.0 Date Export to Excel - Different Format in .xls and .xlsx bsullivan #44248 07/16/12 07:33 PM
Joined: Aug 2007 Posts: 53 Phoenix J juanian Member
juanian Member J Joined: Aug 2007 Posts: 53 Phoenix	I am seeing the AM/PM problem (A7P7) with 9.0.6.1665 when I use "Copy to Excel" / "Copy all as xls". The other 3 copy to Excel methods work fine.

Re: 9.0 Date Export to Excel - Different Format in .xls and .xlsx juanian #44251 07/17/12 08:26 AM
Joined: Aug 1999 Posts: 22,220 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,220	Can you let me know exactly what goes wrong? Marco Kalter Allround Automations

Re: 9.0 Date Export to Excel - Different Format in .xls and .xlsx Marco Kalter #46917 04/25/13 12:48 AM
Joined: Aug 2007 Posts: 53 Phoenix J juanian Member
juanian Member J Joined: Aug 2007 Posts: 53 Phoenix	(Sorry for the late reply - this wasn't in my Watched Topics) Dates that are formatted with the 12-hour time don't show the AM (or PM) properly when using "Copy to Excel"/"Copy all as xls" - it appears like A1P1, or A4P4, or A10P10, or ... . The fix that was made for the "Copy to Excel"/"Copy as xls" needs to be applied to the "Copy to Excel"/"Copy all as xls". I haven't tried Version 10 yet to see if this is fixed there, but it occurs in 9.0.6.1665.

Page 2 of 2

1

2

Moderated by support

Link Copied to Clipboard

Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)

Responsive Width:

PHP: 7.1.33 Page Time: 0.054s Queries: 15 (0.009s) Memory: 2.5436 MB (Peak: 3.0405 MB) Data Comp: Off Server Time: 2024-05-16 14:15:11 UTC
Valid HTML 5 and Valid CSS