spreadsheet icon indicating copy to clipboard operation
spreadsheet copied to clipboard

Twice dragging a formula of a formatted cell displaying ###

Open vaadin-bot opened this issue 7 years ago • 2 comments

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

vaadin-bot avatar Sep 07 '16 09:09 vaadin-bot