I have exported a spreadsheet from Apple Numbers, in xlsx format. All the data and formulas are there, but there are no gridlines. How do you put the spreadsheet gridlines back on?C:\fakepath\contract search.ods
Your document has background set to White. Coloured background suppresses display of gridlines, only explicit borders would be visible for such cells.
In some places, your borders are also explicitly set - to white. Then, these cells will never show you gridlines for obvious reasons (even with "Show on coloured cells enabled).
You may select everything and set background to None, and borders to none. Or you could reset direct formatting (but that would also remove other kinds of formatting, like explicit number formatting applied).
thanks. I was able to fix, by running "clear direct formatting" on the format menu, so resetting direct formatting as suggested helped. This produced a blank spreadheet. I then set options/libreoffice calc/view/grid lines to show, and it is back to how it should be. The fix was actually a combination of the ideas suggested by Lupp and Mike
First of all save the document to an .ods file.
Make sure under >Tools>Options> LibreOffice Calc>View>VisualAids to have chosen "Show on coloured cells" (meaning "...also on...").
If some of the sheets or all of them still don't show grid lines, open the sheet tab's context menu for every sheet concerned, and select 'View Grid Lines' there. The little icon left of the text should show chosen then.
I have set the options for calc to "show on coloured cells", for the grid lines, as you suggest. I am not clear on the second point though, "If some of the sheets or all of them still don't show grid lines, open the sheet tab's context menu for every sheet concerned, and select 'View Grid Lines' there. The little icon left of the text should show chosen then." where is the sheet tabs context menu?
thanks. I had a "partial success" on it. I right clicked the sheet tab and selected "grid lines for sheet". The grid lines came on for blank parts of the sheet. They also came on for parts of the cells with text. However some cells still do not have gridlines. Any idea how these can have them added?
Sorry. The image only can show that there are areas without grid lines. It doesn't offer a way to investigate the why.
You should also add information. Your LibO version? Your OperatingSystem?
Your image doesn't even show a title bar of you LibO Window. (This is getting annoying.)
Asked: 2019-01-03 12:47:39 +0100
Seen: 5,404 times
Last updated: Jan 09 '19
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
If the answer below doesn't help, please supply an example file showing the problem for you.