Re: [libreoffice-users] [calc] Get a list of conditional formattings
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: users+unsubscr...@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
Re: [libreoffice-users] [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 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" < > jean-francois.nifenec...@laposte.net> 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: users+unsubscr...@global.libreoffice.org > 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: users+unsubscr...@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 > -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] [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" < jean-francois.nifenec...@laposte.net> 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: users+unsubscr...@global.libreoffice.org 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: users+unsubscr...@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
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 . In addition some of the conditions are written in attributes as defined by ODF 1.2. In case you use ODF 1.2, only 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+unsubscr...@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
Re: [libreoffice-users] [calc] Get a list of conditional formattings
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: users+unsubscr...@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
Re: [libreoffice-users] [calc] Get a list of conditional formattings
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: users+unsubscr...@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
Re: [libreoffice-users] [calc] Get a list of conditional formattings
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 . In addition some of the conditions are written in attributes as defined by ODF 1.2. In case you use ODF 1.2, only 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: users+unsubscr...@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
Re: [libreoffice-users] [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" < jean-francois.nifenec...@laposte.net> 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: users+unsubscr...@global.libreoffice.org 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: users+unsubscr...@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
Re: [libreoffice-users] [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" < jean-francois.nifenec...@laposte.net> 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: users+unsubscr...@global.libreoffice.org > 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: users+unsubscr...@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
[libreoffice-users] [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: users+unsubscr...@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