We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Calc - Hidden cells are visible when reopening edited file - BUG?

asked 2021-06-10 15:02:19 +0200

mrkalvin gravatar image

updated 2021-06-10 18:11:06 +0200

Is this a bug or is it expected behavior of Libreoffice Calc?

1) I create a calc ods spreadsheet file

2) hidden columns from D to last column

3) save the file and close

4) I reopen the file and type something in some cell

5) save the file again and close

6) reopen the file

7) the cells that were hidden in step 2 are now visible \ Created new columns visible to the left

To me it seems to be a bug!

OS: Windows 10

Libreoffice: Portable (x86)

the expected behavior is to continue only with columns A through C without any other visible columns

edit retag flag offensive close merge delete


I can confirm:

Version: (x86) Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: es-MX (es_MX); UI: en-US Calc: threaded

LeroyG gravatar imageLeroyG ( 2021-06-10 15:18:05 +0200 )edit

For me hidden cells starting from column BM through column AMJ are shown following your procedure. From my perspective definitely a bug to be reported at https://bugs.documentfoundation.org/, if not someone else already reported that issue.


Version: (x64) / LibreOffice Community
Build ID: a529a4fab45b75fefc5b6226684193eb000654f6
CPU threads: 1; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: en-US (en_DE); UI: en-US
Calc: threaded

and on Linux as well

Version: / LibreOffice Community
Build ID: a529a4fab45b75fefc5b6226684193eb000654f6
CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Opaque gravatar imageOpaque ( 2021-06-10 15:18:06 +0200 )edit

Fragment content.xml after the first save of document:

<table:table-column table:style-name="co1" table:number-columns-repeated="3" table:default-cell-style-name="Default"/>
<table:table-column table:style-name="co1" table:visibility="collapse" table:number-columns-repeated="1021" table:default-cell-style-name="Default"/>

After the second save table:number-columns-repeated="61"


sokol92 gravatar imagesokol92 ( 2021-06-10 16:30:36 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2021-06-10 18:04:14 +0200

mrkalvin gravatar image
edit flag offensive delete link more


see also tdf#142029

sokol92 gravatar imagesokol92 ( 2021-06-10 18:18:15 +0200 )edit

…and tdf#128895.

LeroyG gravatar imageLeroyG ( 2021-06-11 00:27:32 +0200 )edit
Login/Signup to Answer

Question Tools



Asked: 2021-06-10 15:02:19 +0200

Seen: 29 times

Last updated: Jun 10