[calc] Get a list of conditional formattings

fr-users
#1

Hi,

(official LibO 5.x under win7 and Linux Debian 9)

I'm developping in a corporate environment a number of spreadsheets using Calc. In many of those, I'm using conditional formatting, sometimes quite heavily.

As I want to precisely document the ins and outs of the spreadsheets for the users and future maintainers, I'm looking for a way to list those conditional formattings.

Any hint would be appreciated about a way to do this, which means with macros, of course, as the UI doesn't seem to give any other way. I haven't found any hint in the API but might certainly have overlooked smthg.

TIA.
Best regards,

#2

Oups. Mauvaise liste :frowning:
Grrr...

Désolé pour le bruit. Bon si vous avez une réponse, je prends quand même :wink:

Bien cordialement,

#3

Bonjour,

pour ceux que ça pourrait intéresser, voici la réponse qu'a fournie Regina Henschel sur la liste users@global.libreoffice.org:

8< ----------------------------------------------------------

You can get all conditions from the saved file. In case you use "ODF 1.2. extended" the conditions are written in the LO-specific element <calcext:conditional-formats>. In addition some of the conditions are written in <style:map> attributes as defined by ODF 1.2. In case you use ODF 1.2, only <style:map> attributes are used, so that not all kind of conditions are possible.

In the API look for "Condition..." in the com::sun::star::sheet module reference (in the SDK).

For the ODF 1.2 strict way, you can look at https://wiki.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Conditional_Formats

You might consider to write all hints and explanations more human readable into a separate (hidden?) sheet.

Kind regards
Regina

---------------------------------------------------------- >8

En parallèle, j'ai soumis la demande d'amélioration :
https://bugs.documentfoundation.org/show_bug.cgi?id=109035

Bon dimanche,