spreadsheet icon indicating copy to clipboard operation
spreadsheet copied to clipboard

Dragging a Formula of a cell refering to cell in other sheet creates invalid formulas

Open vaadin-bot opened this issue 8 years ago • 0 comments

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

vaadin-bot avatar Jul 26 '16 08:07 vaadin-bot