[calc] Get a list of conditional formattings

classic Classic list List threaded Threaded
10 messages Options
Jean-Francois Nifenecker Jean-Francois Nifenecker
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[calc] Get a list of conditional formattings

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,
--
Jean-Francois Nifenecker, Bordeaux


--
To unsubscribe e-mail to: [hidden email]
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
Gabriele Ponzo Gabriele Ponzo
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [calc] Get a list of conditional formattings

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 showing them all.

Isn't it enough for your need?

Il 8 lug 2017 10:57 PM, "Jean-Francois Nifenecker" <
[hidden email]> ha scritto:

> 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,
> --
> Jean-Francois Nifenecker, Bordeaux
>
>
> --
> To unsubscribe e-mail to: [hidden email]
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> 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
>

--
To unsubscribe e-mail to: [hidden email]
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
steveedmonds steveedmonds
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [calc] Get a list of conditional formattings

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 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 showing them all.
>
> Isn't it enough for your need?
>
> Il 8 lug 2017 10:57 PM, "Jean-Francois Nifenecker" <
> [hidden email]> ha scritto:
>
>> 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,
>> --
>> Jean-Francois Nifenecker, Bordeaux
>>
>>
>> --
>> To unsubscribe e-mail to: [hidden email]
>> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
>> ubscribe/
>> 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
>>


--
To unsubscribe e-mail to: [hidden email]
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
Regina Henschel Regina Henschel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [calc] Get a list of conditional formattings

In reply to this post by Jean-Francois Nifenecker
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: [hidden email]
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
Regina Henschel Regina Henschel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [calc] Get a list of conditional formattings

In reply to this post by Gabriele Ponzo
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 LO) that there is
> a dialog window showing them all.
>
> Isn't it enough for your need?

Yes it is in Format > Conditional Formatting > Manage. But you need to
select each item and click on "Edit..." to get the details about the
condition.

Kind regards
Regina


--
To unsubscribe e-mail to: [hidden email]
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
Jean-Francois Nifenecker Jean-Francois Nifenecker
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [calc] Get a list of conditional formattings

In reply to this post by Gabriele Ponzo
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 lessons (I'm a teacher of LO) that there
> is a dialog window showing them all.
>
> Isn't it enough for your need?

I probably didn't make myself clear enough: I know of the UI you're
talking about. I'm in need of some way to list them all separately on a
document of some sort. Thanks anyway. I'll read about Regina's hints
which seem to do what I need.


All the best,
--
Jean-Francois Nifenecker, Bordeaux


--
To unsubscribe e-mail to: [hidden email]
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
Jean-Francois Nifenecker Jean-Francois Nifenecker
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [calc] Get a list of conditional formattings

In reply to this post by Regina Henschel
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: [hidden email]
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
Gabriele Ponzo Gabriele Ponzo
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [calc] Get a list of conditional formattings

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" <
[hidden email]> ha scritto:


...


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.


Please consider filling it in bugzilla as feature request, after a quick
look if someone else already did it.


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


I've never been there, but I've been told it's a beautiful area.
Probably one of the few still missing to visit in France for me. Hope to
come sooner or later ;)




--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
ubscribe/
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

--
To unsubscribe e-mail to: [hidden email]
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
TomD TomD
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [calc] Get a list of conditional formattings

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 macros can be written in a variety of
languages - and that includes sensible languages such as C++ and Python.
So you don't need to have someone learn a language specifically for
"Office".  Also macros don't need to be written in an archaic, easily
corruptible, flaky version of Basic.  So macros are much less likely to
suffer breakage when you upgrade to a newer version of "Office"

Another advantage is the relative ease of writing add-ons/plug-ins.
LibreOffice was one of the first programs (under a previous name) to offer
such a feature and went with the name "Extensions".  Again these can be
written in a wide variety of languages and either published under a wide
variety of licenses or kept in-house.  Personally i'd tend to recommend an
OpenSource license such as GPL or Mozilla License to free yourself up from
'having to' keep it updated yourself - and publishing it gives a much
larger potential audience of testers&users to help the code mature faster
and be more robust.


By far the biggest advantage of LibreOffice for organisations (imo) is the
ability to employ a dev locally to work on your company's own tier 3 issues
or pet bugs or on developing add-ons or macros or whatever your company
chooses as the priority.  This could be as a part-timer or as part of an
in-house team and could vary over time to suit the amount of work your
company needs to have done.  Your company's dev(s) might work on other
OpenSource projects such as Firefox/Chrome and whatever esle - or they
could be allowed to work on general developments within LibreOffice.
Whichever way they would be working with an international team but giving
your company a very tight focus on the work they see as being most
important to them.

Almost invariably employing dev(s) is MUCH less expensive than the costs of
buying licenses for equivalent proprietary software.  If around 10% of the
cost of such licenses is enough to be a salary for a dev then it's well
worth considering.

One company, openSuSE, found it worthwhile to employ so many devs that
eventually that whole support department budded off to form an independent
company who openSuSE now outsource a lot of their work to.  Collabora now
have several companies and individuals who they provide professional
support services to so they are not completely dependent on openSuSE any
more.

Of course outsourcing the work significantly reduces the dedication of the
support staff and the control you have over them but it also dramatically
reduces costs so some sort of combination of in-house and outsourcing might
be the best-fit for your company.

Regards from
Tom :)



On 9 July 2017 at 09:12, Gabriele Ponzo <[hidden email]> wrote:

> 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" <
> [hidden email]> ha scritto:
>
>
> ...
>
>
> 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.
>
>
> Please consider filling it in bugzilla as feature request, after a quick
> look if someone else already did it.
>
>
> Thanks again,
> Cheers from France,
> --
> Jean-Francois Nifenecker, Bordeaux
>
>
> I've never been there, but I've been told it's a beautiful area.
> Probably one of the few still missing to visit in France for me. Hope to
> come sooner or later ;)
>
>
>
>
> --
> To unsubscribe e-mail to: [hidden email]
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> 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
>
> --
> To unsubscribe e-mail to: [hidden email]
> 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
>

--
To unsubscribe e-mail to: [hidden email]
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
Jean-Francois Nifenecker Jean-Francois Nifenecker
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [calc] Get a list of conditional formattings

In reply to this post by Gabriele Ponzo
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 Italy are (dunno many of them but I
appreciated all the ones I visited so far).

All the best,
--
Jean-Francois Nifenecker, Bordeaux


--
To unsubscribe e-mail to: [hidden email]
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
Loading...