Reply to topic  [ 4 posts ] 
Chart: incorrect number format for Date of X-Axis 
Author Message

Joined: Tue Nov 06, 2007 4:38 am
Posts: 8
Reply with quote
Post Chart: incorrect number format for Date of X-Axis
Hello,
Here is my code to get data format of X-Axis

ExcelAxis xAxis = excelChart.easy_getCategoryXAxis();
String dataFormat = xAxis.getNumberFormat();
It then return General, but the expected value is mmm-yy. The chart contained in a spreadsheet that was created with Ms Excel 2003. I am using EasyXLS Reader for java, version 6.1. Attached screenshot was the chart that i want to load.

Please give me some advice on getting correct X-Axis data format.
Thanks in advance.
The chart screenshot:

http://www.flickr.com/photos/tckhanh/2067784840/


Mon Nov 26, 2007 10:00 pm
Profile

Joined: Fri Feb 03, 2006 12:23 pm
Posts: 199
Location: Brasov, Romania
Reply with quote
Post 
Most probably the Linked To Source property is set for the axis. See ExcelAxis.IsNumberFormatLinked() value.
You shoud try to uncheck this option in the xls file that you are reading and try to set the number format for the axis.


Wed Nov 28, 2007 4:36 am
Profile WWW

Joined: Tue Nov 06, 2007 4:38 am
Posts: 8
Reply with quote
Post 
Thanks Daniela,
I turned off the "Link To Source" option, but no helps.
Is there another way?


Mon Dec 03, 2007 7:18 am
Profile

Joined: Wed Nov 07, 2007 4:42 am
Posts: 67
Reply with quote
Post 
I tried to uncheck the "Linked To Source" option myself and it worked. Do this in your xls document using Microsoft Excel, not in your EasyXLS code. That should solve your problem.


Tue Dec 04, 2007 6:55 am
Profile WWW
Display posts from previous:  Sort by  
Reply to topic   [ 4 posts ] 

Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.