You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2008/09/29 23:25:57 UTC
DO NOT REPLY [Bug 45909] isArgumentDelimiter does not recognise
semi-colon as delimiter
https://issues.apache.org/bugzilla/show_bug.cgi?id=45909
Josh Micich <jo...@gildedtree.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |WONTFIX
--- Comment #1 from Josh Micich <jo...@gildedtree.com> 2008-09-29 14:25:55 PST ---
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.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org