online
online copied to clipboard
Grid Lines continue even after reaching "the end" of a spreadsheet
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
- 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:
Same exact thing can be accomplished in Excel / LibreOffice / Collabora by Right-Click > Hide Columns.