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 StatusBarFunction
Description
used to specify the function used to calculate a result in the spreadsheet's status bar.

Constants
NONE nothing is calculated.  
AVERAGE average of all numerical values is calculated.  
COUNTNUMS all values, including non-numerical values, are counted.  
COUNT numerical values are counted.  
MAX maximum value of all numerical values is calculated.  
MIN minimum value of all numerical values is calculated.  
SUM sum of all numerical values is calculated.  
Constants' Details
NONE
const short NONE = 0;
Description
nothing is calculated.
AVERAGE
const short AVERAGE = 1;
Description
average of all numerical values is calculated.
COUNTNUMS
const short COUNTNUMS = 2;
Description
all values, including non-numerical values, are counted.
COUNT
const short COUNT = 3;
Description
numerical values are counted.
MAX
const short MAX = 4;
Description
maximum value of all numerical values is calculated.
MIN
const short MIN = 5;
Description
minimum value of all numerical values is calculated.
SUM
const short SUM = 9;
Description
sum of all numerical values is calculated.
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.