<html> <head> <title>Constants' Group FormulaMapGroupSpecialOffset</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"><table class="title-table" width="99%"> <tr> <td width="25%" class="title2">unpublished </td> <td width="50%" class="title">constants group FormulaMapGroupSpecialOffset</td> <td width="*"/></tr> </table> </td> </tr> <tr> <td><dl> <dt><b>Usage Restrictions</b></dt> <dd><i>not published</i></dd> <dt><b>Description</b></dt> <dd>Constants designating the offsets within the sequence returned by <a href="XFormulaOpCodeMapper.html">XFormulaOpCodeMapper</a>::<a href="XFormulaOpCodeMapper.html#getAvailableMappings">getAvailableMappings</a> when called for group <b>FormulaMapGroup::SPECIAL</b>. </dd> <dd><p>The number of constants may grow in future versions!</p> </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="#PUSH">PUSH</a></td> <td class="imsum_right">Formula tokens containing the op-code obtained from this offset describe a formula operand token that will be pushed onto the formula stack while the formula is interpreted. </td> </tr> <tr> <td class="imsum_left"><a href="#CALL">CALL</a></td> <td class="imsum_right"> </td> </tr> <tr> <td class="imsum_left"><a href="#STOP">STOP</a></td> <td class="imsum_right">Formula tokens containing the op-code obtained from this offset instruct the formula interpreter to immediately stop interpreting the formula. </td> </tr> <tr> <td class="imsum_left"><a href="#EXTERNAL">EXTERNAL</a></td> <td class="imsum_right">Formula tokens containing the op-code obtained from this offset describe the reference to an external function (e.g. add-in function) used in formulas. </td> </tr> <tr> <td class="imsum_left"><a href="#NAME">NAME</a></td> <td class="imsum_right">Formula tokens containing the op-code obtained from this offset describe the reference to a defined name (also known as named range) used in formulas. </td> </tr> <tr> <td class="imsum_left"><a href="#NO_NAME">NO_NAME</a></td> <td class="imsum_right">Formula tokens containing the op-code obtained from this offset describe an invalid name that resolves to the #NAME? error in formulas. </td> </tr> <tr> <td class="imsum_left"><a href="#MISSING">MISSING</a></td> <td class="imsum_right">Formula tokens containing the op-code obtained from this offset describe an empty function parameter. </td> </tr> <tr> <td class="imsum_left"><a href="#BAD">BAD</a></td> <td class="imsum_right">Formula tokens containing the op-code obtained from this offset describe "bad" data in a formula, e.g. data the formula parser was not able to parse. </td> </tr> <tr> <td class="imsum_left"><a href="#SPACES">SPACES</a></td> <td class="imsum_right">Formula tokens containing the op-code obtained from this offset describe whitespace characters within the string representation of a formula. </td> </tr> <tr> <td class="imsum_left"><a href="#MAT_REF">MAT_REF</a></td> <td class="imsum_right"> </td> </tr> <tr> <td class="imsum_left"><a href="#DB_AREA">DB_AREA</a></td> <td class="imsum_right">Formula tokens containing the op-code obtained from this offset describe the reference to a database range used in formulas. </td> </tr> <tr> <td class="imsum_left"><a href="#MACRO">MACRO</a></td> <td class="imsum_right">Formula tokens containing the op-code obtained from this offset describe the reference to a macro function called in a formula. </td> </tr> <tr> <td class="imsum_left"><a href="#COL_ROW_NAME">COL_ROW_NAME</a></td> <td class="imsum_right"> </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="PUSH" class="membertitle">PUSH</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>PUSH</b> = 0;<hr> <dl> <dt><b>Description</b></dt> <dd>Formula tokens containing the op-code obtained from this offset describe a formula operand token that will be pushed onto the formula stack while the formula is interpreted. </dd> <dd><p>The <a href="FormulaToken.html">FormulaToken</a>::<a href="FormulaToken.html#Data">Data</a> member shall contain one of the following values:</p> <ul> <li>A value of type <code>double</code> for literal floating-point constants.</li> <li>A <code>string</code> for literal text.</li> <li>A <code>any</code>[][] for a literal array. The contained values shall be of type <code>double</code> or <code>string</code>. Floating-point values and strings may occur together in an array.</li> <li>A struct of type <a href="SingleReference.html">SingleReference</a> for a reference to a single cell in the own document.</li> <li>A struct of type <a href="ComplexReference.html">ComplexReference</a> for a reference to a range of cells in the own document.</li> <li>A struct of type <a href="ExternalReference.html">ExternalReference</a> for a reference to a cell, a range of cells, or a defined name in an external document.</li> </ul> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="CALL" class="membertitle">CALL</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>CALL</b> = 1;<hr> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="STOP" class="membertitle">STOP</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>STOP</b> = 2;<hr> <dl> <dt><b>Description</b></dt> <dd>Formula tokens containing the op-code obtained from this offset instruct the formula interpreter to immediately stop interpreting the formula. </dd> <dd><p>The <a href="FormulaToken.html">FormulaToken</a>::<a href="FormulaToken.html#Data">Data</a> member is not used and should be empty.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="EXTERNAL" class="membertitle">EXTERNAL</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>EXTERNAL</b> = 3;<hr> <dl> <dt><b>Description</b></dt> <dd>Formula tokens containing the op-code obtained from this offset describe the reference to an external function (e.g. add-in function) used in formulas. </dd> <dd><p>The <a href="FormulaToken.html">FormulaToken</a>::<a href="FormulaToken.html#Data">Data</a> member shall contain a <code>string</code> with the programmatic name of the function, e.g. "com.sun.star.sheet.addin.Analysis.getEomonth" for the EOMONTH function from the Analysis add-in.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="NAME" class="membertitle">NAME</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>NAME</b> = 4;<hr> <dl> <dt><b>Description</b></dt> <dd>Formula tokens containing the op-code obtained from this offset describe the reference to a defined name (also known as named range) used in formulas. </dd> <dd><p>The <a href="FormulaToken.html">FormulaToken</a>::<a href="FormulaToken.html#Data">Data</a> member shall contain an integer value of type <code>long</code> specifying the index of the defined name. This index can be obtained from the defined name using its <a href="NamedRange.html">NamedRange</a>::<a href="NamedRange.html#TokenIndex">TokenIndex</a> property.</p> </dd> <dt><b>See also</b></dt> <dd><a href="NamedRange.html">NamedRange</a></dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="NO_NAME" class="membertitle">NO_NAME</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>NO_NAME</b> = 5;<hr> <dl> <dt><b>Description</b></dt> <dd>Formula tokens containing the op-code obtained from this offset describe an invalid name that resolves to the #NAME? error in formulas. </dd> <dd><p>The <a href="FormulaToken.html">FormulaToken</a>::<a href="FormulaToken.html#Data">Data</a> member is not used and should be empty.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="MISSING" class="membertitle">MISSING</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>MISSING</b> = 6;<hr> <dl> <dt><b>Description</b></dt> <dd>Formula tokens containing the op-code obtained from this offset describe an empty function parameter. </dd> <dd><p>Example: In the formula <code>=SUM(1;;2)</code> the second parameter is empty and represented by a formula token containing the "missing" op-code.</p> <p>The <a href="FormulaToken.html">FormulaToken</a>::<a href="FormulaToken.html#Data">Data</a> member is not used and should be empty.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="BAD" class="membertitle">BAD</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>BAD</b> = 7;<hr> <dl> <dt><b>Description</b></dt> <dd>Formula tokens containing the op-code obtained from this offset describe "bad" data in a formula, e.g. data the formula parser was not able to parse. </dd> <dd><p>The <a href="FormulaToken.html">FormulaToken</a>::<a href="FormulaToken.html#Data">Data</a> member shall contain a <code>string</code> with the bad data. This string will be displayed literally in the formula.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="SPACES" class="membertitle">SPACES</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>SPACES</b> = 8;<hr> <dl> <dt><b>Description</b></dt> <dd>Formula tokens containing the op-code obtained from this offset describe whitespace characters within the string representation of a formula. </dd> <dd><p>Whitespace characters in formulas are used for readability and do not affect the result of the formula.</p> <p>The <a href="FormulaToken.html">FormulaToken</a>::<a href="FormulaToken.html#Data">Data</a> member shall contain a positive integer value of type <code>long</code> specifying the number of space characters.</p> <p>Attention: This may change in next versions to support other characters than simple space characters (e.g. line feeds, horizontal tabulators, non-breakable spaces).</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="MAT_REF" class="membertitle">MAT_REF</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>MAT_REF</b> = 9;<hr> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="DB_AREA" class="membertitle">DB_AREA</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>DB_AREA</b> = 10;<hr> <dl> <dt><b>Description</b></dt> <dd>Formula tokens containing the op-code obtained from this offset describe the reference to a database range used in formulas. </dd> <dd><p>The <a href="FormulaToken.html">FormulaToken</a>::<a href="FormulaToken.html#Data">Data</a> member shall contain an integer value of type <code>long</code> specifying the index of the database range. This index can be obtained from the database range using its <a href="DatabaseRange.html">DatabaseRange</a>::<a href="DatabaseRange.html#TokenIndex">TokenIndex</a> property.</p> </dd> <dt><b>See also</b></dt> <dd><a href="DatabaseRange.html">DatabaseRange</a></dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="MACRO" class="membertitle">MACRO</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>MACRO</b> = 11;<hr> <dl> <dt><b>Description</b></dt> <dd>Formula tokens containing the op-code obtained from this offset describe the reference to a macro function called in a formula. </dd> <dd><p>The <a href="FormulaToken.html">FormulaToken</a>::<a href="FormulaToken.html#Data">Data</a> member shall contain a <code>string</code> specifying the name of the macro function.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="COL_ROW_NAME" class="membertitle">COL_ROW_NAME</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>COL_ROW_NAME</b> = 12;<hr> </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>