online icon indicating copy to clipboard operation
online copied to clipboard

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

Open Tex2002ans opened this issue 8 months ago • 1 comments

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:

Many Hidden Columns Rows Google Sheets 2024 06 19 Many Hidden Columns Rows Excel 365 Many Hidden Columns Rows LibreOffice 24 2 4 2

where Collabora's just keeps on going:

Many Hidden Columns Rows Collabora 24 04 4 2

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:

Google Sheets Deleting Extra Rows and Columns Collabora Forums SafeLamp

or even this Youtube video:

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

Tex2002ans avatar Jun 20 '24 03:06 Tex2002ans