Recent

Author Topic: [SOLVED] DefinedNames in fpSpreadsheet, not working properly in a WorkSheetGrid  (Read 1023 times)

Kaljakoira

  • Newbie
  • Posts: 3
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
« Last Edit: March 03, 2026, 11:34:10 am by Kaljakoira »

wp

  • Hero Member
  • *****
  • Posts: 13401
Should be fixed now in the CCR version of fpspreadsheet (svn), r9979-9981. Either use svn or download the snapshot from https://sourceforge.net/p/lazarus-ccr/svn/HEAD/tree/components/fpspreadsheet/
« Last Edit: March 02, 2026, 10:41:51 pm by wp »

Kaljakoira

  • Newbie
  • Posts: 3
Thanks for your reply, will download the CCR version and check it out asap. Will revert here with the result

Kaljakoira

  • Newbie
  • Posts: 3
Thanks again wp! Everything works fine now and I have marked the post as solved.

 

TinyPortal © 2005-2018