[SOLVED] FPSpreadsheet, How to Hide Gridlines?
lazarus / 21-General

----------------------------------------------------------------------
incendio · 2022-09-28 03:35

Hi guys,

I am using FPSpreadsheet ver 1.14.0.0 on Lazarus Windows to create
xlsx file.

Already read manual on https://wiki.freepascal.org/FPSpreadsheet,
but couldn't find a method to hide gridlines.

How to hide it?

Thanks in advance.

----------------------------------------------------------------------
wp · 2022-09-28 07:54

Remove the element soShowGridLines from the worksheet's Options (the
TsSheetOptions are declared in unit fpsTypes):
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i  
worksheet.Options := worksheet.Options - [soShowGridlines];

----------------------------------------------------------------------
incendio · 2022-09-29 01:33

Quote from: wp on September 28, 2022, 09:54:16 amRemove the element
soShowGridLines from the worksheet's Options (the TsSheetOptions are
declared in unit fpsTypes):
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i  
worksheet.Options := worksheet.Options - [soShowGridlines]; Works like
a charm. Thanks a lot.