As a way to learn pascal/lazarus I'm writing an own spreadsheet application using fpSpreadsheet, now I would like to use defined names in the worksheet.
So far I have managed to name cells / cell ranges in code and also ,in code, write formulas using the defined name into a cell.
When I run my application everything works and the cells with formulas are showing correct values, also when I change values in the named cells the formula cells are working fine.
The problem is when I try to edit the formula or enter a new formula in an empty cell I get error message: "unknown identifier: MyCellName".
If I save the spreadsheet in xlsx format and open it with Excel everything works perfekt an I can use the names in new formulas and edit the existing formulas.
The question is now is this a limitation in fpSpreadsheet or am I forgetting something?
I did try to find this subject in the forum but didn't succeed, if my question has already been answered I apologize and ask you kindly to post the link to the appropriate post.
Thanks in advance for your support
Using: Lazarus 4.6 , FPC 3.2.2 , fpSpreadsheet 2.0.0.0 (from OPM) on a WIN 11 computer