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.Comment;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.ss.util.CellReference;
import com.vaadin.addon.spreadsheet.Spreadsheet;
import com.vaadin.addon.spreadsheet.Spreadsheet.SelectionChangeEvent;
/**
* Spreadsheet action for inserting or deleting a comment to a cell.
*
* @author Vaadin Ltd.
* @since 1.0
*/
@SuppressWarnings("serial")
public class EditCellCommentAction extends SpreadsheetAction {
public EditCellCommentAction() {
super("Edit comment");
}
@Override
public boolean isApplicableForSelection(Spreadsheet spreadsheet,
SelectionChangeEvent event) {
if (!spreadsheet.getActiveSheet().getProtect()) {
if (event.getCellRangeAddresses().size() == 0
&& event.getIndividualSelectedCells().size() == 0) {
CellReference cr = event.getSelectedCellReference();
Comment cellComment = spreadsheet.getActiveSheet()
.getCellComment(cr.getRow(), cr.getCol());
if (cellComment != null) {
return true;
}
}
}
return false;
}
@Override
public boolean isApplicableForHeader(Spreadsheet spreadsheet,
CellRangeAddress headerRange) {
return false;
}
@Override
public void executeActionOnSelection(Spreadsheet spreadsheet,
SelectionChangeEvent event) {
CellReference cr = event.getSelectedCellReference();
spreadsheet.editCellComment(cr);
}
@Override
public void executeActionOnHeader(Spreadsheet spreadsheet,
CellRangeAddress headerRange) {
throw new UnsupportedOperationException(
"Cell comment actions can't be executed against a header range.");
}
}