poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 62073] New: FormulaParser does not work internationally
Date Fri, 02 Feb 2018 12:36:59 GMT

            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: dev@poi.apache.org
          Reporter: drjovanovic@gmail.com
  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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message