Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous


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

constants group FunctionCategory
Description
used to specify the category of a spreadsheet function.

Constants
DATABASE specifies a database function.  
DATETIME specifies a function that calculates with dates and/or times.  
FINANCIAL specifies a financial function.  
INFORMATION specifies a function that returns information about the cell, the cell contents or the current formula.  
LOGICAL specifies a boolean function.  
MATHEMATICAL specifies a common mathematical function  
MATRIX specifies a matrix function.  
STATISTICAL specifies a statistical function  
SPREADSHEET specifies a function that returns information using the spreadsheet contents or specific cell positions.  
TEXT specifies a text function.  
ADDIN specifies a common add-in function.  
Constants' Details
DATABASE
const long DATABASE = 1;
Description
specifies a database function.
DATETIME
const long DATETIME = 2;
Description
specifies a function that calculates with dates and/or times.
FINANCIAL
const long FINANCIAL = 3;
Description
specifies a financial function.
INFORMATION
const long INFORMATION = 4;
Description
specifies a function that returns information about the cell, the cell contents or the current formula.
LOGICAL
const long LOGICAL = 5;
Description
specifies a boolean function.
MATHEMATICAL
const long MATHEMATICAL = 6;
Description
specifies a common mathematical function
MATRIX
const long MATRIX = 7;
Description
specifies a matrix function.
STATISTICAL
const long STATISTICAL = 8;
Description
specifies a statistical function
SPREADSHEET
const long SPREADSHEET = 9;
Description
specifies a function that returns information using the spreadsheet contents or specific cell positions.
TEXT
const long TEXT = 10;
Description
specifies a text function.
ADDIN
const long ADDIN = 11;
Description
specifies a common add-in function.
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.