English:

The Free and Open Productivity Suite
New: Apache OpenOffice 4.1.1 released!

Developer's Guide

API

SDK

Tips 'n' Tricks

Miscellaneous


:: com :: sun :: star :: sheet ::

interface 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  aFormulaPosition,
[in] ::com::sun::star::table::CellAddress  aVariablePosition,
[in] string  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

Logo ApacheCon Europe 2014

Apache Feather

Copyright & License | Privacy | Website Feedback | Contact Us | Donate | Thanks

Apache, the Apache feather logo, and OpenOffice are trademarks of The Apache Software Foundation. OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.