Date: prev next · Thread: first prev next last
2017 Archives by date, by thread · List index

Hi :)
I'm not sure if this is still relevant but ...

There are guides on;

Chapter 12 of the Calc Guide.

There is also an excellent unofficial guide about Macros written by Andrew

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

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 <> 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" <> 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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.