Lazarus

Programming => General => Topic started by: incendio on September 28, 2022, 05:35:00 am

Title: [SOLVED] FPSpreadsheet, How to Hide Gridlines?
Post by: incendio on September 28, 2022, 05:35:00 am

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.

Title: Re: FPSpreadsheet, How to Hide Gridlines?
Post by: wp on September 28, 2022, 09:54:16 am

Remove the element soShowGridLines from the worksheet's Options (the TsSheetOptions are declared in unit fpsTypes):

Code: Pascal  [Select][+][-]

1.   worksheet.Options := worksheet.Options - [soShowGridlines];

Title: Re: FPSpreadsheet, How to Hide Gridlines?
Post by: incendio on September 29, 2022, 03:33:54 am

Quote from: wp on September 28, 2022, 09:54:16 am

Remove the element soShowGridLines from the worksheet's Options (the TsSheetOptions are declared in unit fpsTypes):

Code: Pascal  [Select][+][-]

1.   worksheet.Options := worksheet.Options - [soShowGridlines];

Works like a charm. Thanks a lot.