Overview | Module | Use | Devguide | Index

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

:: com :: sun :: star :: sheet ::
interface XMultipleOperation
  Base Hierarchy
      ::com::sun::star::uno::XInterface
       |
       +-XMultipleOperation
Description provides a method to apply a Multiple Operations Table to the cell range. Developers Guide 8.3.1 Spreadsheet Documents - Working with Spreadsheet Documents - Document Structure - Cell Ranges - 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 [in] TableOperationMode [in] ::com::sun::star::table::CellAddress [in] ::com::sun::star::table::CellAddress | aFormulaRange, nMode, aColumnCell, 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 © 2003 Sun Microsystems, Inc.