Summary: | isArgumentDelimiter does not recognise semi-colon as delimiter | ||
---|---|---|---|
Product: | POI | Reporter: | Torben W <torben.wolm> |
Component: | HSSF | Assignee: | POI Developers List <dev> |
Status: | RESOLVED WONTFIX | ||
Severity: | normal | CC: | eduard.dudar |
Priority: | P2 | ||
Version: | 3.1-FINAL | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | Windows Vista |
Description
Torben W
2008-09-29 04:26:59 UTC
POI consistently treats formula argument delimiters as commas. Depending on internationalisation settings Excel will use ',' or ';' (but never both). In other words, you can enter a formula with POI using commas, and it *may* display in Excel with semicolons. Conversely, a formula entered in Excel with semi-colons will render with commas in POI. The choice of comma or semi-colon is not encoded in the excel files at all. On windows systems, it is found in the 'Regional and Language Options' of Control Panel. (So you don't need to worry about converting any XLS files). The only way this exception can occur is if you supply a formula to POI using semicolons. An easy work around is to make sure you use commas as argument delimiters in any formulas you manipulate with java code. Were you doing something else? If so, can you re-open and supply more details (full POI stack trace, sample code, sample files)? Use of semicolons in formulas was already mentioned in bug 45025. Adding an internationalision feature to POI is possible, but probably not worth the effort. |