[Libreoffice-bugs] [Bug 127269] New: Calc and Formulas copying: Issue if a cell with formulas that use recognized names as addressing, is copy-pasted to a range of cells

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: a.peralta at online.fr

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190901/31d1fa59/attachment-0001.html>