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
Created attachment 152985 [details] XLSX file with disappeared grid lines
Confirm Version: 6.4.0.0.alpha0+ (x64) Build ID: bebc2280e43fc381e9085f2a397dad9dd7701fdd CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win;
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)
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
Confirmed with Version: 6.4.3.2 Build ID: 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8 CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: gtk3;
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.
*** Bug 125765 has been marked as a duplicate of this bug. ***
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.
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.