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

            Bug ID: 58532
           Summary: Support for 4 part data formats, eg used for #/K/M
                    formats
           Product: POI
           Version: 3.13-dev
          Hardware: PC
                OS: Linux
            Status: NEW
          Severity: enhancement
          Priority: P2
         Component: SS Common
          Assignee: [email protected]
          Reporter: [email protected]

Created attachment 33206
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=33206&action=edit
Example spreadsheet showing the formats and their effects

One of our business users has tried using formats such as these in a
spreadsheet:

[>999999]#,,"M";[>999]#,"K";#
[>999999]#.000,,"M";[>999]#.000,"K";#.000

The former turns a value like 1021021.02 into 1M, the latter into 1.021M

When using DataFormatter, these patterns aren't recognised, and no formatting
is currently done. We should add support for these

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