Bug 104036 - Hidden grid lines shouldn't print if not visible, even if print grid lines is checked
Summary: Hidden grid lines shouldn't print if not visible, even if print grid lines is...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Cell-Border PDF-Export Print-Preview
  Show dependency treegraph
Reported: 2016-11-19 19:25 UTC by Peter Lawson
Modified: 2018-07-31 16:55 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Modified test file. (21.38 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-11-20 15:18 UTC, m.a.riosv

Note You need to log in before you can comment on or make changes to this bug.
Description Peter Lawson 2016-11-19 19:25:59 UTC
I can hide a selection of grid lines using Foramt -> Cells -> Borders. They disappear on screen, but appear in Print Preview and if I export to pdf
Comment 1 m.a.riosv 2016-11-19 22:20:53 UTC
Have you marked on the page format, sheet tab, print grid enable?
Comment 2 m.a.riosv 2016-11-20 15:18:41 UTC
Created attachment 128888 [details]
Modified test file.

Pls answer here and attach here the files.

>Yes. It is not failing to print the grid - it is printing it everywhere, including the >portion where I have 'removed' the lines. See the print preview
>Excel prints it correctly 

Grid lines are different than border lines.
Border lines can be set up as you know for every cell,
but grid lines only can be set up to show all or not,
but not by cell.

There is an option about grid lines in Menu/Tools/Options/LibreOffice calc/View - Visual aids, on how see them while working with the spreadsheet.

Adding your file deleting personal information.
Now without print grid enable, and with borders on table cells.
Comment 3 m.a.riosv 2016-11-20 15:19:00 UTC
IMO not a bug, please if you are not agree reopen it.
Comment 4 m.a.riosv 2016-11-20 21:47:36 UTC
Please again, answer here in bugzilla and attach here the files.

>So are you saying that I must set display grid to zero, and then select all the >cells for which I want borders, and specify accordingly. Seems a bit clumsy, and >not how Excel worKs

>But thanks for the response 

After further investigation, looks as calc gives priority for print to the grid over cell's format and excel does it to the inverse, tested with Excel previewer, saving the sample as xlsx.

Also calc works different on the working layout than print preview.

So set up as new

Version: (x64)
Build ID: d54a8868f08a7b39642414cf2c8ef2f228f780cf
CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; 
Locale: es-ES (es_ES); Calc: group
Comment 5 QA Administrators 2018-07-31 02:34:20 UTC Comment hidden (obsolete)
Comment 6 Timur 2018-07-31 14:15:42 UTC
I'm not clear: how is exactly hidden a selection of grid lines?