[Bug 166120] Goal Seek does not work for certain root expression

2025-12-02 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=166120

Markus Mohrhard  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |NOTABUG

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 166120] Goal Seek does not work for certain root expression

2025-12-02 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=166120

--- Comment #7 from Markus Mohrhard  ---
You can't solve this with a real valued solver for negative x. The function
f(x)=x^(1/x) is complex valued in the domain x < 0 and there are only a few
real valued solutions in that domain.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 166120] Goal Seek does not work for certain root expression

2025-04-10 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=166120

--- Comment #6 from Mike Kaganski  ---
(In reply to unok from comment #5)

Maybe (when I looked for the name for functions that are not continuously
defined, in my language, it returned the word that I translated like that -
maybe poorly). However, you were given the explanation of what I meant, in
comment 1.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 166120] Goal Seek does not work for certain root expression

2025-04-10 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=166120

--- Comment #5 from [email protected] ---
It is not an irregular function, not at all.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 166120] Goal Seek does not work for certain root expression

2025-04-10 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=166120

--- Comment #4 from Mike Kaganski  ---
(In reply to unok from comment #3)

No idea what kind of "excuse" that fact could be (it is a cryptic phrase, that
looks as having no sense to me); but my point was - it is not reasonable to
expect solvers to find solutions of irregular functions.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 166120] Goal Seek does not work for certain root expression

2025-04-10 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=166120

--- Comment #3 from [email protected] ---
Well, Excel has the excuse to be sold by Microsoft, but LibreOffice does not.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 166120] Goal Seek does not work for certain root expression

2025-04-10 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=166120

--- Comment #2 from Mike Kaganski  ---
By the way, Excel also fails finding this.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 166120] Goal Seek does not work for certain root expression

2025-04-10 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=166120

--- Comment #1 from Mike Kaganski  ---
IMO, this is not a bug. The function x^(1/x) is not contiguously defined for x
< 0. That there are some points where it's defined is possible to know by
human. But I may be wrong, I don't know much about numerical algorithms.

-- 
You are receiving this mail because:
You are the assignee for the bug.