Summary: | FILEOPEN XLSX Grid lines do not appear after changing View Grid Lines if the document was saved with hidden grid lines | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Gabor Kelemen (allotropia) <kelemeng> |
Component: | Calc | Assignee: | Attila Szűcs <attila.szucs> |
Status: | VERIFIED FIXED | ||
Severity: | normal | CC: | buzea.bogdan, dev, gang65, libreoffice, nemeth, raal, xiscofauli |
Priority: | medium | Keywords: | filter:xlsx |
Version: | 5.2 all versions | ||
Hardware: | All | ||
OS: | All | ||
See Also: |
https://bugs.documentfoundation.org/show_bug.cgi?id=142854 https://bugs.documentfoundation.org/show_bug.cgi?id=158569 |
||
Whiteboard: | target:7.2.0 | ||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 112752 | ||
Attachments: |
Example spreadsheet file with hidden grid lines
XLSX file with disappeared grid lines Options - Calc - View of an ods file and an xlsx with Grid off setting saved |
Description
Gabor Kelemen (allotropia)
2019-07-25 12:47:23 UTC
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. |