Page 1 of 1
Charts in XLSReadWriteII 5
Posted: Tue Mar 05, 2013 12:43 pm
by harmelzinga
Does this version also support charts?
I found some classes and tried to access them, but without any luck.
Is there a very simple example?
Best regards, Harm
Re: Charts in XLSReadWriteII 5
Posted: Wed Mar 06, 2013 2:54 pm
by larsa
Hello
Charts is possible but not easy as right now the only option is to access the raw file data, and this is a bit complicated. There will be a better solution for charts in a later update.
Re: Charts in XLSReadWriteII 5
Posted: Wed Mar 27, 2013 3:04 am
by Roman55
Hello
Need charts support also. After porting my code to version 5, got an error on this line when trying to set values for series:
Code: Select all
Series[0].Values := 'Data!$B$2:$B$102';
The error is below:
Code: Select all
Exception EAccessViolation: Access violation at address 00000000. Read of address 00000000 (OS exception)
exception at $00000000
Stack trace:
Module "BIFF_FormulaHandler5", Procedure "BIFF_FormulaHandler5.TFormulaHandler.GetName", Unit "BIFF_FormulaHandler5.pas", Line 268
Module "BIFF_DecodeFormula5", Procedure "BIFF_DecodeFormula5.DecodeFmla", Unit "BIFF_DecodeFormula5.pas", Line 475
Module "BIFF_DrawingObjChart5", Procedure "BIFF_DrawingObjChart5.TXLSChartSerie.CalcValueCount", Unit "BIFF_DrawingObjChart5.pas", Line 1719
and the line failed is (function TFormulaHandler.GetName)
Code: Select all
Result := FSheetDataEvent(sdtName,i,-1,-1) + '!'
The output file version is Excel97.
Re: Charts in XLSReadWriteII 5
Posted: Tue May 07, 2013 5:15 am
by Roman55
Is there any update on this, Lars? I know you plan to deal with charts later, but this seems to be a small bug, because everything else related to chart works normally. With the "Series[0].Values := ... " commented, I get the chart with all its settings, even with X-values. It just lacks Y-values.
Please fix this if possible. Without it I can't deploy my app...