Forum > FPSpreadsheet
Access to defined names in an excel workbook
wp:
Implemented defined names for the xlsx and ods file formats. They can be used in formulas, as well. See the demo projects in the folder examples/other/defined_names.
Note: this code is not yet in the OPM version, you must use the ccr version to get it (use svn or download the zipped snapshot from https://sourceforge.net/p/lazarus-ccr/svn/HEAD/tree/components/fpspreadsheet/.
veb86:
Cool. Very cool. A necessary feature!
Sorry, please. Look, maybe it's not hard to add a list of validations. Or conditional formatting, so that a cell can change color depending on the value inside this or another cell. This would help to liven up the resulting file.
wp:
I want to complete defined names first, there are still some issues. Conditional formatting has already been added some time ago (as I see now it is missing in the documentation so far, just like chart support).
Jiří Huňáček:
I appreciate the addition of Define Names. I downloaded the zipped snapshot today but it doesn't load the define names. So, maybe there's a bug in the code that I'm not seeing. I am attaching a test project and an XLSX file.
I'm using MS Excel 365.
Navigation
[0] Message Index
[*] Previous page