in libre sheets I have a data range expressed like this:…
- User
in libre sheets I have a data range expressed like this: BZSheet1.10:10. I want to extend the range to include all columns and not stop at Z1 and Z10. How can I modify the range to include all the columns in the worksheet
- Assistant
LibreOffice Calc does not have a special “open-ended” range symbol (such as a “*” or “B1:1”) that automatically means “all the way to the last column.”
The range has to end with an explicit column letter, so you simply need to name the last possible column on that sheet.-
Find your sheet’s last column
• Default (1 024 columns): AMJ
• If you changed Tools → Options → LibreOffice Calc → Calculate → Maximum number of columns to 16 384, the last column is XFD. -
Rewrite the data range with that last column
Default 1 024-column sheet
$Sheet1.$B$1:$AMJ$1,$Sheet1.$B$10:$AMJ$1016 384-column sheet
$Sheet1.$B$1:$XFD$1,$Sheet1.$B$10:$XFD$10
That’s all that’s required—the range now extends from column B to the very last column of the worksheet.
Need to expand automatically as you insert new columns?
Use a named range built with OFFSET (or similar) and point your chart to that name instead of a hard-coded address, e.g.MyRow1 = OFFSET($Sheet1.$B$1; 0; 0; 1; COUNTA($Sheet1.$1:$1)-1) MyRow10 = OFFSET($Sheet1.$B$10; 0; 0; 1; COUNTA($Sheet1.$10:$10)-1)—but for most purposes just replacing Z with AMJ (or XFD) solves the issue.
-
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.