https://bugs.documentfoundation.org/show_bug.cgi?id=161338
Bug ID: 161338
Summary: Goal seek corrupts the data in Calc cell
Product: LibreOffice
Version: 24.2.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When using Tools | Goal Seek and question appears to fill the number, clicking
on No button I expect to cancel all following operations, but instead #N/A is
inserted and so corrupts value in cell.
Steps to Reproduce:
1. Type in:
A1: 250
B1: 0.25
C1: 200
D1 = A1 * B1 / C1
2. Click on D1 and Tools | Goal Seek
3. Formula Cell is already filled with $D$1. Leave this field as is.
4. Click on Variable cell and type in: $C$1 (or click on appropriate Calc
cell).
5. Click on Target value and type in 100 and click OK button.
6. Dialog is displayed: Insert the closes value (200) into the variable cell
anyway? I don't want 200, because I already have 200, so I click on No button.
Now problem appears. Click on C1 cell and you will see int "=" row that #N/A
was inserted despite in cell C1 itself it is still value 200 displayed. Now
click on A1 and type in 300 and press Enter and now error appears in C1 and D1
with #N/A value. This is strange, because I have clicked on No button and I
expect no action is followed.
Actual Results:
C1 gets corrupted with #N/A
Expected Results:
1. If I click on No, I expect no action to follow, so not corrupting C1 cell.
2. It is actually unclear what Yes/No buttons actually do. This is not the best
UX. I think buttons should never be Yes/No, but instead "action" and "cancel"
like "Insert" and "Cancel" in this case, so user can be absolutely sure what
individual button action really does.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 24.2.3.2 (X86_64) / LibreOffice Community
Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba
CPU threads: 12; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win
Locale: sl-SI (en_SI); UI: en-US
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
