https://bugs.documentfoundation.org/show_bug.cgi?id=127269
Bug ID: 127269
Summary: Calc and Formulas copying: Issue if a cell with
formulas that use recognized names as addressing, is
copy-pasted to a range of cells
Product: LibreOffice
Version: 5.4 all versions
Hardware: IA64 (Itanium)
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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:
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
