|
Lines 47-53
Link Here
|
| 47 |
Excel, until you go to the cell and hit enter or F9, you will either see |
47 |
Excel, until you go to the cell and hit enter or F9, you will either see |
| 48 |
the old value or '#VALUE!' for the cell. (Sometimes Excel will notice |
48 |
the old value or '#VALUE!' for the cell. (Sometimes Excel will notice |
| 49 |
itself, and trigger a recalculation on load, but unless you know you are |
49 |
itself, and trigger a recalculation on load, but unless you know you are |
| 50 |
using volatile functions it's generally best to trigger a Recalulation |
50 |
using volatile functions it's generally best to trigger a <a href="#recalculation">Recalulation</a> |
| 51 |
through POI) |
51 |
through POI) |
| 52 |
</p> |
52 |
</p> |
| 53 |
</section> |
53 |
</section> |
|
Lines 62-69
Link Here
|
| 62 |
for details. </p> |
62 |
for details. </p> |
| 63 |
<p> Both HSSFWorkbook and XSSFWorkbook are supported, so you can |
63 |
<p> Both HSSFWorkbook and XSSFWorkbook are supported, so you can |
| 64 |
evaluate formulas on both .xls and .xlsx files.</p> |
64 |
evaluate formulas on both .xls and .xlsx files.</p> |
| 65 |
<p> Note that user-defined functions are not supported, and is not likely to done |
65 |
<p> User-defined functions are <a href="user-defined-functions.html">supported</a>, |
| 66 |
any time soon... at least, not till there is a VB implementation in Java! |
66 |
but must be rewritten in Java and registered with the macro-enabled workbook in order to be evaluated. |
| 67 |
</p> |
67 |
</p> |
| 68 |
</section> |
68 |
</section> |
| 69 |
<section><title>User API How-TO</title> |
69 |
<section><title>User API How-TO</title> |