Bug 99868 - Remove the grid line setting from Tools > Options
Summary: Remove the grid line setting from Tools > Options
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsDevEval
Depends on:
Blocks: Sheet-Gridlines
  Show dependency treegraph
 
Reported: 2016-05-15 22:43 UTC by Thorsten Wagner
Modified: 2021-11-20 20:40 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Sample Calc spreadsheet (11.27 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-05-15 22:43 UTC, Thorsten Wagner
Details
Sample Excel export (7.00 KB, application/vnd.ms-excel)
2016-05-15 22:43 UTC, Thorsten Wagner
Details
Screenshot 1: Sample Calc spreadsheet without gridlines (39.56 KB, image/tiff)
2016-05-15 22:44 UTC, Thorsten Wagner
Details
Screenshot 2: Result in Excel (32.67 KB, image/png)
2016-05-15 22:45 UTC, Thorsten Wagner
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Thorsten Wagner 2016-05-15 22:43:12 UTC
Created attachment 125066 [details]
Sample Calc spreadsheet

Visibility of gridlines is not considered when exporting to MS Office file formats. Screenshot 1 shows attached file "Test.ods" in Calc without gridlines, screenshot 2 shows same file saved as MS Office file in Excel (see attached file "Test.xls"). Gridlines are visible now. Exporting visibility of gridlines correctly is already implemented in OpenOffice.
Comment 1 Thorsten Wagner 2016-05-15 22:43:56 UTC
Created attachment 125067 [details]
Sample Excel export
Comment 2 Thorsten Wagner 2016-05-15 22:44:35 UTC
Created attachment 125068 [details]
Screenshot 1: Sample Calc spreadsheet without gridlines
Comment 3 Thorsten Wagner 2016-05-15 22:45:19 UTC
Created attachment 125069 [details]
Screenshot 2: Result in Excel
Comment 4 Maxim Monastirsky 2016-05-15 23:02:23 UTC
This file is using the obsolete setting from Tools > Options... > LibreOffice Calc > View. Just switch it back to "Show", and use instead the View > Grid Lines for Sheet menu, which is currently the preferred way of doing it.
Comment 5 Thorsten Wagner 2016-05-15 23:21:01 UTC
Maxim, thanks for responding fast. It works with View / Grid Lines for Sheet. It is a reasonable workaround, but there seems to be an issue too:

(1) As no gridlines are displayed status of View / Grid Lines for Sheet does not seem to be appropriate

(2) What you see prior to exporting is not what you get after exporting
Comment 6 Maxim Monastirsky 2016-05-16 07:03:34 UTC
(In reply to Thorsten Wagner from comment #5)
> (1) As no gridlines are displayed status of View / Grid Lines for Sheet does
> not seem to be appropriate
> 
> (2) What you see prior to exporting is not what you get after exporting

Just switch the setting from Tools>Options... to "Show", and never touch it again. Then the effect of View > Grid Lines for Sheet is visible. These two ways don't play nice together, that's a known issue... (and the plan was eventually to remove the one from Tools>Options..., it's just that no one had the time for it yet).
Comment 7 Buovjaga 2016-05-18 07:06:15 UTC
(In reply to Maxim Monastirsky from comment #6)
> Just switch the setting from Tools>Options... to "Show", and never touch it
> again. Then the effect of View > Grid Lines for Sheet is visible. These two
> ways don't play nice together, that's a known issue... (and the plan was
> eventually to remove the one from Tools>Options..., it's just that no one
> had the time for it yet).

Maxim, Thorsten: what should we resolve the status of this report to?
Comment 8 Thorsten Wagner 2016-05-19 21:55:52 UTC
I suggest resolving it to "NEW", because current solution is a workaround only.
Comment 9 Buovjaga 2016-05-25 09:04:48 UTC
Setting to NEW. Maxim can dupe this, if there exists an older report.
Comment 10 QA Administrators 2018-07-26 02:41:21 UTC Comment hidden (obsolete)
Comment 11 Thorsten Wagner 2019-05-23 22:20:33 UTC
Issue still exists with current master, tested on macOS 10.14.5
Comment 12 Julien Nabet 2019-10-26 21:54:10 UTC
Patch submitted for review here:
https://gerrit.libreoffice.org/#/c/81551/
Comment 13 Julien Nabet 2019-10-27 07:11:46 UTC
(In reply to Julien Nabet from comment #12)
> Patch submitted for review here:
> https://gerrit.libreoffice.org/#/c/81551/

Abandonned since it's not a simple removal of code.
Comment 14 QA Administrators 2021-10-27 03:44:37 UTC Comment hidden (obsolete)
Comment 15 Thorsten Wagner 2021-11-20 20:40:33 UTC
Retested with LO 7.1.7: Issue seems to be fixed.