Java tutorial
package com.vaadin.addon.spreadsheet.action; /* * #%L * Vaadin Spreadsheet * %% * Copyright (C) 2013 - 2015 Vaadin Ltd * %% * This program is available under Commercial Vaadin Add-On License 3.0 * (CVALv3). * * See the file license.html distributed with this software for more * information about licensing. * * You should have received a copy of the CVALv3 along with this program. * If not, see <http://vaadin.com/license/cval-3>. * #L% */ import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.util.CellRangeAddress; import com.vaadin.addon.spreadsheet.Spreadsheet; import com.vaadin.addon.spreadsheet.Spreadsheet.SelectionChangeEvent; /** * Spreadsheet action for hiding a single row or column. * * @author Vaadin Ltd. * @since 1.0 */ @SuppressWarnings("serial") public class HideHeaderAction extends SpreadsheetAction { public HideHeaderAction() { super(""); } @Override public boolean isApplicableForSelection(Spreadsheet spreadsheet, SelectionChangeEvent event) { return false; } @Override public boolean isApplicableForHeader(Spreadsheet spreadhseet, CellRangeAddress headerRange) { Sheet activeSheet = spreadhseet.getActiveSheet(); if (!isSheetProtected(activeSheet)) { if (headerRange.isFullColumnRange()) { int index = headerRange.getFirstColumn(); if (!activeSheet.isColumnHidden(index)) { setCaption("Hide column " + (getColumnHeader(index + 1))); } return true; } else if (headerRange.isFullRowRange()) { int index = headerRange.getFirstRow(); if (!spreadhseet.isRowHidden(index)) { setCaption("Hide row " + (index + 1)); } return true; } } return false; } @Override public void executeActionOnSelection(Spreadsheet spreadsheet, SelectionChangeEvent event) { throw new UnsupportedOperationException("Hide row/column action can't be executed against a selection."); } @Override public void executeActionOnHeader(Spreadsheet spreadsheet, CellRangeAddress headerRange) { if (headerRange.isFullColumnRange()) { spreadsheet.setColumnHidden(headerRange.getFirstColumn(), true); } else if (headerRange.isFullRowRange()) { spreadsheet.setRowHidden(headerRange.getFirstRow(), true); } } }