asked 2020-09-11 12:11:09 +0800

bztom35
53 ● 4

updated 2020-09-11 14:05:00 +0800

I was attempted to hide Column E with range from E1 to E120; however, it has no effect. Maybe this was not the proper way to do it?

@List("onClick = #processColumn")
private void hideColumn() {

        //Hide Column E - from row E1 to E120

    Range rowRange = Ranges.range(ss.getSelectedSheet(), "E1:E120");

     CellOperationUtil.hide(rowRange);
     rowRange.setHidden(true);

}