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

2017-07-09 Thread Jean-Francois Nifenecker
Gabriele, Le 09/07/2017 à 10:12, Gabriele Ponzo a écrit : Please consider filling it in bugzilla as feature request, after a quick look if someone else already did it. Done. Bugzilla #109035. I've never been there, but I've been told it's a beautiful area. it is, just like many places in

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

2017-07-09 Thread Tom Davies
Hi :) I'm not sure if this is still relevant but ... There are guides on; https://wiki.documentfoundation.org/Documentation/Publications Chapter 12 of the Calc Guide. There is also an excellent unofficial guide about Macros written by Andrew Pitonyak. One advantage of LibreOffice is that

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

2017-07-09 Thread Gabriele Ponzo
Now I got what you meant, sorry. And thanks to Regina for pointing out what I meant and the solution for your need. Il 9 lug 2017 8:37 AM, "Jean-Francois Nifenecker" < jean-francois.nifenec...@laposte.net> ha scritto: ... BTW, as documenting is a key point of spreadsheets develepment, I

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

2017-07-09 Thread Jean-Francois Nifenecker
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 . In addition some of the conditions are written in attributes as defined by ODF 1.2. In case

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

2017-07-09 Thread Jean-Francois Nifenecker
Gabriele, Le 08/07/2017 à 23:30, Gabriele Ponzo a écrit : I'm on the smartphone at the moment, but I'm quite sure the UI does list the conditional formatting existing on a sheet or in a file. It should be in a specific sub menu item to manage such feature. I clearly remember from my last

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

2017-07-08 Thread Regina Henschel
Hi Gabriele, Gabriele Ponzo schrieb: I'm on the smartphone at the moment, but I'm quite sure the UI does list the conditional formatting existing on a sheet or in a file. It should be in a specific sub menu item to manage such feature. I clearly remember from my last lessons (I'm a teacher of

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

2017-07-08 Thread Regina Henschel
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

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

2017-07-08 Thread Steve Edmonds
On 5.2. Format>Conditional Formatting. Remembering to create the styles that will be applied by the condition first. Steve On 09/07/17 09:30, Gabriele Ponzo wrote: I'm on the smartphone at the moment, but I'm quite sure the UI does list the conditional formatting existing on a sheet or in a

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

2017-07-08 Thread Gabriele Ponzo
I'm on the smartphone at the moment, but I'm quite sure the UI does list the conditional formatting existing on a sheet or in a file. It should be in a specific sub menu item to manage such feature. I clearly remember from my last lessons (I'm a teacher of LO) that there is a dialog window

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

2017-07-08 Thread Jean-Francois Nifenecker
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