https://bugs.documentfoundation.org/show_bug.cgi?id=89433
Bug ID: 89433 Summary: LibreOffice Calc Goal Seek Fail Product: Document Liberation Project Version: unspecified Hardware: Other OS: Linux (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: General Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: aes...@gmail.com Created attachment 113462 --> https://bugs.documentfoundation.org/attachment.cgi?id=113462&action=edit Formula showing Goal Seek cannot solve for the solution Hi, Mathematician, not programmer here, but LibreOffice Calc didn't seem to iterate through 20 integers on this latest problem. I was trying to solve for Pythagorean triples with the same area -- I used the INT command to plug in for the nearest integer automatically, used the pythagorean theorem for the length of the hypotenuse, subtracted the calculated hypotenuse length from the INT output of that length, and set Goal Seek to set that cell to zero. Goal Seek didn't give any valuable solutions, sets the target variable to zero and doesn't find the solution. The solution is not that difficult - any number near 12, 20, 21 or 35 should solve the equation. File attached. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs