You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by on...@apache.org on 2015/10/23 11:32:05 UTC
svn commit: r1710154 - in /poi/site: publish/spreadsheet/eval.html
src/documentation/content/xdocs/spreadsheet/eval.xml
Author: onealj
Date: Fri Oct 23 09:32:05 2015
New Revision: 1710154
URL: http://svn.apache.org/viewvc?rev=1710154&view=rev
Log:
bug 58459: web doc update: user-defined function evaluation is supported
Modified:
poi/site/publish/spreadsheet/eval.html
poi/site/src/documentation/content/xdocs/spreadsheet/eval.xml
Modified: poi/site/publish/spreadsheet/eval.html
URL: http://svn.apache.org/viewvc/poi/site/publish/spreadsheet/eval.html?rev=1710154&r1=1710153&r2=1710154&view=diff
==============================================================================
--- poi/site/publish/spreadsheet/eval.html (original)
+++ poi/site/publish/spreadsheet/eval.html Fri Oct 23 09:32:05 2015
@@ -216,7 +216,7 @@ if (VERSION > 3) {
Excel, until you go to the cell and hit enter or F9, you will either see
the old value or '#VALUE!' for the cell. (Sometimes Excel will notice
itself, and trigger a recalculation on load, but unless you know you are
- using volatile functions it's generally best to trigger a Recalulation
+ using volatile functions it's generally best to trigger a <a href="#recalculation">Recalulation</a>
through POI)
</p>
@@ -238,8 +238,8 @@ if (VERSION > 3) {
<p> Both HSSFWorkbook and XSSFWorkbook are supported, so you can
evaluate formulas on both .xls and .xlsx files.</p>
-<p> Note that user-defined functions are not supported, and is not likely to done
- any time soon... at least, not till there is a VB implementation in Java!
+<p> User-defined functions are <a href="user-defined-functions.html">supported</a>,
+ but must be rewritten in Java and registered with the macro-enabled workbook in order to be evaluated.
</p>
@@ -690,7 +690,7 @@ mainWorkbookEvaluator.evaluateAll();
<td colspan="2">
<div align="center">
<div class="copyright">
- Copyright © 2002-2014 The Apache Software Foundation. All rights reserved.<br>
+ Copyright © 2002-2015 The Apache Software Foundation. All rights reserved.<br>
Apache POI, POI, Apache, the Apache feather logo, and the Apache
POI project logo are trademarks of The Apache Software Foundation.
</div>
Modified: poi/site/src/documentation/content/xdocs/spreadsheet/eval.xml
URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/spreadsheet/eval.xml?rev=1710154&r1=1710153&r2=1710154&view=diff
==============================================================================
--- poi/site/src/documentation/content/xdocs/spreadsheet/eval.xml (original)
+++ poi/site/src/documentation/content/xdocs/spreadsheet/eval.xml Fri Oct 23 09:32:05 2015
@@ -47,7 +47,7 @@
Excel, until you go to the cell and hit enter or F9, you will either see
the old value or '#VALUE!' for the cell. (Sometimes Excel will notice
itself, and trigger a recalculation on load, but unless you know you are
- using volatile functions it's generally best to trigger a Recalulation
+ using volatile functions it's generally best to trigger a <link href="#recalculation">Recalulation</link>
through POI)
</p>
</section>
@@ -62,8 +62,8 @@
for details. </p>
<p> Both HSSFWorkbook and XSSFWorkbook are supported, so you can
evaluate formulas on both .xls and .xlsx files.</p>
- <p> Note that user-defined functions are not supported, and is not likely to done
- any time soon... at least, not till there is a VB implementation in Java!
+ <p> User-defined functions are <link href="user-defined-functions.html">supported</link>,
+ but must be rewritten in Java and registered with the macro-enabled workbook in order to be evaluated.
</p>
</section>
<section><title>User API How-TO</title>
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org