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 <[email protected]> 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" < > [email protected]> 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: [email protected] > 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: [email protected] > 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: [email protected] 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
