https://bz.apache.org/bugzilla/show_bug.cgi?id=63841

Dominik Stadler <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All
             Status|NEW                         |RESOLVED
         Resolution|---                         |INVALID

--- Comment #1 from Dominik Stadler <[email protected]> ---
This is "by design". Microsoft Excel uses the US-format for specifying the
formatting to avoid problems with writing in one format and reading in another.
Whenever the format is applied, it is adjusted according to the current locale
in either Excel itself or Apache POI if this is used for rendering the format.

So in the file-format, you specify "#.##" and if you configure the "locale" of
your JavaVM, it should produce the expected European format if put "#.##" in
the file as format.

See https://poi.apache.org/apidocs/dev/org/apache/poi/ss/format/CellFormat.html
and https://poi.apache.org/components/spreadsheet/quick-guide.html#CellContents
for some usage information.

-- 
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]

Reply via email to