Recent

Author Topic: Formatting of cells in frozen row not possible?  (Read 2678 times)

straetch

  • Jr. Member
  • **
  • Posts: 75
Formatting of cells in frozen row not possible?
« on: July 23, 2016, 09:54:50 am »
When I apply
    AIWorksheet.WriteWordwrap(WsRow,WsCol,true);
it works on cells in normal rows in a worksheetgrid, but has no effect on the frozen row.
If I "unfreeze" the row with
      AIWorksheetGrid.FrozenRows := 0;
then I can apply the formatting successfully.
Subsequently "freezing" the row again with
      AIWorksheetGrid.FrozenRows := 1;
destroys the formatting in the grid.

do I do something wrong here by working once on the worksheet and then on the worksheetgrid?

formatting of frozen rows is important for my application.

Windows7, Lazarus 1.6.0 with FPC 3.0.0, fpspreadsheet 1.6.2

wp

  • Hero Member
  • *****
  • Posts: 11923
Re: Formatting of cells in frozen row not possible?
« Reply #1 on: July 23, 2016, 11:33:48 am »
The file is written correctly, but it seems that grid painting ignores the wordwrap of frozen cells. Should be fixed in trunk now. Please test - I hope the fix does not break anything else...

straetch

  • Jr. Member
  • **
  • Posts: 75
Re: Formatting of cells in frozen row not possible?
« Reply #2 on: July 23, 2016, 05:29:39 pm »
Took fpspreadsheet from latest lazarus snapshot.
It works now!
I saw no side-effects.
Thanks a lot!

 

TinyPortal © 2005-2018