Summary: | grid lines for .xlsx file | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Randy Croan <n0tig> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | normal | CC: | 79045_79045, srdosm |
Priority: | medium | Keywords: | filter:xlsx |
Version: | Inherited From OOo | ||
Hardware: | x86-64 (AMD64) | ||
OS: | Windows (All) | ||
See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=158569 | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 109367 | ||
Attachments: | test calc file with grid lines and page breaks hidden |
Description
Randy Croan
2022-05-24 16:49:09 UTC
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 |