[Solved] Word wrapping in an TsWorksheetGrid?

[daveinhull]

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]

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][+][-]

1. procedure TForm1.Button1Click(Sender: TObject);
2. begin
3.   with sWorksheetGrid1 do
4.     Wordwrap[Col, Row] := not Wordwrap[Col, Row];
5. end;

See also: https://wiki.lazarus.freepascal.org/TsWorksheetGrid#Cell_formatting (at the end of the first bullet list).

[daveinhull]

Many thanks wp