https://bugs.documentfoundation.org/show_bug.cgi?id=170925
Bug ID: 170925
Summary: LibreOffice Calc modifies my formula after inserting a
new row.
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
In column E I use this formula to update my bank account balance.
e.g. Formula for E400
=E399+D400-C400
If I then insert a new row at row 399 to add a missed transaction
The formula in E400 now reads =E398+D400-C400
I usually would then copy my formula from E398 to E399 (new row)
but now the formula in E400 is incorrect.
Steps to Reproduce:
1. Simply follow the formula provided for the Bank Balance column E
2. Next insert a new row into the previous row to your formula
3. Now check your formula to observe any changes
Actual Results:
Formula has been modified
Expected Results:
Formula should not have changed
Reproducible: Always
User Profile Reset: No
Additional Info:
Other spreadsheets do not behave in this manner
--
You are receiving this mail because:
You are the assignee for the bug.