99
edits
IO package: Difference between revisions
→Spreadsheet formula support
| Line 490: | Line 490: | ||
==== Spreadsheet formula support ==== | ==== Spreadsheet formula support ==== | ||
When using the COM, POI, JXL, and UNO interfaces you can: | When using the OCT, COM, POI, JXL, and UNO interfaces you can: | ||
* (When reading, xls2oct) either read spreadsheet formula results, or the literal formula text strings (also works with OCT interface); | * (When reading, xls2oct) either read spreadsheet formula results, or the literal formula text strings (also works with OCT interface); | ||
* (When writing, oct2xls) either enter formulas in the worksheet as formulas, or enter them as literal text strings. | * (When writing, oct2xls) either enter formulas in the worksheet as formulas, or enter them as literal text strings. | ||
| Line 502: | Line 502: | ||
Be aware that there's no formula evaluator in JExcelAPI (JXL) nor OpenXLS (OXS). So if you create formulas in your spreadsheet using oct2xls or xlswrite with 'JXL' or 'OXS', do not expect meaningful results when reading those files later on ,unless you open them in Excel and write them back to disk. | Be aware that there's no formula evaluator in JExcelAPI (JXL) nor OpenXLS (OXS). So if you create formulas in your spreadsheet using oct2xls or xlswrite with 'JXL' or 'OXS', do not expect meaningful results when reading those files later on ,unless you open them in Excel and write them back to disk. | ||
While both Apache POI and JExcelAPI feature a formula validator, not all spreadsheet functions present in Excel have been implemented (yet). | While both Apache POI and JExcelAPI feature a formula validator, not all spreadsheet functions present in Excel have been implemented (yet). <br /> | ||
Worse, older Excel versions feature less functions than newer versions. So be wary as this may make for interesting confusion. | Worse, older Excel versions feature less functions than newer versions. So be wary as this may make for interesting confusion. <br /> | ||
Reading and writing "shared formulas" with the OCT interface isn't (yet) supported; see bug | |||
[https://savannah.gnu.org/bugs/?52875 bug #52875]. | |||
==== Matlab compatibility ==== | ==== Matlab compatibility ==== | ||