get grid lines to show in calc

[jbrid123]

I cannot get grid lines to show. I’ve tried all the suggestions in a google search and they
have no effect whatsoever. Why is this simple thing so hard? Very frustrating…

[Edit Opaque] Moved answer to details of question and deleted answer

Sectional PreRegistrations Summary as of Oct 19.xlsx

I hope that upload worked. I tried view - view grid lines, did not work. I have no colored cells. Where do I reset user profile? You’ll notice that half of the sheet has grid lines. That half is information I got from a user who uses Excel. Why is this very simple thing so hard in open office?

[anon73440385]

I’ve tried all the suggestions in a google search

What does that mean exactly? Please provide a an empty file showing no grid lines
(In general View -> [x] View Grid Lines activates the grid lines. but if you have colored cells things may be different. The default of LibreOffice is to show grid lines, so resetting your user profile could also be a choice to start over).

[anon73440385]

Sorry - but this happens, if people don’t tell the full details. You should have told that you are talking about an alien (with respect to LibreOffice) format. The file is in .xlsx format and this is not the native format of LibreOffice. Thus there is no guarantee that an import works without any drawbacks. Reset of user profile won’t help anything here.

[anon73440385]

Hello,

see the following file:

NoGridLinesCorrected.ods

The problem is in the page style PageStyle_elementor_Sectional_13092019_11, which seems to be inherited from Excel. To correct the problem do the following (with your origonal file, already done on the attached version):

• Open the .xlsx file
• Select all cells (click grey square at the intersection of row and colums headers) and Format -> Clear Direct Formatting ( or CTRL+M)
• Go to Styles -> Manage Styles (or F11)
• Select Page Sytsles (second icon of the two icons below the word Styles
• Double click on entry Default (this will assign the default page style to the sheet)
• Set Tools -> Options -> LibreOffice -> LibreOffice Calc -> View -> Option: Grid Line -> Dropdown: Show and click OK
• Set View -> View Grid Lines
• Go to Styles -> Manage Styles (or F11) and Right click on PageStyle_elementor_Sectional_13092019_11 and Delete
• Save the file in .ods format.

Procedure tested using LibreOffice:

  Version: 6.3.2.2, Build ID: 98b30e735bda24bc04ab42594c85f7fd8be07b9c
  CPU threads: 8; OS: Linux 4.12; UI render: default; VCL: kde5;
  Locale: en-US (en_US.UTF-8); UI-Language: en-US, Calc: threaded

[pmfrench]

Tools menu,

click Options,

click the + in front of LibreOffice Calc in the
left panel,

from the expanded list in
the left panel click View,

in the Visual Aids section in the
top right of the dialog box, click
the down arrow at the right end of
the Grid Lines box,

in the dropdown list, select Show,

click OK at the bottom of the dialog box.

[pmfrench]

The “grid lines” that showed in half the sheet were cell borders that were added through the Format/Cell dialog. They will print when the sheet is printed. What LibreOffice calls grid lines show on-screen only. If you want lines to print, you need to add borders to the cells.

[jbrid123]

Thanks very much for your help. I understand now.
It is much appreciated!
John

[anon73440385]

Please do not post an answer on this site, if you actually don’t answer a question (in this case your own) but commenting another users answer. Use add a comment for that purpose. And please click the check mark () next to the answer, if the answer helped to fix your issue Thanks in advance.