Freeze

Set freezing start at row 5:

var sheet = grid.CurrentWorksheet;
sheet.FreezeToCell(5, 0);

33

Get current freeze position:

CellPosition pos = sheet.GetFreezePos();

Freeze at position (0,0) means there is no frozen rows or columns.

Check whether or not current worksheet is frozen:

bool isFrozen = sheet.IsFrozen();

Freeze to specified position

From v0.8.6, ReoGrid supports that freeze to specified position (neighboring one or two edges), the following target positions are available:

  • Left
  • Top
  • Right
  • Bottom
  • Left and Top
  • Left and Bottom
  • Right and Top
  • Right and Bottom

85

Set the third argument position to freeze worksheet to specified position:

sheet.FreezeToCell(5, 5, FreezePosition.RightBottom);

Tips: More detailed usage about freeze available in demo project.

Notice that frozen region might be too large

If the frozen region is larger than the whole control, the active region will be invisibility.

There are two cases might get a too large frozen region.

  • A normal frozen region and an active region are specified, but the size of Control was changed too small
  • A too large frozen region was specified

86

Assume there is a grid has 100 rows, and the maximum visible rows is 30, to specify control freeze to row 60 at bottom, it causes that 40 rows at the bottom are necessary to be displayed, it is larger than the maximum visible region (30 rows), finally the active region will be invisibility.

Next: Zoom