spreadsheet
spreadsheet copied to clipboard
Twice dragging a formula of a formatted cell displaying ###
Originally by dattukv
1] Create a row with data format $0.00 on the cells like below
Spreadsheet spreadsheet = new Spreadsheet();
Row row = spreadsheet.getActiveSheet().createRow(0);
for (int i = 0; i < 20; i++) {
Cell cell = row.createCell(i);
SpreadsheetUtil.applyDataFormatOnCell("$0.00", cell, spreadsheet);
}
2]Now when spreadsheet is displayed, enter a 6 digit number (like 333333) in Cell A1. Now Copy this cell value to other cells by dragging the cell. Value will be copied to other cells. Do the dragging again on the same cells. When you drag second time cells are displaying ### instead of values
Imported from https://dev.vaadin.com/ issue #20249