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: VERIFIED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2 all versions
Hardware: All All
: medium normal
Assignee: Attila Szűcs
URL:
Whiteboard: target:7.2.0
Keywords: filter:xlsx
: 125765 (view as bug list)
Depends on:
Blocks: XLSX-Sheet
  Show dependency treegraph
 
Reported: 2019-07-25 12:47 UTC by Gabor Kelemen (allotropia)
Modified: 2023-12-06 19:43 UTC (History)
7 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 (allotropia)
Details
XLSX file with disappeared grid lines (42.35 KB, image/png)
2019-07-25 12:47 UTC, Gabor Kelemen (allotropia)
Details
Options - Calc - View of an ods file and an xlsx with Grid off setting saved (111.55 KB, image/png)
2021-05-05 09:04 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (allotropia) 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 (allotropia) 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;
Comment 6 NISZ LibreOffice Team 2021-05-05 09:04:48 UTC
Created attachment 171640 [details]
Options - Calc - View of an ods file and an xlsx with Grid off setting saved

In the Options – Calc – View tab the Visual Aids – Grid lines option gets the Hide value when an XLSX file is opened with this setting.
Changing this back to Show (default) gets the View Grid Lines command working again as expected.

In case of an ODS file this setting stays Show and the sheet level setting can be changed in View menu.
Comment 7 NISZ LibreOffice Team 2021-05-05 09:18:14 UTC
*** Bug 125765 has been marked as a duplicate of this bug. ***
Comment 8 Commit Notification 2021-05-26 18:50:48 UTC
Attila Szűcs committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/759103fd65f82fc131679eba0de05f2ddc7294c8

tdf#126541 XLSX import: fix View grid lines

It will be available in 7.2.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 9 BogdanB 2021-06-02 10:07:43 UTC
Solved in Version: 7.2.0.0.alpha1+ (x64) / LibreOffice Community
Build ID: 3b57ebb445df8a2bc3d916ea79f8af45e20e4e62
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: ro-RO (ro_RO); UI: en-US
Calc: threaded

Thanks for fixing this.