#1

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 7.1.3.2 (x86)

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

#2

I can confirm:

Version: 7.0.6.2 (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

#3

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.

Confirmed:

Version: 7.1.4.2 (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: 7.1.4.2 / 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
#4

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”

LO 7.1.4.2

#5

Bug reported

https://bugs.documentfoundation.org/show_bug.cgi?id=142769

#6

see also tdf#142029

#7

…and tdf#128895.