Tags
People
Badges
Help-
CORE FRAMEWORK
FEATURED COMPONENTS
-
RESOURCES
-
LEARN ZK
RESOURCES
How to extract the end position of the selected cell? For example for A1:A10, I want to get the print out cell content of A10.
public void onCellSelection$ss(CellSelectionEvent event){
System.out.println("selected range: " + Ranges.getAreaRefString(event.getSheet() , event.getArea()));
Range selectedRange = Ranges.range(ss.getSelectedSheet(),event.getRow(),event.getColumn());
System.out.println("Selected row: " + selectedRange .toRowRange().getCellEditText() + " " + selectedRange.getCellEditText());
}
@Listen(Events.ON_CELL_SELECTION + " = #ss")
public void onCellSelection(CellSelectionEvent event){
Ranges.getCellRefString(event.getArea().getLastRow(), event.getLastColumn());
Ranges.getCellRefString(ss.getSelection().getLastRow(), ss.getSelection().getLastColumn());
}
@Listen("onCellSelection = #ss")
public void onCellSelection(CellSelectionEvent event){
Range selectedRangeStart = Ranges.range(ss.getSelectedSheet(),event.getRow(),event.getColumn());
System.out.println("Selected row Start: " + selectedRangeStart .toRowRange().getCellEditText() + " " + selectedRangeStart.getCellEditText());
}
@Listen("onCellSelectionUpdate = #ss")
public void onCellSelectionUpdate(CellSelectionUpdateEvent event){
Range selectedLastRow = Ranges.range(ss.getSelectedSheet(),event.getArea().getLastRow(),event.getLastColumn());
System.out.println("Selected row End: " + selectedLastRow.toRowRange().getCellEditText() + " " + selectedLastRow.getCellEditText());
}
Asked: 2020-09-11 01:42:33 +0800
Seen: 6 times
Last updated: Sep 11 '20