Charts in XLSReadWriteII 5

[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

[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.

[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.

[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...