Forum > FPSpreadsheet
How to create on cell combobox
Packs:
How to create on cell combobox
wp:
Contributions are welcome. A possible patch should
- create the infrastructure within fpspreadsheet for cell combobox
- provide a reader/writer for at least xlsx and ods files.
Packs:
according to you this is possible
Packs:
How to embed combobox or picklist inside excel cell
wp:
First study how Excel achieves this (I never used comboboxes inside Excel, so I don't know it by heart - but I guess you must provide some cells which contain the combobox items). Then use Excel to create a simple xlsx file with such a combobox. xlsx is a zip file containing several xml files, unzip it and look at the file xl/worksheets/sheet1.xml. Find out which xml nodes excel writes into this file to create the combobox.
Next step is to simulate the same in FPSpreadsheet. Study the source code of this library (sorry, I cannot give you a lengthy description here, there is a documentation of usage in http://wiki.lazarus.freepascal.org/FPSpreadsheet, but not of internal details). Find a way how to extend the TsWorksheet class such that the the combobox items and the information that a cell contains a combobox can be incorporated.
Then extend the xlsx reader unit xlsxoosml.pas such that it can detect the embedded combobox and move it into the internal fpspreadsheet structures. Likewise, extend the xlsx writer (also in xlsxooxml) such that it can write the information for the combobox into the xml file so that excel understands it.
Navigation
[0] Message Index
[#] Next page