Description: LibreOffice v7.2.7.2 (x64) can't save a new .xlsx file with hide grid lines, when you close and re-open the file, the grid lines show again. also if you open a .xlsx with hide grid lines, you can't show them(used MS Excel to hide them and saved) Steps to Reproduce: 1.save .ods file with hide grid lines as .xlsx 2.close file and re-open .xlsx 3.grid lines will show Actual Results: see above Expected Results: already given Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: It appears LibreOffice Calc is not saving the part of a .xlsx file that contains whether to show or hide the grid lines. When I use MS Excel to set the option to hide grid lines and save, the file grows about 2k in size. Then if opened with LibreOffice Calc I can't make it show grid lines
I cannot reproduce this issue using LO 7.3.3. Created a new Calc file, added some borders and then hid the grid lines. Then I saved as XLSX, closed and reopened it. The grid lines were still hidden. Please try using the latest version of LibreOffice and check if the bug persists. System info: Version: 7.3.3.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 12; OS: Linux 5.13; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Ubuntu package version: 1:7.3.3~rc2-0ubuntu0.21.10.1~lo1 Calc: threaded
Created attachment 180355 [details] test calc file with grid lines and page breaks hidden upgraded to v7.3.3.2 (x64) created this test file with grid lines and page breaks hidden save as .xlsx file close LibreOffice Calc open .xlsx file for me the grid lines are back
(In reply to Randy Croan from comment #2) > Created attachment 180355 [details] > test calc file with grid lines and page breaks hidden > > upgraded to v7.3.3.2 (x64) > created this test file with grid lines and page breaks hidden > save as .xlsx file > close LibreOffice Calc > open .xlsx file > for me the grid lines are back Please write more detail how you hide the grid lines. What menu item or some options do you use? I can't repro the problem in current 7.4 development version
also see test file that was uploaded Tools Options... Alt+F12 LibreOffice Calc View Grid lines: Hide Page breaks (unchecked)
I can reproduce it in Version: 7.4.0.0.alpha1+ (x64) / LibreOffice Community Build ID: bbec710bd25fc5da27636cde73fe4ab23c76904f CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Vulkan; VCL: win Locale: cs-CZ (cs_CZ); UI: en-GB Calc: CL also in LibreOffice 3.5.0rc3 Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735 so I set version to OOo
It is saving problem. In <name>.xlsx/xl/worksheets/sheet1.xml is showGridLines="true". When I rewrite it to true and open the document, then the grid is hidden.
just my guess: LibreOffice manages gridline status per document. if you set [Tools] -> [Options] -> [LibreOffice Calc] [Grid lines] under [Visual Aids] to "Hide", lines on ALL sheets goes away. On the other hand, Excel manages this per sheet. these seems ,at least to me, libreoffice stores the grid line status only to the document settings, but not to the sheet settings. On exporting to excel, the default data(true) for only per sheet,not document, is retrieved. and the retrieved data(true) is written to xlsx. https://opengrok.libreoffice.org/xref/core/sc/source/ui/view/viewdata.cxx?r=c5b3f885#3899 https://opengrok.libreoffice.org/xref/core/sc/source/ui/view/viewdata.cxx?r=c5b3f885#3666 https://opengrok.libreoffice.org/xref/core/sc/source/filter/excel/xeview.cxx?r=b225980d#436