https://bz.apache.org/bugzilla/show_bug.cgi?id=62073
Bug ID: 62073
Summary: FormulaParser does not work internationally
Product: POI
Version: unspecified
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Imagine following scenario :
User of my spreadsheet-editing app enters a formula =6,6*A1 under his/her (for
example) German culture. User obviously wants to multiply A1 value by 6.6 . But
, inside FormulaParser comma sign has a fixed meaning described as
* <function> ::= <functionName> ([expression [, expression]*])
, so it can not recognise the string 6,6 as number.
Did I miss something ? Is there a way to get over this problem using
FormulaParser ? Or should I somehow pre-process this string before I pass it to
FormulaParser ? If so, I also need to know what is general purpose of comma
sign in those formulae.
I may also try to alter FormulaParser class in a way that - for some locales -
it interprets comma as decimal separator, and uses some other character (; for
example) for expression separator.
--
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]
