<html> <head> <title>Constants' Group StatusBarFunction</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link rel="stylesheet" type="text/css" href="../../../../idl.css"> </head> <body> <div id="adc-idlref"> <a name="_top_"> </a><table class="navimain" border="0" cellpadding="3"> <tr> <td class="navimain"><a href="../module-ix.html" class="navimain">Overview</a></td> <td class="navimain"><a href="module-ix.html" class="navimain">Module</a></td> <td class="navimainnone">Use</td> <td class="navimainnone">Devguide</td> <td class="navimain"><a href="../../../../index-files/index-1.html" class="navimain">Index</a></td> </tr> </table> <table class="navisub" border="0" cellpadding="0"> <tr> <td class="navisub"><a href="#Constants" class="navisub">Constants</a></td> <td class="navisub"><a href="#ConstantDetails" class="navisub">Constants' Details</a></td> </tr> </table> <hr> <table border="0" width="100%" cellpadding="5" cellspacing="3" class="title-table" style="margin-bottom:6pt;"> <tr> <td><p class="namechain"><a href="../../../../module-ix.html" class="namechain">::</a> <a href="../../../module-ix.html" class="namechain">com</a> :: <a href="../../module-ix.html" class="namechain">sun</a> :: <a href="../module-ix.html" class="namechain">star</a> :: <a href="module-ix.html" class="namechain">sheet</a> :: </p> </td> </tr> <tr> <td class="title">constants group StatusBarFunction</td> </tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>used to specify the function used to calculate a result in the spreadsheet's status bar. </dd> </dl> </td> </tr> </table> <hr> <a name="Constants"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Constants</td> </tr> <tr> <td class="imsum_left"><a href="#NONE">NONE</a></td> <td class="imsum_right">nothing is calculated. </td> </tr> <tr> <td class="imsum_left"><a href="#AVERAGE">AVERAGE</a></td> <td class="imsum_right">average of all numerical values is calculated. </td> </tr> <tr> <td class="imsum_left"><a href="#COUNTNUMS">COUNTNUMS</a></td> <td class="imsum_right">all values, including non-numerical values, are counted. </td> </tr> <tr> <td class="imsum_left"><a href="#COUNT">COUNT</a></td> <td class="imsum_right">numerical values are counted. </td> </tr> <tr> <td class="imsum_left"><a href="#MAX">MAX</a></td> <td class="imsum_right">maximum value of all numerical values is calculated. </td> </tr> <tr> <td class="imsum_left"><a href="#MIN">MIN</a></td> <td class="imsum_right">minimum value of all numerical values is calculated. </td> </tr> <tr> <td class="imsum_left"><a href="#SUM">SUM</a></td> <td class="imsum_right">sum of all numerical values is calculated. </td> </tr> </table> <a name="ConstantDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle">Constants' Details</td> </tr> <tr> <td class="imdetail"><a name="NONE" class="membertitle">NONE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>NONE</b> = 0;<hr> <dl> <dt><b>Description</b></dt> <dd>nothing is calculated. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="AVERAGE" class="membertitle">AVERAGE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>AVERAGE</b> = 1;<hr> <dl> <dt><b>Description</b></dt> <dd>average of all numerical values is calculated. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="COUNTNUMS" class="membertitle">COUNTNUMS</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>COUNTNUMS</b> = 2;<hr> <dl> <dt><b>Description</b></dt> <dd>all values, including non-numerical values, are counted. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="COUNT" class="membertitle">COUNT</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>COUNT</b> = 3;<hr> <dl> <dt><b>Description</b></dt> <dd>numerical values are counted. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="MAX" class="membertitle">MAX</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>MAX</b> = 4;<hr> <dl> <dt><b>Description</b></dt> <dd>maximum value of all numerical values is calculated. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="MIN" class="membertitle">MIN</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>MIN</b> = 5;<hr> <dl> <dt><b>Description</b></dt> <dd>minimum value of all numerical values is calculated. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="SUM" class="membertitle">SUM</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>SUM</b> = 9;<hr> <dl> <dt><b>Description</b></dt> <dd>sum of all numerical values is calculated. </dd> </dl> </td> </tr> </table> </td> </tr> </table> <a href="#_top_">Top of Page</a><hr size="3"><p class="copyright" align="center">Copyright © 2000, 2012 LibreOffice contributors and/or their affiliates. All rights reserved.</p><p class="copyright" align="center">LibreOffice was created by The Document Foundation, based on OpenOffice.org, which is Copyright 2000, 2010 Oracle and/or its affiliates.</p><p class="copyright" align="center">The Document Foundation acknowledges all community members, please find more info <a href="http://www.libreoffice.org/about-us/credits/" target="_blank">at our website</a>.<p> </p><p class="copyright" align="center"><a href="http://www.libreoffice.org/privacy" target="_blank">Privacy Policy</a> | <a href="http://www.libreoffice.org/imprint" target="_blank">Impressum (Legal Info)</a> | Copyright information: The source code of LibreOffice is licensed under the GNU Lesser General Public License (<a href="http://www.libreoffice.org/download/license/" target="_blank">LGPLv3</a>). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our <a href="http://wiki.documentfoundation.org/TradeMark_Policy" target="_blank">trademark policy</a>.</p> </div> <!-- id="adc-idlref" --> </body> </html>
