Access to defined names in an excel workbook lazarus / 49-FPSpreadsheet ---------------------------------------------------------------------- Jiří Huňáček · 2024-07-21 17:00 Hello, I can't find a solution for my problem on the internet. So far I can access individual cells through the FPSspreadsheet library, but I would need to find a way to access the defined names in the excel workbook - creating a list for selection and then finding out the specific range of the selected name for data import. I am grateful for any advice George ---------------------------------------------------------------------- wp · 2024-07-21 17:08 Sorry, but defined names have not yet been implemented in fpspreadsheet. ---------------------------------------------------------------------- Jiří Huňáček · 2024-07-21 18:11 Yes, I know that too, but I'm wondering if anyone knows of any other solution, perhaps some other library. ---------------------------------------------------------------------- zeljko · 2024-07-21 20:17 Maybe commercial TMS FlexCell ? ---------------------------------------------------------------------- wp · 2024-07-21 22:33 Quote from: wp on July 21, 2024, 07:08:57 pmSorry, but defined names have not yet been implemented in fpspreadsheet. Had a look into the xml of an xlsx file with named cells - looks easy. Please give me some time. ---------------------------------------------------------------------- wp · 2024-07-25 21:39 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 · 2024-07-29 07:18 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 · 2024-07-29 09:12 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 · 2024-09-01 09:37 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.