get grid lines to show in calc

edit

Hello,

see the following file:

C:\fakepath\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

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.