Recent

Author Topic: [SOLVED] FPSpreadsheet, How to Hide Gridlines?  (Read 597 times)

incendio

  • Sr. Member
  • ****
  • Posts: 269
[SOLVED] FPSpreadsheet, How to Hide Gridlines?
« 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.
« Last Edit: September 29, 2022, 03:34:08 am by incendio »

wp

  • Hero Member
  • *****
  • Posts: 11916
Re: FPSpreadsheet, How to Hide Gridlines?
« Reply #1 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];

incendio

  • Sr. Member
  • ****
  • Posts: 269
Re: FPSpreadsheet, How to Hide Gridlines?
« Reply #2 on: September 29, 2022, 03:33:54 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.

 

TinyPortal © 2005-2018