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 XMultipleOperation
Description
provides a method to apply a Multiple Operations Table to the cell range.
Developers Guide
Spreadsheets - Multiple Operations
Methods' Summary
setTableOperation creates a table of formulas (a "Multiple Operations Table").  
Methods' Details
setTableOperation
void
setTableOperation( [in] ::com::sun::star::table::CellRangeAddress  aFormulaRange,
[in] TableOperationMode  nMode,
[in] ::com::sun::star::table::CellAddress  aColumnCell,
[in] ::com::sun::star::table::CellAddress  aRowCell );
Description
creates a table of formulas (a "Multiple Operations Table").

The specified formulas are repeated, with references to the specified cells replaced by references to values in the first column and/or row of the range.

Parameter aFormulaRange
the range that contains formula cells (modes TableOperationMode::ROW or TableOperationMode::COLUMN) or a single formula cell (mode TableOperationMode::BOTH).
Parameter nMode
specifies the calculation mode to fill the cells.
Parameter aColumnCell
contains the address of the cell that is referenced by formulas in a row (mode TableOperationMode::ROW) or by the formula cell used for two value series (mode TableOperationMode::BOTH). This parameter is not used if mode is TableOperationMode::COLUMN.
Parameter aRowCell
contains the address of the cell that is referenced by formulas in a column (mode TableOperationMode::COLUMN) or by the formula cell used for two value series (mode TableOperationMode::BOTH). This parameter is not used if mode is TableOperationMode::ROW.
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.