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

Hi Regina,

Le 09/07/2017 à 00:18, Regina Henschel a écrit :
> 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.

Not sure I'll go the file-unpacking route but this might be a way.

> 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

Thanks a lot for your insights. I'll have a look.

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

In fact this is the aim.

BTW, as documenting is a key point of spreadsheets develepment, I think 
this conditional formatting listing could/should be made available 
somewhere in the UI, à-la range names insert.


Thanks again,
Cheers from France,
--
Jean-Francois Nifenecker, Bordeaux


--
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