Description: If a cell with formulas that use recognized names as addressing (for example to multiply the value of two columns), is copy-pasted to a range of cells, the formulas are pasted, but the cells show the value of the copied cell. If the cell is copy / pasted to another cell in the same column, the pasted cell shows the updated value. Example: 1 Price Quantity Total 2 1 25 ='Price'*'Quantity' 3 4 It works if the formula is copied below to line 3 or 4 It does not work if it is pasted to both line 3 and 4 It happened on a previous version 5.XX, but I didn't note which one it was exactly. Same happens with 6.1.6.3 Steps to Reproduce: 1.Create column titles 2.Create a formula that uses recognized names as addressing (see example) 3.Type values in the two columns that are used by the formula 4.Copy paste the formula to a range of cells below Actual Results: The formulas show the value of the cell that was copied. To see the right value in a specific line, you must copy the original cell to the specific line (not no a range of cells) Expected Results: After doing paste, it should display the right calculation Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info:
Reproducible with Version: 6.3.1.1 (x64) Build ID: e979878b49a48dab15ebe528f238b88125e32c65 CPU threads: 12; OS: Windows 10.0; UI render: GL; VCL: win; Locale: ru-RU (ru_RU); UI-Language: en-US Calc: threaded
Options->LibreOffice Calc->Calculate must have "[x] Automatically find column and row labels" checkbox checked.
*** This bug has been marked as a duplicate of bug 115654 ***