Hello Axolot,
I have a problem with DecodeFmla:
I try to build a interface for DrwChart-Properties, and I have problems with the property DrwChart.Series[0].Values:
The first problem, which I could fix:
if the SheetName contains non-alpha-numeric-chars, the sheet name is not quotet!
I fixed this problem in TFormulaHandler.GetName
by introducing
Result := QuoteName(FSheetDataEvent(sdtName,i,-1,-1)) + '!', whereby "QuoteName" quoted the sheetname if neccessary.
Now the second problem, which I cannot fix:
If I set the property DrwChart.Series[0].SerieName by a quoted value (example "My Serie") the
property DrwChart.Series[0].Values shows a wrong value (message: 'Bad element ID #33 in arra}').
If the property DrwChart.Series[0].SerieName is empty, everything works fine!
I think, the bug must be in the method DecodeFmla.
Can you help me?
Thanks in advance
Hans-Jürgen Schnorrenberg