Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous


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

service FunctionAccess
Description
allows generic access to all spreadsheet functions.
Developers Guide
Spreadsheets - Function Handling - Calculating Function Results

Included Services - Summary
SpreadsheetDocumentSettings

contributes properties to control the behaviour of some functions (i.e. NullDate, IgnoreCase, RegularExpressions).

Exported Interfaces - Summary
XFunctionAccess

provides calculating the result of a spreadsheet function.

Properties' Summary
boolean
IsArrayFunction
[ OPTIONAL ]
specifies whether the function call is performed as array function call.  
Included Services - Details
SpreadsheetDocumentSettings
Description
contributes properties to control the behaviour of some functions (i.e. NullDate, IgnoreCase, RegularExpressions).
Exported Interfaces - Details
XFunctionAccess
Description
provides calculating the result of a spreadsheet function.
Properties' Details
IsArrayFunction
boolean IsArrayFunction;
Usage Restrictions
optional
Description
specifies whether the function call is performed as array function call.

If set to true, the result of the function call will be calculated similar to array formulas in a spreadsheet document. The return value of the function call will usually be a sequence of sequences containing the values of the resulting array. Example: If the function ABS is called for a 3x2 cell range, the result will be a 3x2 array containing the absolute values of the numbers contained in the specified cell range.

If set to false, the result of the function call will be calculated similar to simple cell formulas in a spreadsheet document. The return value of the function call will usually be a single value. Of course, some functions always return an array, for example the MUNIT function.

For compatibility with older versions, the default value of this property is true.

Since
OOo 3.3

 
Top of Page

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.