Re: [libreoffice-users] Question on wildcards

At 22:46 05/02/2017 +0100, Rob Jasper wrote: I am looking for a way to use MAXIFS over the equivalent ranges in multiple tabs. Something like: =COUNTIF('2*'.E$2:E$200;C2) Explanation: For all ranges in tabs with name 2.* (2002, 2003, 2004, etc.), range E2:E200 give me the number of occurrences

Re: [libreoffice-users] How to make chart out of a multi-sheet ods file ?

at bottom :- On 06/02/2017, Cley Faye wrote: > 2017-02-05 22:32 GMT+01:00 shirish शिरीष : > >> Now what I want to do is to make chart from say either page 2 or page >> 3 but unable to figure out how to do it ? >> > > W > ​hen creating a chart​, you can

Re: [libreoffice-users] How to make chart out of a multi-sheet ods file ?

2017-02-05 22:32 GMT+01:00 shirish शिरीष : > Now what I want to do is to make chart from say either page 2 or page > 3 but unable to figure out how to do it ? > W ​hen creating a chart​, you can either prefix your intervals with $. or use the button on the right of each

[libreoffice-users] Question on wildcards

Hi, I am looking for a way to use MAXIFS over the equivalent ranges in multiple tabs. Something like: =COUNTIF(‘2*'.E$2:E$200;C2) Explanation: For all ranges in tabs with name 2.* (2002, 2003, 2004, etc.), range E2:E200 give me the number of occurrences of the value define in C2 Is this at

[libreoffice-users] How to make chart out of a multi-sheet ods file ?

Dear Friends, I want to make a chart from content in a multi-sheet file. As an example to illustrate, I use https://ec.europa.eu/home-affairs/sites/homeaffairs/files/what-we-do/policies/borders-and-visas/visa-policy/docs/2015_consulates_schengen_visa_stats_en.xlsx . I converted the .xlsx to .ods

Re: [libreoffice-users] Verified fatal error

Thanks for the feedback. I'll give it a try. John On 02/05/2017 04:30 AM, Bruce Hohl wrote: This is not really an answer but ... sometimes I have a problem with my Windows PC at work, and the IT person confirms the problem, but trouble shooting the problem will take longer than reinstalling

Re: [libreoffice-users] Verified fatal error

This is not really an answer but ... sometimes I have a problem with my Windows PC at work, and the IT person confirms the problem, but trouble shooting the problem will take longer than reinstalling ... so by analogy I suggest you rebuild the spreadsheet starting with File > New > Spreadsheet.

Re: [libreoffice-users] LibreOffice Help in version 5.3.0.3

2017-02-04 20:28 GMT+01:00 Bruce Hohl : > Did you install the separate help package for 5.3.0.3? > http://www.libreoffice.org/download/download/?type=deb-x86_6 > 4=5.3.0=pick > > On Sat, Feb 4, 2017 at 12:47 PM, M Henri Day wrote: > > > ​After upgrading