online icon indicating copy to clipboard operation
online copied to clipboard

Spreadsheet with mostly hidden rows and columns looks strange

Open thebearon opened this issue 2 years ago • 2 comments

In the attached spreadsheet, rows 16+ and columns H+ are hidden.

hidden_rows_and_columns.ods

In LibreOffice desktop, simply the range A1:G15 is shown. In Collabora Online it's shown as follows:

hidden rows and columns

Problems:

  • row 1 is wrong,
  • rows and columns have gridlines that go on even when the remainder of the sheet is hidden,
  • the background color of visible and hidden areas is the same.

thebearon avatar Jun 07 '23 13:06 thebearon

It gets even trickier when one column and one row are frozen.

ototo avatar Jun 07 '23 14:06 ototo

Confirmed this bug also occurs on android 10, collabora office 23.05.4.1

heyrict avatar Oct 22 '23 00:10 heyrict