Grid Lines continue even after reaching "the end" of a spreadsheet

[Tex2002ans]

Describe the Bug

When reaching "the end" of a spreadsheet (the very far right or far bottom), the grid lines continue into the distance.

Google Sheets, Excel 365, and LibreOffice all seem to "end" with a solid gray background:

where Collabora's just keeps on going:

Steps to Reproduce

1. Open LO.24.2.2.-.Many.Hidden.Columns.Rows[Only.4x10.Showing].ods
   • Only has Columns A-D + Rows 1-10 showing. All others are Hidden.

Expected Behavior

A solid gray/darker background, like Excel/Sheets/LibreOffice.

Actual Behavior

The grid lines continue right/down forever.

Also, the spacing above row 1 gets very glitchy.

Desktop

• Collabora version: 24.04.4.2
• OS and version: Linux Mint 21.3
• Browser and version: Firefox 127.0

COOLWSD version: 24.04.4.2 (git hash: 967b85ec)
LOKit version: Collabora Office 24.04.4.2 (git hash: 586d953)
Served by: Linux Mint 21.3
Server ID: 86706693

Also tested in LibreOffice:

Version: 24.2.4.2 (X86_64) / LibreOffice Community
Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2
CPU threads: 8; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded

• Excel 365 (Build 17628.20144)
• Google Sheets (as of 2024.06.19).

Additional Context

SafeLamp, a user at the Collabora Forums, brought this use-case up.

When "sharing a spreadsheet as templates for others", they wanted to "remove the extra empty rows/columns".

Google Sheets seems to have a feature where you can "Delete" the extra columns/rows.

See SafeLamp's example GIF:

or even this Youtube video:

• "Getting Rid of Extra Columns and Rows in Google Sheets" (Kathie Powell)

Same exact thing can be accomplished in Excel / LibreOffice / Collabora by Right-Click > Hide Columns.

[gravelfreeman]

Thank you for this! Really looking forward to it. BTW the Youtube video you linked, interestingly have many comments of other use case for hiding rows and columns. If anyone was wondering why one would want to do this.