https://bugs.documentfoundation.org/show_bug.cgi?id=150655
Bug ID: 150655
Summary: Calc - custom basic functions do not update after
change
Product: LibreOffice
Version: 7.4.0.3 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I create a simple function in Basic:
Function myAdd(x, y, z)
myAdd = x + y + z
End Function
Then I can call it as usual with =myAdd(...). Next, I want to update myAdd to
subtract the values, I end up with:
Function myAdd(x, y, z)
myAdd = x - y - z
End Function
I save my changes and press F9 for recalculation but Calc still gives me the
value for the adding up the 3 values. To fix this bug and get the correct
result, I have to completely retype the function in the cell. If there is only
1 cell, it is fine, but if there are dozens of cells with the same function,
they cannot be rewritten all the time.
Please fix this point, it makes custom functions unreliable.
Steps to Reproduce:
1.write function
2.use in cell
3.change function
Actual Results:
old function result
Expected Results:
new function result
Reproducible: Always
User Profile Reset: No
Additional Info:
nothing
--
You are receiving this mail because:
You are the assignee for the bug.
