I'm most interested in reading the background color of the cell, as I would be iterating through the entire spreadsheet
Villeroy wrote:Hiding information in formatting attributes is a mistake. You would be better off if you could convert the color information into cell data as demonstrated here: http://forum.openoffice.org/en/forum/vi ... 61#p194261
--------------
Virtually nobody manipulates this office suite with C++. because it is far too complicated. You won't gain any performance anyway because every single API call takes a lot of time regardless of the language. Here is the SDK package which includes some documentation and example code: https://www.openoffice.org/api/SDK/
I looked at the link, and it had an ODS file that used a function called CELL-BACKCOLOR(), but even with the RGB extension installed, I don't see this function in the function list.
Zizi64 wrote:I looked at the link, and it had an ODS file that used a function called CELL-BACKCOLOR(), but even with the RGB extension installed, I don't see this function in the function list.
The macro embedded into the linked document is a simple macro, but not an Add-in. Only those custom functions will be appeared in the function list of the Calc, what are structured and embedded into an Add-in extension (The Add-in is a specific type of the .oxt files.)
The usual macros will work when you call by them by name, but they will not be appeared in the function list. You must know the name of the macro function (you can examine the macro code in the IDE)
Users browsing this forum: No registered users and 1 guest