poi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From cen...@apache.org
Subject svn commit: r1654063 - in /poi/site: publish/spreadsheet/formula.html src/documentation/content/xdocs/spreadsheet/formula.xml
Date Thu, 22 Jan 2015 20:54:00 GMT
Author: centic
Date: Thu Jan 22 20:53:59 2015
New Revision: 1654063

URL: http://svn.apache.org/r1654063
Log:
Update/refresh doc about formulas slightly, state array forumlas as supported.

Modified:
    poi/site/publish/spreadsheet/formula.html
    poi/site/src/documentation/content/xdocs/spreadsheet/formula.xml

Modified: poi/site/publish/spreadsheet/formula.html
URL: http://svn.apache.org/viewvc/poi/site/publish/spreadsheet/formula.html?rev=1654063&r1=1654062&r2=1654063&view=diff
==============================================================================
--- poi/site/publish/spreadsheet/formula.html (original)
+++ poi/site/publish/spreadsheet/formula.html Thu Jan 22 20:53:59 2015
@@ -190,7 +190,7 @@ if (VERSION > 3) {
             
 <p>
                 This document describes the current state of formula support in POI. 
-                The information in this document currently applies to the 3.5 version of
POI. 
+                The information in this document currently applies to the 3.11 version of
POI. 
                 Since this area is a work in progress, this document will be updated with
new features as and 
                 when they are added. 
             </p>
@@ -213,6 +213,11 @@ if (VERSION > 3) {
                 to the <em> setCellFormula </em> call should be what you expect
to type into excel. Also, note
                 that you should NOT add a "=" to the front of the string.  
             </p>
+            
+<p>
+                Please note that localized versions of Excel allow to enter localized function-names.
However internally
+                Excel stores the English names and thus POI only supports these and not the
localized ones.
+            </p>
         
         
 <a name="Supported+Features"></a>
@@ -224,13 +229,15 @@ if (VERSION > 3) {
               
 <li>References: single cell &amp; area, 2D &amp; 3D, relative &amp; absolute</li>
               
-<li>Literals: Number, text, boolean, error and array</li>
+<li>Literals: number, text, boolean, error and array</li>
               
 <li>Operators: arithmetic and logical, some region operators</li>
               
 <li>Built-in functions: over 350 recognised, 280 evaluatable</li>
               
-<li>Add-in functions: 3 from Analysis Toolpack</li>
+<li>Add-in functions: 24 from Analysis Toolpack</li>
+              
+<li>Array Formulas: via Sheet.setArrayFormula() and Sheet.removeArrayFormula()</li>
         
 </ul>
         
@@ -242,7 +249,7 @@ if (VERSION > 3) {
             
 <ul>
                 
-<li>Manipulating array/table formulas (In Excel, formulas that look like "{=...}" as
opposed to "=...")</li>
+<li>Manipulating table formulas (In Excel, formulas that look like "{=...}" as opposed
to "=...")</li>
                 
 <li>Region operators: union, intersection</li>
                 
@@ -267,7 +274,7 @@ if (VERSION > 3) {
 
             
 <p>
-                The tokens used by excel are modelled as individual *Ptg classes in the <strong>
+                The tokens used by excel are modeled as individual *Ptg classes in the <strong>
                 org.apache.poi.hssf.record.formula</strong> package. 
             </p>
             
@@ -290,7 +297,6 @@ if (VERSION > 3) {
 <p>Check out the <a href="http://poi.apache.org/apidocs/">javadocs </a>
for details. 
             </p>
         
-       
     
 
 <div id="authors" align="right">by&nbsp;Avik Sengupta</div>

Modified: poi/site/src/documentation/content/xdocs/spreadsheet/formula.xml
URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/spreadsheet/formula.xml?rev=1654063&r1=1654062&r2=1654063&view=diff
==============================================================================
--- poi/site/src/documentation/content/xdocs/spreadsheet/formula.xml (original)
+++ poi/site/src/documentation/content/xdocs/spreadsheet/formula.xml Thu Jan 22 20:53:59 2015
@@ -30,7 +30,7 @@
         <section><title>Introduction</title>
             <p>
                 This document describes the current state of formula support in POI. 
-                The information in this document currently applies to the 3.5 version of
POI. 
+                The information in this document currently applies to the 3.11 version of
POI. 
                 Since this area is a work in progress, this document will be updated with
new features as and 
                 when they are added. 
             </p>
@@ -38,8 +38,8 @@
         </section>
         <section><title>The basics</title>
               <p>
-                In org.apache.poi.hssf.usermodel.HSSFCell
-                    <strong> setCellFormula(&quot;formulaString&quot;) </strong>
is used to add a formula to sheet and 
+                In org.apache.poi.ss.usermodel.Cell
+                    <strong> setCellFormula(&quot;formulaString&quot;) </strong>
is used to add a formula to a sheet and 
                     <strong> getCellFormula() </strong> is used to retrieve the
string representation of a formula. 
                 </p>
             <p>
@@ -47,19 +47,24 @@
                 to the <em> setCellFormula </em> call should be what you expect
to type into excel. Also, note
                 that you should NOT add a "=" to the front of the string.  
             </p>
+            <p>
+                Please note that localized versions of Excel allow to enter localized function-names.
However internally
+                Excel stores the English names and thus POI only supports these and not the
localized ones.
+            </p>
         </section>
         <section><title>Supported Features</title>
         <ul>
               <li>References: single cell &amp; area, 2D &amp; 3D, relative
&amp; absolute</li>
-              <li>Literals: Number, text, boolean, error and array</li>
+              <li>Literals: number, text, boolean, error and array</li>
               <li>Operators: arithmetic and logical, some region operators</li>
               <li>Built-in functions: over 350 recognised, 280 evaluatable</li>
-              <li>Add-in functions: 3 from Analysis Toolpack</li>
+              <li>Add-in functions: 24 from Analysis Toolpack</li>
+              <li>Array Formulas: via Sheet.setArrayFormula() and Sheet.removeArrayFormula()</li>
         </ul>
         </section>
         <section><title>Not yet supported</title>
             <ul>
-                <li>Manipulating array/table formulas (In Excel, formulas that look
like "{=...}" as opposed to "=...")</li>
+                <li>Manipulating table formulas (In Excel, formulas that look like
"{=...}" as opposed to "=...")</li>
                 <li>Region operators: union, intersection</li>
                 <li>Parsing of previously uncalled add-in functions</li>
                 <li>Preservation of whitespace in formulas (when POI manipulates them)</li>
@@ -74,7 +79,7 @@
             </p>
 
             <p>
-                The tokens used by excel are modelled as individual *Ptg classes in the <strong>
+                The tokens used by excel are modeled as individual *Ptg classes in the <strong>
                 org.apache.poi.hssf.record.formula</strong> package. 
             </p>
             <p>
@@ -94,6 +99,5 @@
             <p>Check out the <link href="http://poi.apache.org/apidocs/">javadocs
</link> for details. 
             </p>
         </section>
-       
     </body>
 </document>



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org


Mime
View raw message