Code to read the active cells format

[Fraz627]

Pretty new at Open office and I've tryed searching the web but find no clear anwsers.
How does one go about reading the cells format such as color, patterns, numberic, text or date/time

Thanks

[Zizi64]

How does one go about reading the cells format such as color, patterns, numberic, text or date/time

What you want to read really: the name of the applied cell style, the propreties of the applied style or the direct formatting properties of the cells?

You can get the name of the applied style by a cell formula based on a macro code (it will not work with the stylename applied by the conditional format feature):
viewtopic.php?f=21&t=2762
viewtopic.php?t=27574

...or directly by a macro code:

Code: Select all

Dim sTyle as String
Dim oCell as Object
...
REM You must get the cell object here: the actually selected one or you can get a cpecific cell by its coordinates or by its reference/name
...
sStylename = oCell.CellStyle

https://www.openoffice.org/api/docs/com ... Style.html

And you can get/modify the properties of a specific cell:
viewtopic.php?f=25&t=41387


Tip:
Install the MRI or the XrayTool to examine programming object in your macro code.

[Villeroy]

viewtopic.php?t=37989&p=183658#p183658

[Fraz627]

Thanks I'm still learning