Re: [libreoffice-users] LO base reference?

2017-05-07 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Dave, > > I'm involved in a project that will produce a dataset as its > product. I'm considering using LO base so as to avoid vendor > lock-in. I've found a base document from 2014 that seems promising, > is there a more up-to-date place to start

Re: [libreoffice-users] COUNTIF / DAYS / ?

2017-05-07 Thread Remy Gauthier
Hi, If you have one row per day of the year, you can find out easily where the row corresponding to "TODAY()-1" is located by finding out the number of days between Jan 1st of that year and "yesterday". This would be something like (you may need to adjust based on the heading of your column(s)):

[libreoffice-users] COUNTIF / DAYS / ?

2017-05-07 Thread Hylton Conacher (ZR1HPC)
Hi, I have a spreadsheet I use to draw graphs and extract information about the rainfall in my area for the last two years. I need to create a formula that will count how many days it rained between the start of the year, both last year and this year, so I can compare the amount of rainfall

Re: [libreoffice-users] Re: Libre Writer - special characters

2017-05-07 Thread Philip Jackson
On 06/05/17 23:17, V Stuart Foote wrote: > Input the character via its Unicode value, and toggle. > > So, here enter "U+211e" and then use +X to toggle. Thank you Stuart for the key to the toggle. I've wondered how to enter unicode characters for a long time. And have tried all the ctrl-shift

Re: [libreoffice-users] Re: Libre Writer - special characters

2017-05-07 Thread Dave
On 07.05.2017 20:59, V Stuart Foote wrote: > Dave-3 wrote >> That's interesting. If I try every possible combination of this method >> with Writer under Win 7, all I get is a lower case x. It this something >> peculiar to Linux or OSX? > > Added for the 5.1.0 release. It works with all OS, see

[libreoffice-users] Frecuency Distribution

2017-05-07 Thread jorge
Hi all: Would you please help me with this ? If I have a number of data about some topic, how can I get the type of distribution using the LibreOffice's formula ? How can I know if it is normal, gamma, etc. ? There is a way ? For example: YearInflation of CR 1977

Re: [libreoffice-users] Re: Libre Writer - special characters

2017-05-07 Thread Dave
On 07.05.2017 20:01, Philip Jackson wrote: > On 06/05/17 23:17, V Stuart Foote wrote: >> Input the character via its Unicode value, and toggle. >> >> So, here enter "U+211e" and then use +X to toggle. > Thank you Stuart for the key to the toggle. I've wondered how to enter > unicode characters

[libreoffice-users] Re: Libre Writer - special characters

2017-05-07 Thread V Stuart Foote
Dave-3 wrote > That's interesting. If I try every possible combination of this method > with Writer under Win 7, all I get is a lower case x. It this something > peculiar to Linux or OSX? Added for the 5.1.0 release. It works with all OS, see tdf#73691

Re: [libreoffice-users] COUNTIF / DAYS / ?

2017-05-07 Thread Steve Edmonds
Hi. Is the rainfall data regular (every day) or sporadic. If sporadic, is the amount of rainfall cumulative since the previous date. I also take it that you want 2 outputs. The total amount of rainfall over the desired period and the number of data points on which rainfall was recorded over

Re: [libreoffice-users] Frequency Distribution

2017-05-07 Thread Brian Barker
At 14:10 07/05/2017 -0600, Jorge Rodríguez wrote: If I have a number of data about some topic, how can I get the type of distribution using the LibreOffice's formula ? How can I know if it is normal, gamma, etc. ? There is a way ? For example: Year Inflation of CR 19775,24971553 1978