Skip to content
The Chat Archive
o3-2025-04-16· OpenAI LMArena Human Preference 140K

in libre sheets I have a data range expressed like this:…

  1. User

    in libre sheets I have a data range expressed like this: Sheet1.Sheet1.B1:1:Z1,1,Sheet1.BB10:ZZ10. 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

  2. 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.

    1. 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.

    2. Rewrite the data range with that last column

      Default 1 024-column sheet

      $Sheet1.$B$1:$AMJ$1,$Sheet1.$B$10:$AMJ$10
      

      16 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.

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.