https://bugs.documentfoundation.org/show_bug.cgi?id=145388
Bug ID: 145388
Summary: Libre Calc - insert Row above does not carry function
completely
Product: LibreOffice
Version: 7.2.0.4 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have several columns with numbers, the fourth column Sums the 3 to the left
and the 4th column cell above. =SUM(B6:D6)+E5
I needed another row so I inserted above, but it did not include the formula in
the 4th row. I drug the 4th row cell from the above row down to the new row 4th
cell. It copied the formula relative EXCEPT that the extra (+E5 in this case)
remained static (did not change with the rest of the formula). I believe it
should have a $E$5 in order to remain static else it should be relative, though
i could be missing something. I will attach the file, there is nothing
sensitive. Row 6 is the one i inserted (by right clicking 7 'insert row above')
Steps to Reproduce:
1.Create relative formula in several rows (sum cell:cell +othercell)
2.slect a middle row and rt click Insert row above
3.drag above row cell down to copy formula
Actual Results:
the cell:cell portion of the formula copies relative, the additional +othercell
does not.
Expected Results:
All cell references in the formula should be relative as it has no static
markers (i'm prob using all the wrong lingo)
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
I'm not seeing how to submit the file as an example here. Let me know if you
want it.
--
You are receiving this mail because:
You are the assignee for the bug.
