Spreadsheet Editor - Working with Rows and Columns
Table of Contents
- Add a Row
- WorksheetView.addRowAbove
- WorksheetView.addRowBelow
- Add a Column
- WorksheetView.addColumnBefore
- WorksheetView.addColumnAfter
- Delete a Row
- WorksheetView.deleteRow
- Delete a Column
- WorksheetView.deleteColumn
- Column Width and Row Height
- WorksheetView.setCurrentRowHeight
- WorksheetView.setCurrentColumnWidth
- Insert a Cell
- WorksheetView.addCellShiftRight
- WorksheetView.addCellShiftDown
Add a Row
To add a new row:
- Click on a cell where you want to add a row.
- Switch to Format tab.
- Click Add Row above to add a row above the selected cell.
- Click Add Row below to add a row below the selected cell.
The editor will add a new row at the selected location.
How it works?
The Add Row above and Add Row below are handled by JSF backend bean WorksheetView. The source code of the respective methods is as follows:
WorksheetView.addRowAbove
public void addRowAbove() {
try {
getAsposeWorksheet().getCells().insertRows(currentRowId, 1, true);
} catch (com.aspose.cells.CellsException cx) {
msg.sendMessage("Could not add row", cx.getMessage());
return;
}
purge();
reloadRowHeight(currentRowId);
}WorksheetView.addRowBelow
public void addRowBelow() {
if (getCurrentRowId() < 0) {
msg.sendMessage("No cell selected", null);
return;
}
int newRowId = currentRowId + 1;
try {
getAsposeWorksheet().getCells().insertRows(newRowId, 1, true);
} catch (com.aspose.cells.CellsException cx) {
msg.sendMessage("Could not add row", cx.getMessage());
return;
}
purge();
reloadRowHeight(newRowId);
}Add a Column
To add a new column:
- Click on a cell where you want to add a column.
- Switch to Format tab.
- Click Add Column Before to add a column before the selected cell.
- Click Add Column After to add a column after the selected cell.
The editor will add a new column at the selected location.
How it works?
The Add Column Before and Add Column After are handled by JSF backend bean WorksheetView. The source code of the respective methods is as follows:
WorksheetView.addColumnBefore
public void addColumnBefore() {
try {
getAsposeWorksheet().getCells().insertColumns(getCurrentColumnId(), 1, true);
} catch (com.aspose.cells.CellsException cx) {
msg.sendMessage("Could not add column", cx.getMessage());
return;
}
reloadColumnWidth(currentColumnId);
purge();
}WorksheetView.addColumnAfter
public void addColumnAfter() {
int newColumnId = currentColumnId + 1;
try {
getAsposeWorksheet().getCells().insertColumns(newColumnId, 1, true);
} catch (com.aspose.cells.CellsException cx) {
msg.sendMessage("Could not add column", cx.getMessage());
return;
}
reloadColumnWidth(newColumnId);
purge();
}Delete a Row
To delete a row:
- Click on a cell in the row you want to delete.
- Switch to Format tab.
- Click Delete Row button.
The editor will delete the row which includes the selected cell.
How it works?
The Delete Row button is handled by JSF backend bean WorksheetView using method WorksheetView.deleteRow:
WorksheetView.deleteRow
public void deleteRow() {
try {
getAsposeWorksheet().getCells().deleteRows(currentRowId, 1, true);
} catch (com.aspose.cells.CellsException cx) {
msg.sendMessage("Could not delete row", cx.getMessage());
return;
}
cells.getRows(workbook.getCurrent()).remove(currentRowId);
getRowHeight().remove(currentRowId);
purge();
}Delete a Column
To delete a column:
- Click on a cell in the columnyou want to delete.
- Switch to Format tab.
- Click Delete Column button.
The editor will delete the column which includes the selected cell.
How it works?
The Delete Column button is handled by JSF backend bean WorksheetView using method WorksheetView.deleteColumn:
WorksheetView.deleteColumn
public void deleteColumn() {
try {
getAsposeWorksheet().getCells().deleteColumns(currentColumnId, 1, true);
} catch (com.aspose.cells.CellsException cx) {
msg.sendMessage("Could not delete column", cx.getMessage());
return;
}
cells.getColumns(workbook.getCurrent()).remove(currentColumnId);
getRowHeight().remove(currentColumnId);
purge();
}Column Width and Row Height
To change width of a column:
- Click on any cell inside the column.
- Switch to Format tab.
- Click Column Width button to open Column Width dialog.
- Enter a new value in the dialog box.
- Click Close.
The editor will change the width of column.
How to change row height?
To change height of a row:
- Click on any cell inside the row.
- Switch to Format tab.
- Click Row Height button to open Row Height dialog.
- Enter a new value in the dialog box.
- Click Close.
The editor will change the height of row.
How it works?
When the user submit the value of width and height, these values are handled on server-side by setCurrentRowHeight and setCurrentColumnWidth methods of JSF backend bean WorksheetView.
WorksheetView.setCurrentRowHeight
public void setCurrentRowHeight(int height) {
if (!isLoaded()) {
return;
}
getAsposeWorksheet().getCells().setRowHeightPixel(currentRowId, height);
reloadRowHeight(currentRowId);
RequestContext.getCurrentInstance().update("sheet");
}WorksheetView.setCurrentColumnWidth
public void setCurrentColumnWidth(int width) {
if (!isLoaded()) {
return;
}
getAsposeWorksheet().getCells().setColumnWidthPixel(currentColumnId, width);
reloadColumnWidth(currentColumnId);
RequestContext.getCurrentInstance().update("sheet");
}Insert a Cell
To add a new cell:
- Click on a cell where you want to new.
- Switch to Insert tab.
- Click Cell button.
- Choose Shift Cells Right or Shift Cells Down button.
The editor will add a new cell at the selected location. The adjacent cells will be automatically shifted either horizontally or vertically to create space for the new one.
How it works?
The Shift Cells Right and Shift Cells Down are handled by JSF backend bean WorksheetView. The source code of the respective methods is as follows:
WorksheetView.addCellShiftRight
public void addCellShiftRight() {
if (!isLoaded()) {
return;
}
com.aspose.cells.CellArea a = new com.aspose.cells.CellArea();
a.StartColumn = a.EndColumn = currentColumnId;
a.StartRow = a.EndRow = currentRowId;
getAsposeWorksheet().getCells().insertRange(a, com.aspose.cells.ShiftType.RIGHT);
purge();
}WorksheetView.addCellShiftDown
public void addCellShiftDown() {
if (!isLoaded()) {
return;
}
com.aspose.cells.CellArea a = new com.aspose.cells.CellArea();
a.StartColumn = a.EndColumn = currentColumnId;
a.StartRow = a.EndRow = currentRowId;
getAsposeWorksheet().getCells().insertRange(a, com.aspose.cells.ShiftType.DOWN);
purge();
}