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
> $[sheetname].A2:D which would automatically adjust to the bottom of column D
Not sure what you mean by this? From cell A:2 to the end of the last row in column D which has content?
"The bottom of column D" is a long way down…
@negative12dollarbill It is, but it works in Google Sheets. Which only defaults to 1000 to begin with, and lets you delete what you're not using.
But Libreoffice doesn't work that way, and I can't figure out how to define a potentially fluid range in calls.
Solitha
Negative12DollarBill