Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...
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 - Name, fformatted as Text (records thre name of the persons doing the > > reaction) B - No, formatted number general (records number of times this > > reactors has reacted to the performer) C - First, formatted DD/MM/YY > > (records the first date the reactor reaacted to this performer) D - > > Last, formatted DD/MM.YY (records last date reactor reacted to this > > performer) E - Days, formatted =NOW()-D3 (records number of days since > > last reaction) F - Weeks, formatted =E3/7 (records number of weeks since > > last reaction) G - Months, formatted =F3/4 (records number of months > > since last reaction. reaction) > > > > Is there a formula that I can enter in Column B which will increase > > incrementally increase the figure by 1, please? > > > > Regards from New Zealand on a very warm summer evening. > > > > David -- Zed > I'm not sure I understand what you are asking for here. So in column A, > there are names, as you said, and in column B there's a number that tells > you how many times the name in Column A appeared so far? Then I guess the > following would work: B1: =IF(A1="";"";COUNTIF(A$1:A1;A1)) Click and drag > the formula downwards. Now, for instance B17 looks like this: > =IF(A17="";"";COUNTIF(A$1:A17;A17)) The IF is just to not display a zero > when nothing is entered into the corresponding A line. Thank you for your quick response. Unfortunately that didn't work. That was probably because I didn't explain myself carefully enough. Have a look at my answer to Brian Barker, where I try to be clearer in what I'm trying to achieve. If there is a solution I will think all my Christmases have come at once! But I am resigned to the fact that there probably isn't. David -- Zed "I have often regretted my speech, never my silence." Xenocrates (396-314 B.C.) -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...
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? > > I think you are saying that you want values in column B to be one greater > than they are. That's a contradiction. If the value in Bn is four, you > want it to be five. But that means it's no longer four. And if it's now > five, how would any formula know you do not want it to be six? And so on? Thank you for your prompt reply, Brian. It is much appreciated Perhaps I didn't explain myself clearly enough. In simple terms, I want to know whether there is any way that when I enter a new date in Column D it will automaticall increase the current value in Column B by 1. I cannot think of a solution - but then I only use Calc for simple things - but was hoping that there is a solution. If there isn't, I will just have to try and remember to manually increase the value of Column B every time I enter a new date in Column D. David -- Zed Smoking kills. If you're killed, you've lost a very important part of your life. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] copying a ODS file and setting some cells to value in old file
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 purposes I can successfully copy the original file (in original location) to the new file (in new location), either by ... open the old file and save-as (File -> Save As) or open Dolphin file manager, copy the old file, paste the file into a new location, and rename it to the new file or open a terminal and perform the copy operation there (cp oldlocation/oldfilename newlocation/newfilename Then in the new file, I delete unwanted sheets and data to start the year fresh. Next I set the values of some cells in the new file, to the values of some cells in the old file. (Example: ='file:///home/fredjame/mystuff/budget/2019/budget_2019.ods'#$'TD December 2019'.F114) This has always worked well in the past, but this year, I am getting an error in the destination cell ... at first that was ErrL514, and now it is Err:540. Can you advise, please? https://help.libreoffice.org/6.3/ar/text/scalc/05/0214.html?DbPAR=CALC Thank you for the URL. I found the definition of Err:540 ... "External content disabled". From there I looked at LibreOffice help and found the instructions for inserting the reference/link to the cell in the other ODS file "To Reference a Cell in Another Document", which I followed right up to "Confirm the formula by clicking the green check mark.", but I don't have a green check mark to click. Then I tried looking for where the external content might be disabled/enabled ... no luck so far. Answers to the question(s) at Google seem to be written for other versions of Libreoffice, because they don't match too well to anything in this version (6.2.8.2) Can you advise, please? Thanks again Regards Fred James -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] copying a ODS file and setting some cells to value in old file
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 can successfully copy the original file (in original location) to the > new file (in new location), either by ... > open the old file and save-as (File -> Save As) > or > open Dolphin file manager, copy the old file, paste the file into a > new location, and rename it to the new file > or > open a terminal and perform the copy operation there (cp > oldlocation/oldfilename newlocation/newfilename > > Then in the new file, I delete unwanted sheets and data to start the > year fresh. Next I set the values of some cells in the new file, to the > values of some cells in the old file. (Example: > ='file:///home/fredjame/mystuff/budget/2019/budget_2019.ods'#$'TD > December 2019'.F114) > > This has always worked well in the past, but this year, I am getting an > error in the destination cell ... at first that was ErrL514, and now it > is Err:540. > > Can you advise, please? > https://help.libreoffice.org/6.3/ar/text/scalc/05/0214.html?DbPAR=CALC > Thank you > Regards > Fred James > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] copying a ODS file and setting some cells to value in old file
(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) to the new file (in new location), either by ... open the old file and save-as (File -> Save As) or open Dolphin file manager, copy the old file, paste the file into a new location, and rename it to the new file or open a terminal and perform the copy operation there (cp oldlocation/oldfilename newlocation/newfilename Then in the new file, I delete unwanted sheets and data to start the year fresh. Next I set the values of some cells in the new file, to the values of some cells in the old file. (Example: ='file:///home/fredjame/mystuff/budget/2019/budget_2019.ods'#$'TD December 2019'.F114) This has always worked well in the past, but this year, I am getting an error in the destination cell ... at first that was ErrL514, and now it is Err:540. Can you advise, please? Thank you Regards Fred James -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] How to visualize columns without exponential numbers with E-0...
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 thanks Gio -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...
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 the persons doing the > reaction) > B - No, formatted number general (records number of times this > reactors has reacted to the performer) > C - First, formatted DD/MM/YY (records the first date the reactor reaacted > to this performer) > D - Last, formatted DD/MM.YY (records last date reactor reacted to this > performer) > E - Days, formatted =NOW()-D3 (records number of days since last reaction) > F - Weeks, formatted =E3/7 (records number of weeks since last reaction) > G - Months, formatted =F3/4 (records number of months since last reaction. > reaction) > > Is there a formula that I can enter in Column B which will increase > incrementally increase the figure by 1, please? > > Regards from New Zealand on a very warm summer evening. > > David > -- > Zed > I'm not sure I understand what you are asking for here. So in column A, there are names, as you said, and in column B there's a number that tells you how many times the name in Column A appeared so far? Then I guess the following would work: B1: =IF(A1="";"";COUNTIF(A$1:A1;A1)) Click and drag the formula downwards. Now, for instance B17 looks like this: =IF(A17="";"";COUNTIF(A$1:A17;A17)) The IF is just to not display a zero when nothing is entered into the corresponding A line. Kind regards Johnny Rosenberg > "To use the term blind faith, is to use an adjective needlessly." Julian > Ruck > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...
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 values in column B to be one greater than they are. That's a contradiction. If the value in Bn is four, you want it to be five. But that means it's no longer four. And if it's now five, how would any formula know you do not want it to be six? And so on? I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy