(incubating) | The Free and Open Productivity Suite
Announcing Apache OpenOffice 3.4

Developer's Guide

API

SDK

Tips 'n' Tricks

Miscellaneous

Content for OpenOffice.org version 3.3.

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

Copyright & License | Privacy | Contact Us

Apache and the Apache feather logos 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.

Apache OpenOffice is an effort undergoing incubation at The Apache Software Foundation (ASF), sponsored by the Apache Incubator. Incubation is required of all newly accepted projects until a further review indicates that the infrastructure, communications, and decision making process have stabilized in a manner consistent with other successful ASF projects. While incubation status is not necessarily a reflection of the completeness or stability of the code, it does indicate that the project has yet to be fully endorsed by the ASF.