English:

The Free and Open Productivity Suite
New: Apache OpenOffice 4.1.1 released!

Developer's Guide

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

Logo ApacheCon Europe 2014

Apache Feather

Copyright & License | Privacy | Website Feedback | Contact Us | Donate | Thanks

Apache, the Apache feather logo, and OpenOffice 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.