https://issues.apache.org/bugzilla/show_bug.cgi?id=49457
Josh Micich <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |DUPLICATE --- Comment #1 from Josh Micich <[email protected]> 2010-06-17 13:50:53 EDT --- Excel encodes formulas into a representation independent of the characters visible in the human readable formula. In some regions, Excel displays (and parses) commas for argument delimiters, and in others, semicolons. POI currently does not support internationalisation for formula rendering/parsing, and effectively uses a default region of 'United States'. The work around is simple - use comma instead of semicolon (as you mentioned already). Unfortunately, there will be small differences between the way POI and Excel render/parse formulas in your region. Contributions are always welcome. To fix this will involve changes to the FormulaParser class. You'd need to deal with more than just the argument delimiter: the decimal separator, and array element delimiter are probably also region specific. I am not sure what other elements of Excel formulas are region specific. *** This bug has been marked as a duplicate of bug 45909 *** -- 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: [email protected] For additional commands, e-mail: [email protected]
