Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous

Overview Module Use Devguide Index
Methods' Summary Attributes' Summary Methods' Details Attributes' Details

:: 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

Copyright © 2013, The Apache Software Foundation, Licensed under the Apache License, Version 2.0. Apache, the Apache feather logo, Apache OpenOffice and OpenOffice.org are trademarks of The Apache Software Foundation. Other names may be trademarks of their respective owners.

Apache Software Foundation

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

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