Download it now!
Bug 126541 - FILEOPEN XLSX Grid lines do not appear after changing View Grid Lines if the document was saved with hidden grid lines
Summary: FILEOPEN XLSX Grid lines do not appear after changing View Grid Lines if the ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-Sheet
  Show dependency treegraph
 
Reported: 2019-07-25 12:47 UTC by Gabor Kelemen
Modified: 2020-07-01 09:32 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
Example spreadsheet file with hidden grid lines (15.35 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-07-25 12:47 UTC, Gabor Kelemen
Details
XLSX file with disappeared grid lines (42.35 KB, image/png)
2019-07-25 12:47 UTC, Gabor Kelemen
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen 2019-07-25 12:47:23 UTC
Created attachment 152984 [details]
Example spreadsheet file with hidden grid lines

Changing the display of grid lines does not happen when opening an xlsx file with grid lines turned off.

Steps to reproduce:
    1. Create a new spreadsheet with LibreOffice Calc or Microsoft Excel.
    2. Switch the View Grid Lines (Menu → View →  View Grid Lines)
    3. Check that grid lines are hidden
    4. Save the document as XLSX format
    5. Reload the document
    6. Switch the View Grid Lines (Menu → View →  View Grid Lines)

Actual results: 
The grid lines do not appear. 
However after saving and reloading the file they do appear.

Expected results: 
The grid lines appear immediately.


LibreOffice details:
Version: 6.4.0.0.alpha0+ (x86)
Build ID: 382aceb80d3c0f420d51762e1f88eee2334ff11b
CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2019-07-21_23:45:18
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: CL

Also happens in:
LibreOffice 3.5.0rc3 
Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735
Comment 1 Gabor Kelemen 2019-07-25 12:47:49 UTC
Created attachment 152985 [details]
XLSX file with disappeared grid lines
Comment 2 raal 2019-08-02 16:03:44 UTC
Confirm Version: 6.4.0.0.alpha0+ (x64)
Build ID: bebc2280e43fc381e9085f2a397dad9dd7701fdd
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win;
Comment 3 Xisco Faulí 2019-08-07 16:24:16 UTC
Also reproduced in

Version: 5.2.0.0.alpha1+
Build ID: 5b168b3fa568e48e795234dc5fa454bf24c9805e
CPU Threads: 4; OS Version: Linux 4.15; UI Render: default; 
Locale: ca-ES (ca_ES.UTF-8)
Comment 4 Roman Kuznetsov 2019-12-12 15:11:04 UTC
still repro in

Version: 6.5.0.0.alpha0+ (x64)
Build ID: 67ee8818e68a2793d89331dd715989c468fe5680
CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: default; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded
Comment 5 Joshua Coppersmith 2020-05-25 15:12:02 UTC
Confirmed with Version: 6.4.3.2
Build ID: 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8
CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: gtk3;