https://bugs.documentfoundation.org/show_bug.cgi?id=161616
Bug ID: 161616
Summary: Goal seek macro corrupts the data in Calc cell
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
This is a follow-up of bug 161338
Steps to reproduce:
1. Open attachment 194447 from bug 161338
2. Execute the following code
Sub TestGoalSeek
oSheet = ThisComponent.Sheets(0)
oTargetCell = oSheet.getCellRangeByName("D1")
oVariableCell = oSheet.getCellRangeByName("C1")
oResult = Thiscomponent.seekGoal(oTargetCell.CellAddress,
oVariableCell.CellAddress, "100")
MsgBox oResult.Result
End Sub
3. Go back to the sheet
-> C1 and D1 become #N/A
--
You are receiving this mail because:
You are the assignee for the bug.
