craftleft.gif (3002 bytes)QuickTable
Home | API | Tutorial | Download | Support | Contact topblack.gif (108 bytes)


QuickTable User Cp  |  Register  |  Members  |  Search  |  Help
    |- QuickTable Discussion Forums > Column Post New Topic   Post A Reply
Paste to Excel problem printer friendly version
next newest post | next oldest post
Author Messages
proba
Unregistered
Edit or delete this message Reply w/Quote
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?

Admin
Board Owner

Gender: Unspecified
Location:
Registered: Jul 2003
Status: Offline
Posts: 9

Click here to see the profile for Admin Send email to Admin Send private message to Admin Find more posts by Admin Edit or delete this message Reply w/Quote
Posted Friday, May 15, 2009 @ 21:51:58  

it is possible excel might be converting to dates. Try to paste in notepad and see what data is pasted. In notepad if you see the proper decimal values, then excel is formatting to date. If not , quicktable formatting is incorrect.

let me know how it looks in notepad.

proba
Unregistered
Edit or delete this message Reply w/Quote
Posted Saturday, May 16, 2009 @ 02:33:11  

Yes, Notepad is displaying correct values, so I suppose it's not QuickTable issue. And in Excel, if I change type of column to text ("Format cells..."), then warning is shown "This cell contains date string represented with only 2 digits for year." If I set type to number (with 2 decimal places) then some strange numbers are shown, like 45689,00 ?! I don't know how to resolve this, especially beacuse ordinary users just need to paste data to Excel sheets, without any extra tweaking for columns... Any idea (maybe to change QuickTable column definition to some other type)?
Post New Topic   Post A Reply Jump to:
Contact Us | QuickTable - A Java DBGrid | Privacy Policy All times are GMT -5 Hours.
Welcome to QuickTable Forums, Guest!  
Login
Username :
Password :
In order to fully utilize the abilities of this board, you are required to register as a member. Registration is free, and allows you to do lots of things including turning on or off certain features of this board. Register now!
Powered by CuteCast v2.0 BETA 2
Copyright © 2001-2003 ArtsCore Studios