Forum > General

[SOLVED] FPSpreadsheet, How to Hide Gridlines?

(1/1)

incendio:
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:
Remove the element soShowGridLines from the worksheet's Options (the TsSheetOptions are declared in unit fpsTypes):

--- Code: Pascal  [+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i < x.length; i++) { x[i].style.maxHeight='none'; x[i].style.height = Math.min(x[i].clientHeight+15,306)+'px'; x[i].style.resize = "vertical";}};} ---  worksheet.Options := worksheet.Options - [soShowGridlines];

incendio:

--- 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  [+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i < x.length; i++) { x[i].style.maxHeight='none'; x[i].style.height = Math.min(x[i].clientHeight+15,306)+'px'; x[i].style.resize = "vertical";}};} ---  worksheet.Options := worksheet.Options - [soShowGridlines];
--- End quote ---
Works like a charm. Thanks a lot.

Navigation

[0] Message Index

Go to full version