<html> <head> <title>Constants' Group DataPilotFieldReferenceType</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 DataPilotFieldReferenceType</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>These constants select different types of References to calculate the data fields. </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">This type means, that the results in the data fields are displayed like they are. </td> </tr> <tr> <td class="imsum_left"><a href="#ITEM_DIFFERENCE">ITEM_DIFFERENCE</a></td> <td class="imsum_right">From each result, its reference value (see below) is subtracted, and the difference is shown. Totals outside of the base field are shown as empty results. </td> </tr> <tr> <td class="imsum_left"><a href="#ITEM_PERCENTAGE">ITEM_PERCENTAGE</a></td> <td class="imsum_right">Each result is divided by its reference value. The reference value is determined in the same way as for <b>DataPilotFieldReferenceType::ITEM_DIFFERENCE</b>. Totals outside of the base field are shown as empty results. </td> </tr> <tr> <td class="imsum_left"><a href="#ITEM_PERCENTAGE_DIFFERENCE">ITEM_PERCENTAGE_DIFFERENCE</a></td> <td class="imsum_right">From each result, its reference value is subtracted, and the difference divided by the reference value. The reference value is determined in the same way as for <b>DataPilotFieldReferenceType::ITEM_DIFFERENCE</b>. Totals outside of the base field are shown as empty results. </td> </tr> <tr> <td class="imsum_left"><a href="#RUNNING_TOTAL">RUNNING_TOTAL</a></td> <td class="imsum_right">Each result is added to the sum of the results for preceding items in the base field, in the base field's sort order, and the total sum is shown. </td> </tr> <tr> <td class="imsum_left"><a href="#ROW_PERCENTAGE">ROW_PERCENTAGE</a></td> <td class="imsum_right">Each result is divided by the total result for its row in the DataPilot table. </td> </tr> <tr> <td class="imsum_left"><a href="#COLUMN_PERCENTAGE">COLUMN_PERCENTAGE</a></td> <td class="imsum_right">Same as <b>DataPilotFieldReferenceType::ROW_PERCENTAGE</b>, but the total for the result's column is used. </td> </tr> <tr> <td class="imsum_left"><a href="#TOTAL_PERCENTAGE">TOTAL_PERCENTAGE</a></td> <td class="imsum_right">Same as <b>DataPilotFieldReferenceType::ROW_PERCENTAGE</b>, but the grand total for the result's data field is used. </td> </tr> <tr> <td class="imsum_left"><a href="#INDEX">INDEX</a></td> <td class="imsum_right">The row and column totals and the grand total, following the same rules as above, are used to calculate the following expression. </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 long <b>NONE</b> = 0;<hr> <dl> <dt><b>Description</b></dt> <dd>This type means, that the results in the data fields are displayed like they are. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="ITEM_DIFFERENCE" class="membertitle">ITEM_DIFFERENCE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>ITEM_DIFFERENCE</b> = 1;<hr> <dl> <dt><b>Description</b></dt> <dd>From each result, its reference value (see below) is subtracted, and the difference is shown. Totals outside of the base field are shown as empty results. </dd> <dd><p><b>Named Item</b></p> <p>If a base item name is specified, the reference value for a combination of field items is the result where the item in the base field is replaced by the specified base item.</p> <p>If the reference value isn't shown in the DataPilot table because of hidden details for a parent field, the difference isn't calculated and an error value is shown.</p> <p>If the result for an item combination is empty, the value 0 is used for the difference, even if the summary function is undefined without values, like average or variance. The difference is shown in the result table even if the original result was empty.</p> <p>The difference for item combinations containing the base item is shown as empty result.</p> <p><b>Previous or Next</b></p> <p>If "previous" or "next" is specified as the base item, the reference value is the result for the next visible member of the base field, in the base field's sort order. If details for one item in the base field are hidden, that item is skipped. The difference for the item with hidden details isn't calculated, not even for the item's summary, to have a consistent order of previous and next items.</p> <p>Empty results are handled as for named items (see above).<p> <p>The difference for the first (for <TYPE>com::sun::star::sheet::DataPilotFieldReferenceItemType::PREVIOUS</TYPE>) or last (for <TYPE>com::sun::star::sheet::DataPilotFieldReferenceItemType::NEXT</TYPE>) item of the base field is shown as empty result.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="ITEM_PERCENTAGE" class="membertitle">ITEM_PERCENTAGE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>ITEM_PERCENTAGE</b> = 2;<hr> <dl> <dt><b>Description</b></dt> <dd>Each result is divided by its reference value. The reference value is determined in the same way as for <b>DataPilotFieldReferenceType::ITEM_DIFFERENCE</b>. Totals outside of the base field are shown as empty results. </dd> <dd><p>Division by zero results in an error. Otherwise, empty results are shown as 0. Results for the base item, first (for <TYPE>com::sun::star::sheet::DataPilotFieldReferenceItemType::PREVIOUS</TYPE>) or last (for <TYPE>com::sun::star::sheet::DataPilotFieldReferenceItemType::NEXT</TYPE>) item of the base field are shown as 1 if not empty.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="ITEM_PERCENTAGE_DIFFERENCE" class="membertitle">ITEM_PERCENTAGE_DIFFERENCE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>ITEM_PERCENTAGE_DIFFERENCE</b> = 3;<hr> <dl> <dt><b>Description</b></dt> <dd>From each result, its reference value is subtracted, and the difference divided by the reference value. The reference value is determined in the same way as for <b>DataPilotFieldReferenceType::ITEM_DIFFERENCE</b>. Totals outside of the base field are shown as empty results. </dd> <dd><p>Division by zero results in an error. Otherwise, the rules for <b>DataPilotFieldReferenceType::ITEM_DIFFERENCE</b> apply.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="RUNNING_TOTAL" class="membertitle">RUNNING_TOTAL</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>RUNNING_TOTAL</b> = 4;<hr> <dl> <dt><b>Description</b></dt> <dd>Each result is added to the sum of the results for preceding items in the base field, in the base field's sort order, and the total sum is shown. </dd> <dd><p>If details for one item in the base field are hidden, that item isn't included in calculating the sum, and results for that item are shown as error, to ensure consistency between details and subtotals for the following items.</p> <p>Results are always summed, even if a different summary function was used to get each result.</p> <p>Totals outside of the base field are shown as empty results.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="ROW_PERCENTAGE" class="membertitle">ROW_PERCENTAGE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>ROW_PERCENTAGE</b> = 5;<hr> <dl> <dt><b>Description</b></dt> <dd>Each result is divided by the total result for its row in the DataPilot table. </dd> <dd><p>If there are several data fields, the total for the result's data field is used.</p> <p>If there are subtotals with manually selected summary functions, still the total with the data field's summary function is used.</p> <p>Division by zero results in an error.</p> <p>Otherwise, empty results remain empty.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="COLUMN_PERCENTAGE" class="membertitle">COLUMN_PERCENTAGE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>COLUMN_PERCENTAGE</b> = 6;<hr> <dl> <dt><b>Description</b></dt> <dd>Same as <b>DataPilotFieldReferenceType::ROW_PERCENTAGE</b>, but the total for the result's column is used. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="TOTAL_PERCENTAGE" class="membertitle">TOTAL_PERCENTAGE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>TOTAL_PERCENTAGE</b> = 7;<hr> <dl> <dt><b>Description</b></dt> <dd>Same as <b>DataPilotFieldReferenceType::ROW_PERCENTAGE</b>, but the grand total for the result's data field is used. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="INDEX" class="membertitle">INDEX</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>INDEX</b> = 8;<hr> <dl> <dt><b>Description</b></dt> <dd>The row and column totals and the grand total, following the same rules as above, are used to calculate the following expression. </dd> <dd><p>( original result * grand total ) / ( row total * column total )</p> <p>Division by zero results in an error. Otherwise, empty results remain empty.</p> </dd> </dl> </td> </tr> </table> </td> </tr> </table> <a href="#_top_">Top of Page</a><hr size="3"><p class="copyright" align="center">Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.</p> </div> <!-- id="adc-idlref" --> </body> </html>
distrib
>
Mandriva
>
current
>
i586
>
media
>
main-updates
>
by-pkgid
>
fc480f9d5aabed8eeaffe8ad3401a94c
>
files
>
5805
