Overview | Module | Use | Devguide | Index

Methods' Summary | Methods' Details | Attributes' Summary | Attributes' Details

:: com :: sun :: star :: sheet ::
interface XGoalSeek
  Base Hierarchy
      ::com::sun::star::uno::XInterface
       |
       +-XGoalSeek
Description provides seeking a goal value for a cell.

Methods' Summary
seekGoal | calculates a value which gives a specified result in a formula.

Methods' Details
seekGoal
GoalResult seekGoal( | [in] ::com::sun::star::table::CellAddress [in] ::com::sun::star::table::CellAddress [in] string | aFormulaPosition, aVariablePosition, aGoalValue );
Description calculates a value which gives a specified result in a formula. Parameter aFormulaPosition is the address of the formula cell used for the calculation. Parameter aVariablePosition is the address of the cell that is used in the formula as variable. Parameter aGoalValue is the value which should be reached during the goal seek. Returns the result of the goal seek, including the value that results in the specified goal, using the specified formula.

Top of Page

Copyright © 2003 Sun Microsystems, Inc.