search

CollaboraOnline / online

Collabora Online is a collaborative online office suite based on LibreOffice technology. This is also the source for the Collabora Office apps for iOS and Android.
https://collaboraonline.com
Other
1.68k stars 652 forks source link

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

Open Tex2002ans opened 1 week ago

Tex2002ans commented 1 week ago

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

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

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.

gravelfreeman commented 1 week ago

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.