spreadsheet
spreadsheet copied to clipboard
Dragging a Formula of a cell refering to cell in other sheet creates invalid formulas
Originally by dattukv
Steps to reproduce. 1] Create two sheets Sheet1 and Sheet2 by clicking + icon. 2] Fill A1,B1,C1 cells of Sheet2 with values 1,2,3 respectively 3] In Sheet1 for Cell A1 Enter formula '=Sheet2!A1' 4] Now drag A1 cell in Sheet1 horizontally upto two cells.
Expected result: After dragging A1 cell upto 2 cells B1 and C1 cells of Sheet1 should contain formulas like below B1 -> =Sheet2!B1 C1 -> =Sheet2!C1
Actual result: Cells B1 and C1 in Sheet1 will contain invalid formulas.
Observation: This problem happens only if sheet name contains a number
Imported from https://dev.vaadin.com/ issue #20088