Chart: incorrect number format for Date of X-Axis
Page 1 of 1

Author:  khanhtran [ Mon Nov 26, 2007 10:00 pm ]
Post subject:  Chart: incorrect number format for Date of X-Axis

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:


Author:  daniela [ Wed Nov 28, 2007 4:36 am ]
Post subject: 

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.

Author:  khanhtran [ Mon Dec 03, 2007 7:18 am ]
Post subject: 

Thanks Daniela,
I turned off the "Link To Source" option, but no helps.
Is there another way?

Author:  oana [ Tue Dec 04, 2007 6:55 am ]
Post subject: 

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.

Page 1 of 1 All times are UTC - 4 hours
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group