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.
1/2
#AskFedi #spreadsheets
Solitha
npub19m…6qs54
2026-05-27 04:11:57 UTC
Author Public Key
npub19m7j47r7m3vma66jtqvlgfvrg87p9m7jer2ny3ya5apqwq4myt5qr6qs54Seen on
wss://relay.momostr.pinkPublished at
2026-05-27 04:11:57 UTCEvent JSON
{
"id": "a81212bc9df576dafd9698dae0de56fd2948567146610c0d8f90591586a4a53a",
"pubkey": "2efd2af87edc59beeb525819f4258341fc12efd2c8d532449da7420702bb22e8",
"created_at": 1779855117,
"kind": 1,
"tags": [
[
"t",
"libreoffice"
],
[
"proxy",
"https://mastodon.social/@solitha/116644584979514823",
"web"
],
[
"t",
"askfedi"
],
[
"t",
"spreadsheets"
],
[
"proxy",
"https://mastodon.social/users/solitha/statuses/116644584979514823",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://mastodon.social/users/solitha/statuses/116644584979514823",
"pink.momostr"
],
[
"-"
]
],
"content": "Need a little advice/help.\n\nI'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.\n\n#Libreoffice Calc is not allowing this functionality. All I could think of was Define Range, but $[sheetname].[rangename] did not work for me.\n\n1/2\n\n#AskFedi #spreadsheets",
"sig": "b6ad43c9b39a0299ed0257122023411a86cd52067645959bd94b75f6811ca981d19c980085cb9be97bfd2dfc8c468cb0de5ff0e1e3f693ca00c79d1dbc9efaab"
}