[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.documentfoundation.org/show_bug.cgi?id=64499 Bruce Sobey changed: What|Removed |Added Status|NEW |RESOLVED Resolution|---

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.documentfoundation.org/show_bug.cgi?id=64499 --- Comment #34 from Bruce Sobey --- Rechecked again with the latest build 6.4.5.2 The situation is unchanged. Solver manages to get a solution, but goalseek does not. The problem is that I want to use a macro, but there is an issue sett

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.documentfoundation.org/show_bug.cgi?id=64499 --- Comment #33 from Bruce Sobey --- Rechecked on 5 Oct 2019 on Windows version 6.3.1.2 and problem still persists. I tried using Solver. All the supplied Solver engines except the experimental non-linear one get the correct result. It h

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.documentfoundation.org/show_bug.cgi?id=64499 --- Comment #32 from QA Administrators --- ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to rete

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.documentfoundation.org/show_bug.cgi?id=64499 --- Comment #31 from kcoo...@cooperandadel.com --- Goal seek returns the message "Goal Seek Fails" when I attempt to find a value. -- You are receiving this mail because: You are the assignee for the bug.__

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.documentfoundation.org/show_bug.cgi?id=64499 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.documentfoundation.org/show_bug.cgi?id=64499 --- Comment #29 from Jean-Baptiste Faure --- Nothing to change to my comment #25 after testing with LO 5.3.1.0.0+ and current master. Best regards. JBF -- You are receiving this mail because: You are the assignee for the bug.___

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.documentfoundation.org/show_bug.cgi?id=64499 --- Comment #28 from QA Administrators --- ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to rete

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.documentfoundation.org/show_bug.cgi?id=64499 --- Comment #27 from AK --- Created attachment 120536 --> https://bugs.documentfoundation.org/attachment.cgi?id=120536&action=edit Failed Goal Seek - v5.0.2.2 This is on LibreOffice version 5.0.2.2. -- You are receiving this mail beca

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.documentfoundation.org/show_bug.cgi?id=64499 --- Comment #26 from AK --- I was here to file a bug report of my own, but saw this possible duplicate. Yes, I can say with 100% certainty that this bug is still in the code! -- You are receiving this mail because: You are the assignee

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.documentfoundation.org/show_bug.cgi?id=64499 --- Comment #25 from Jean-Baptiste Faure --- Still reproducible with version 5.0.4.0+: - Goalseek fails to find the solution - both linear solvers work perfectly. Best regards. JBF -- You are receiving this mail because: You are the ass

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.documentfoundation.org/show_bug.cgi?id=64499 --- Comment #24 from QA Administrators --- ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to rete

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 Robinson Tryon (qubit) changed: What|Removed |Added Whiteboard|NeedAdvice | --- Comment #23 from Robinson

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 --- Comment #22 from Owen Genat --- (In reply to comment #21) > In the case of the use of the solver, I do not reproduce with version > 4.3.2.0.0+ build at home under Ubuntu 14.04 x86-64. It works perfectly well > (and find the solution as MS-Exc

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 Jean-Baptiste Faure changed: What|Removed |Added CC||jbfa...@libreoffice.org --- Commen

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 Owen Genat changed: What|Removed |Added Hardware|x86 (IA32) |All OS|Windows (All)

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 Owen Genat changed: What|Removed |Added Status|NEEDINFO|NEW --- Comment #19 from Owen Genat --- Th

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 --- Comment #18 from Jay Philips --- Created attachment 105834 --> https://bugs.freedesktop.org/attachment.cgi?id=105834&action=edit screenshot from excel 2013 -- You are receiving this mail because: You are the assignee for the bug.

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 Owen Genat changed: What|Removed |Added CC||philip...@hotmail.com --- Comment #17 from

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 Owen Genat changed: What|Removed |Added Attachment #89341|XLS and screenshots showing |XLS and screenshots showing descript

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 --- Comment #16 from QA Administrators --- Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regula

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 --- Comment #15 from Owen Genat --- Oh, I forgot to mention I tested attchment 46880 under Debian 7.3.0 x86_64 using v4.1.4.2 and Crunchbang 11 x86_64 using v4.2.0.4 (both website builds). -- You are receiving this mail because: You are the ass

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 --- Comment #14 from Owen Genat --- (In reply to comment #13) > Owen - do we need more information from OP? No, I don't think so. This appears to be bug 37341 back again (which is mentioned in the comments of the code I linked upthread). Attachm

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 Qubit changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 Joel Madero changed: What|Removed |Added Whiteboard|Need_Advice |NeedAdvice |NeedsMicroso

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 --- Comment #12 from Owen Genat --- (In reply to comment #11) > (In reply to comment #9) > > XLS and screenshots showing behaviour under Word Mac 2011 and LOv4132. > > ...testing under MacOS 10.6.8 running Word Mac 2011. > > ... error in the indi

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 --- Comment #11 from Qubit --- (In reply to comment #9) > XLS and screenshots showing behaviour under Word Mac 2011 and LOv4132. > ...testing under MacOS 10.6.8 running Word Mac 2011. > ... error in the indicated version of Word Owen, did you te

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 --- Comment #10 from Owen Genat --- (In reply to comment #9) > I tested the provided I tested the initially provided ODS ... -- You are receiving this mail because: You are the assignee for the bug.

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 --- Comment #9 from Owen Genat --- Created attachment 89341 --> https://bugs.freedesktop.org/attachment.cgi?id=89341&action=edit XLS and screenshots showing behaviour under Word Mac 2011 and LOv4132. I can confirm the behaviour described in co

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 Qubit changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 --- Comment #7 from Bruce Sobey --- Hi Foss I think I initially submitted an xls file (RetirementCalc.xls), but I may have saved it as an ods file as well. It makes no difference they both give the same problem when goal seek is run in LibreOffi

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 Foss changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 --- Comment #5 from Michael Meeks --- Goalseeking is a bit of a black art; I'd be unsurprised if there were differences in the solutions we managed to find across suites & platforms :-) -- You are receiving this mail because: You are the assign

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 Qubit changed: What|Removed |Added Whiteboard|Need_Advice |Need_Advice |

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 Joel Madero changed: What|Removed |Added Whiteboard||Need_Advice CC|

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 ign_christian changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 --- Comment #2 from Bruce Sobey --- Load the spreadsheet I attached On the RetCalc worksheet go to cell D9 Tools GoalSeek Set Formula Cell to $D$9 (should show that if you are on it) For target Value set the amount shown in PV Required Balance 2

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 ign_christian changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0

[Libreoffice-bugs] [Bug 64499] Goalseek does not get answer although Excel has no problem on same sheet saved in xls format

https://bugs.freedesktop.org/show_bug.cgi?id=64499 GerardF changed: What|Removed |Added Attachment #79200|text/plain |application/vnd.oasis.opend mime type