Hide Rows and Columns"
From Documentation
m (correct highlight (via JWB)) |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 3: | Line 3: | ||
| − | Hiding rows or columns may come in handy when we don't need some cells temporarily. Before hiding (or unhiding) rows or columns by API, you should make your selection become row selection or column selections by < | + | Hiding rows or columns may come in handy when we don't need some cells temporarily. Before hiding (or unhiding) rows or columns by API, you should make your selection become row selection or column selections by <code>Range.toRowRange()</code> or <code>Range.toColumnRange()</code>. Here are examples: |
'''Hide and unhide selected row''' | '''Hide and unhide selected row''' | ||
| − | <source lang='java' | + | <source lang='java' highlight="3"> |
//convert to column range or row range before hiding or unhiding. | //convert to column range or row range before hiding or unhiding. | ||
Range rowRange = Ranges.range(ss.getSelectedSheet(), ss.getSelection()); | Range rowRange = Ranges.range(ss.getSelectedSheet(), ss.getSelection()); | ||
| Line 19: | Line 19: | ||
'''Hide a column''' | '''Hide a column''' | ||
| − | <source lang='java' | + | <source lang='java' highlight="2"> |
Range columnRange = Ranges.range(ss.getSelectedSheet(), ss.getSelection()); | Range columnRange = Ranges.range(ss.getSelectedSheet(), ss.getSelection()); | ||
columnRange = columnRange.toColumnRange(); | columnRange = columnRange.toColumnRange(); | ||
Latest revision as of 12:52, 19 January 2022
Hiding rows or columns may come in handy when we don't need some cells temporarily. Before hiding (or unhiding) rows or columns by API, you should make your selection become row selection or column selections by Range.toRowRange() or Range.toColumnRange(). Here are examples:
Hide and unhide selected row
//convert to column range or row range before hiding or unhiding.
Range rowRange = Ranges.range(ss.getSelectedSheet(), ss.getSelection());
rowRange = rowRange.toRowRange();
rowRange.setHidden(true);
//CellOperationUtil checks sheet protection before hiding a range
CellOperationUtil.hide(rowRange);
CellOperationUtil.unhide(rowRange);
Hide a column
Range columnRange = Ranges.range(ss.getSelectedSheet(), ss.getSelection());
columnRange = columnRange.toColumnRange();
columnRange.setHidden(true);
If you don't convert it before calling API, it won't take effect.
All source code listed in this book is at Github.