https://bugs.freedesktop.org/show_bug.cgi?id=64499
Priority: medium
Bug ID: 64499
Assignee: [email protected]
Summary: Goalseek does not get answer although Excel has no
problem on same sheet saved in xls format
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 4.0.2.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 79200
--> https://bugs.freedesktop.org/attachment.cgi?id=79200&action=edit
Worksheet that Goalseek does not work on.
In a spreadsheet goalseek and solver does not work although the same sheet
works in Excel. I firstly removed all unused sheets - no effect. Then saved it
back in xls format and Excel still found the answer without a problem. Sheet
attached. Note these are excel macros and I have not sorted out for LibreOffice
so was first doing manually to get working. Goalseek cell D9 to 200 000 by
changing cell B6
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs