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
> $[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