Re: [libreoffice-users] [calc] Get a list of conditional formattings

Hi Jean-Francois,

Jean-Francois Nifenecker schrieb:
> 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.

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







--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted