Hiding a section of gridlines by using border formatting appears on the screen correctly, but doesn't save on prevue/print.
Created attachment 109363 [details] Screen shot
Created attachment 109364 [details] Screen shot2
Hello, I can not reproduce, please attach file for testing. Also specify your version of LibreOffice. Thank you. Version: 4.4.0.0.alpha2+ Build ID: 98f9baa5253f7bb8034f148519f31f548b1452fa TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2014-11-12_00:13:54
(In reply to raal from comment #3) > Hello, > I can not reproduce, please attach file for testing. Also specify your > version of LibreOffice. Thank you. Status -> NEEDINFO
Hi @Lin, be sure it is not activated the option in: Menu/Format/Page/Sheet/Print - Grid
Created attachment 109440 [details] test file
As m.a.riosv wrote - you can off the grid via Menu/Format/Page/Sheet/Print - Grid. Closing as notabug.
I only want a section of the spreadsheet to not print the grid. I formatted those line to be white, but they still print. Menu/format/sheet/print-grid does not address this issue.
(In reply to Lin from comment #8) > I only want a section of the spreadsheet to not print the grid. (Updated summary for clarity) > I formatted > those line to be white, but they still print. Menu/format/sheet/print-grid > does not address this issue. Hmm... instead of formatting some of the lines to be white, let's turn off the grid and just format all of the *other* lines to be black: 1) Open the 'test file' (attachment 109440 [details]) 2) Disable printing the grid (Format -> Page -> Sheet -> Print -> Grid --> make sure this is unchecked 3) CTRL-A to select all 4) For this spreadsheet, deselect the region A2:E9 --> CTRL-click on A2, then SHIFT-click on E9 5) Format -> Cells -> Borders -> Line Arrangement -> Default 6) Select 'Set Outer Border and all Inner Lines' 7) Click the 'OK' button Verify the result with Page Preview (CTRL-SHIFT-O). Lin: Does that method work for you?
Created attachment 109441 [details] print in excel
Thank you so much-that worked! (In reply to Robinson Tryon (qubit) from comment #9) > (In reply to Lin from comment #8) > > I only want a section of the spreadsheet to not print the grid. > > (Updated summary for clarity) > > > I formatted > > those line to be white, but they still print. Menu/format/sheet/print-grid > > does not address this issue. > > Hmm... instead of formatting some of the lines to be white, let's turn off > the grid and just format all of the *other* lines to be black: > > 1) Open the 'test file' (attachment 109440 [details]) > 2) Disable printing the grid (Format -> Page -> Sheet -> Print -> Grid > --> make sure this is unchecked > 3) CTRL-A to select all > 4) For this spreadsheet, deselect the region A2:E9 > --> CTRL-click on A2, then SHIFT-click on E9 > 5) Format -> Cells -> Borders -> Line Arrangement -> Default > 6) Select 'Set Outer Border and all Inner Lines' > 7) Click the 'OK' button > > Verify the result with Page Preview (CTRL-SHIFT-O). > > Lin: Does that method work for you?