Need a little advice/help.
I'm trying to de-Google some spreadsheets. I'm hitting a wall on a certain function. Google allowed me to delete unused rows/columns, and then call $[sheetname].A2:D which would automatically adjust to the bottom of column D, whatever that happened to be at the time.
#Libreoffice Calc is not allowing this functionality. All I could think of was Define Range, but $[sheetname].[rangename] did not work for me.
Edit: Solved! Answer in reply.
1/2
I have little practice with defining ranges and how to call them. I'm not sure it's the right answer or how to search for the right answer.
All I know is, I need to be able to define those ranges in a flexible or central way, because there is no chance in hell I can adjust hundreds of range calls individually every time I need to add or delete a row.
2/2
I managed to nail down my dear spouse on the topic. He said that Excel would automatically adjust the defined range as rows are added/deleted.
Tested, and yes, it works on Libreoffice. IIRC one would use absolute markings ($) to keep it from doing that.
Solitha