Posted Friday, May 15, 2009 @ 05:53:56
Hi, I have a problem when using copy-paste from QuickTable to Excel. When copied to Excel, some values in one of my columns is converted to dates (and they should be ordinary decimal values)?! Example:
Excel <-----------> QuickTable
jun.70 <-------------> 6.70
12.00 <------------> 12.00
jul.95 <--------------> 7.95
maj.55 <------------> 5.55
6.okt <--------------> 6.10
jun.65 <-------------> 6.65
jul.50 <--------------> 7.50
jun.75 <-------------> 6.75
avg.15 <------------> 8.15
8.00 <---------------> 8.00
15.00 <------------> 15.00
20.00 <------------> 20.00
35.00 <------------> 35.00
50.00 <------------> 50.00
Column is defined as:
c.setType(Types.DOUBLE);
c.setPrecision(5);
c.setScale(2);
c.setMinWidth(40);
How can I solve this?