LO 5.2.7.2 - Calc - How do I keep black gridlines when I change background color?

[AhuLee]

Hi,

after I change background color of rows and columns they lose their gridlines. What do I do if I want my columns/rows be filled with color, but at the same time have black (default) gridlines? Like in Google Spreadsheet for example.

Thank you.

[Lupp]

‘Tools’ > ‘Options’ > ‘LibreOffice Calc’ > ‘View’ > ‘Visual Aids’> ‘Grid lines’, choose ‘Show on coloured cells’ (meaning: Show also on coloured cells).
Immediately below you can also select the colour (which not is black by default).

[AhuLee]

Thank you very much!