https://bz.apache.org/bugzilla/show_bug.cgi?id=61874
Bug ID: 61874
Summary: OperandResolver.parseDouble(String) does not does not
work for numeric Strings using a comma as decimal
separator.
Product: POI
Version: 3.17-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: dev@poi.apache.org
Reporter: carl.sala...@gmail.com
Target Milestone: ---
OperandResolver::parseDouble does not take into account the locale and instead
always uses a decimal dot.
In Excel for example, this formula =TEXT("1234,68"; "#.##0,00") shows the value
"1.234,68" while POI returns "#VALUE!" because it cannot evaluate it.
Internally, the (POI) TEXT function uses OperandResolver::parseDouble which can
only convert numeric String using a dot as the decimal separator.
Excel itself takes into account the locale, so it knows that my numbers use a
decimal comma instead.
This inconsistent behaviour between Excel and POI is confusing and difficult.
Can POI also take into account the locale when parsing numeric String values to
Double values?
https://stackoverflow.com/questions/47712773/how-to-get-poi-to-evaluate-and-format-a-cell-exactly-as-excel-does
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
