Re: [libreoffice-users] Function acting on range
I was meaning that if I have 10 sheets, I can refer to them by position 1 to 10 rather than by name. =SHEET($Sheet19.B28) returns 29. I was wondering if I could refer to this cell something like ='29'.B28 On 18/03/2023 22:20, ady wrote: If by "sheets by position" you mean things like "the next one, whichever the next worksheet would be", you can. I don't know whether you actually need this feature – please allow me to doubt it – but there is such a thing in LibreOffice Calc. -- 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 portable
On 2023-03-18 14:06, Larry Sanders wrote: I have been able to run libreoffice portable off a thumb drive successfully of of my PC at work. At home I have a Mac Pro and need to access the same files (for me mainly the database) and I would like to do so without having a virtual machine (i.e. Parallels). In addition, my Mac has an M processor; hence, no boot camp. Is there a way to run the thumb drive on a PC and Mac with these constraints? Would be huge for me - hope you can help. Can you not install the Mac version? -- 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] libreoffice portable
I have been able to run libreoffice portable off a thumb drive successfully of of my PC at work. At home I have a Mac Pro and need to access the same files (for me mainly the database) and I would like to do so without having a virtual machine (i.e. Parallels). In addition, my Mac has an M processor; hence, no boot camp. Is there a way to run the thumb drive on a PC and Mac with these constraints? Would be huge for me - hope you can help. Thanks, Larry -- 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] Function acting on range
If by "sheets by position" you mean things like "the next one, whichever the next worksheet would be", you can. I don't know whether you actually need this feature – please allow me to doubt it – but there is such a thing in LibreOffice Calc. Beware: if you need compatibility with other spreadsheet software, I wouldn't recommend using this feature. Not every spreadsheet software (and/or file format) supports this feature. Moreover, before investing too much time on this, you should test this with a simple basic case, save it, close the software and reopen the test file again, in order to check whether everything works as expected. You have been warned! In LibreOffice Calc, worksheets can be addressed by relative references. For cells, you add a "$" symbol for columns, rows, or both for absolute references. This is quite common, in every spreadsheet software and file format. For worksheets in LO Calc, when you precede a worksheet name with the same "$" symbol you make its reference absolute. Absolute worksheet references are the default (and only) mode for most spreadsheet tools and file formats (so they don't use any additional symbol). In Calc – I cannot emphasize that point enough – if you use the name without the preceding "$" symbol, its address is relative. Please "play" with this feature before using it in important work. For instance, use relative references for multiple (i.e. more than 2) worksheets, save the file, then move (all) worksheets around and see the resulting formulas and actual calculation results. Copy worksheets. Delete worksheets. Before and after each action, please pay attention to the resulting changes, in order to understand the effect of relative references. You should have clear knowledge of how relative and absolute references affect the results of actions such as move, copy and delete, before attempting to use them. Should I add "Use this feature at your own risk"? You have been warned, again. Don't blame anyone else! Using relative references for worksheets should not be used by inexperienced users, and it should only be used for specific purposes, not as a norm. Regards, Ady. -- 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