[Solved] Word wrapping in an TsWorksheetGrid?
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
daveinhull · 2022-01-25 13:50

Hi,

Is it possble to word wrap in a TsWorksheetGrid?

I've read through the documentaiton for FPSpreadsheet and there is an
option for wordwrapping in a worksheet, but I just don't know how to
connect the (non-vidsual) worksheeet to the visual WorksheetGrid

// Example: activate wordwrap in cell A1
MyWorksheet.WriteWordwrap(0, 0, true)

Any help would be appreciated

Many thanks
Dave

----------------------------------------------------------------------
wp · 2022-01-25 14:16

There's a property for it: TsWorksheetGrid.Wordwrap[col,row]

This code toggle this property for the current cell in the grid:
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 procedure
TForm1.Button1Click(Sender: TObject);begin  with sWorksheetGrid1 do  
Wordwrap[Col, Row] := not Wordwrap[Col, Row];end;
See also:
https://wiki.lazarus.freepascal.org/TsWorksheetGrid#Cell_formatting
(at the end of the first bullet list).

----------------------------------------------------------------------
daveinhull · 2022-01-25 14:24

Many thanks wp