IO package: Difference between revisions
→Spreadsheet formula support
| Line 297: | Line 297: | ||
=== Spreadsheet formula support === | === Spreadsheet formula support === | ||
When using the POI and | When using the COM, POI, JXL, and UNO interfaces you can: | ||
* (When reading, xls2oct) either read spreadsheet formula results | * (When reading, xls2oct) either read spreadsheet formula results, or the literal formula text strings; | ||
* (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. | ||
In short, you can enter spreadsheet formulas and in a later stage read them back, change them and re-enter them in the worksheet. | In short, you can enter spreadsheet formulas and in a later stage read them back, change them and re-enter them in the worksheet. | ||
| Line 307: | Line 307: | ||
* options.formulas_as_text =1 (or any positive integer) means enter formulas as text strings and read them back as text strings. | * options.formulas_as_text =1 (or any positive integer) means enter formulas as text strings and read them back as text strings. | ||
Be aware that there's no formula evaluator in JExcelAPI (JXL). So if you create formulas in your spreadsheet using oct2xls or xlswrite with 'JXL', do not expect meaningful results when reading those files later on | 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). | ||
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. | ||
=== Matlab compatibility === | === Matlab compatibility === | ||