Bug 68034 - Goal Seek unsuccessful if variable cell is empty
Summary: Goal Seek unsuccessful if variable cell is empty
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.7.2 release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 117760 (view as bug list)
Depends on:
Blocks: GoalSeek
  Show dependency tree / graph
 
Reported: 2013-08-12 21:04 UTC by Eike Rathke
Modified: 2018-06-18 07:02 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Eike Rathke 2013-08-12 21:04:44 UTC 
New spreadsheet
A1: =SQRT(B1)
Do not enter any value in B1

Tools->GoalSeek
Formula cell: $A$1
Target value: 2
Variable cell: $B$1

OK => not successful, closest value 0

Expected: successful, value 4
Comment 1 Eike Rathke 2013-08-12 21:52:43 UTC 
Detail: current implementation needs an existing value cell as variable cell that can be changed and the change broadcasted to recalculate the dependent formula cell(s). Probably that value cell needs to be temporarily added to the document if it doesn't exist. Needs to be checked though if doing so would interfere with ChangeTracking or cell protection or have other unwanted side effects.
Comment 2 Buovjaga 2018-06-18 07:01:46 UTC 
*** Bug 117760 has been marked as a duplicate of this bug. ***
Comment 3 Buovjaga 2018-06-18 07:02:42 UTC 
On testing the duplicate, I noticed that it succeeds in 3.5.0, but maybe this is not news to you.