Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...

2019-12-11 Thread zed
Johnny Rosenberg wrote: > Den ons 11 dec. 2019 kl 05:51 skrev zed : > > > Hi! > > > > Using LibreOffice v6.0.7.3 on Linux Mint v19.2 Mate > > > > I have a spreadsheeet in Calc which records data of reactions to a > > particular performer. It is in the form: It has Columns A - G. > > > > A -

Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...

2019-12-11 Thread zed
Brian Barker wrote: > At 17:49 11/12/2019 +1300, David Noname wrote: > > I have a spreadsheet in Calc ... It has Columns ... B - No, formatted > > number general ... > > > > Is there a formula that I can enter in Column B which will increase > > incrementally increase the figure by 1, please? >

Re: [libreoffice-users] copying a ODS file and setting some cells to value in old file

2019-12-11 Thread Fred James
Johnny Rosenberg wrote: Den ons 11 dec. 2019 kl 19:55 skrev Fred James : (Please forgive me if this is a duplicate ... thank you) I do this every year, but this year I am experiencing problems OS Mageia 7, Plasma LibreOffice 6.2.8.2 The original file is an 18 sheet ODS file used for budget

Re: [libreoffice-users] copying a ODS file and setting some cells to value in old file

2019-12-11 Thread Johnny Rosenberg
Den ons 11 dec. 2019 kl 19:55 skrev Fred James : > (Please forgive me if this is a duplicate ... thank you) > > I do this every year, but this year I am experiencing problems > > OS Mageia 7, Plasma > LibreOffice 6.2.8.2 > > The original file is an 18 sheet ODS file used for budget purposes > > I

[libreoffice-users] copying a ODS file and setting some cells to value in old file

2019-12-11 Thread Fred James
(Please forgive me if this is a duplicate ... thank you) I do this every year, but this year I am experiencing problems OS Mageia 7, Plasma LibreOffice 6.2.8.2 The original file is an 18 sheet ODS file used for budget purposes I can successfully copy the original file (in original location)

[libreoffice-users] How to visualize columns without exponential numbers with E-0...

2019-12-11 Thread GioMBG
Hi All, hope to find ALL You fine, first I'm not a mathematician, I just open a xlsx file where I see a lot of numbers, I suppose in exponential mode... for example I see : 1.6E-05 ( what I suppose are in exponential ) I would like to see as "normal" I prefer : 0.16 any suggestion ? always

Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...

2019-12-11 Thread Johnny Rosenberg
Den ons 11 dec. 2019 kl 05:51 skrev zed : > Hi! > > Using LibreOffice v6.0.7.3 on Linux Mint v19.2 Mate > > I have a spreadsheeet in Calc which records data of reactions to a > particular performer. It is in the form: It has Columns A - G. > > A - Name, fformatted as Text (records thre name of

Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...

2019-12-11 Thread Brian Barker
At 17:49 11/12/2019 +1300, David Noname wrote: I have a spreadsheet in Calc ... It has Columns ... B - No, formatted number general ... Is there a formula that I can enter in Column B which will increase incrementally increase the figure by 1, please? I think you are saying that you want