Freeze Rows and Columns

Freeze rows or columns is useful when displaying lots of data. Range allows you to freeze rows and columns easily like:

1
2
3
4
5
//freeze first row and first column
range.setFreezePanel(1,1);

//unfreeze
range.setFreezePanel(0, 0);

This method accepts row and column number starting from 1 as a parameter. Calling these methods will take effect on the sheet that Range represents only. Passing 0 means to unfreeze it.

The screenshot below is the example application to demonstrate the API usage. If we click “Freeze” button, it will freeze row and column according to current selection. center

The code is like:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
public class FreezeComposer extends SelectorComposer<Component> {

    @Wire
    private Spreadsheet ss;

    @Listen("onClick = #freezeButton")
    public void freeze() {
        Ranges.range(ss.getSelectedSheet())
        .setFreezePanel(ss.getSelection().getRow(), ss.getSelection().getColumn());
    }
    
    @Listen("onClick = #unfreezeButton")
    public void unfreeze() {
        Ranges.range(ss.getSelectedSheet()).setFreezePanel(0,0);
    }
}

Comments