http://openoffice.org/bugzilla/show_bug.cgi?id=118091

        Issue Type: ENHANCEMENT
           Summary: Enhance Goal Seek to support ranges and generalised
                    Targets
    Classification: Application
           Product: Spreadsheet
           Version: OOo 3.3
          Platform: PC
        OS/Version: Windows Vista
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: P3
         Component: ui
        AssignedTo: [email protected]
        ReportedBy: [email protected]
         QAContact: [email protected]


When I run Calc's "Goal Seek..." from the Tools menu, it only allows me to
select one cell for the "Formula cell" and one for the "Variable cell" plus a
"Target value".

It would be very useful if I could specify a range [eg 8 cells in a column or
in a row] for the cells.  The ranges would have to be of matching dimensions
and there might need to be constraints on overlapping and/or precedent trees.

It would be very useful if I could specify a "Target cell" instead of a value. 
Again, there might need to be constraints on overlapping and/or precedent
trees.

If both of the above enhancements were made then it be very useful if I could
specify a range for the Target instead of just a cell.  Again, the ranges would
have to be of matching dimensions and there might need to be constraints on
overlapping and/or precedent trees.

I have OOO330m20 Build:9567

-- 
Configure bugmail: http://openoffice.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.

---------------------------------------------------------------------
Please do not reply to this automatically generated notification
from Bugzilla. Please log into the website and enter your comments.
---------------------------------------------------------------------
-- 
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
-- 
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help

Reply via email to