Issue 53587 - Implement SI-prefix number formatting (System International)
Summary: Implement SI-prefix number formatting (System International)
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.0 Beta
Hardware: All All
: P3 Trivial with 5 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2005-08-22 00:04 UTC by madbop
Modified: 2013-08-07 15:12 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

Macro to convert to Eng / Si notation (revision 3) with Binary notation (20.94 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-09-15 13:38 UTC, irneb
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description madbop 2005-08-22 00:04:52 UTC
Beside the scientific format of numbers with powers, there is a well established
and standardized numbering system missing.
For binary data the binary prefixes should be an option

Examples: 1000 -> 1k, 1024 -> 1ki
Comment 1 frank 2005-09-15 13:12:40 UTC
one for the requirements team
Comment 2 irneb 2009-09-15 13:34:37 UTC
Is this not a double to Issue 48026? At least for the first part? Anyhow, I've
implemented a conversion formula for this as well ... see the attached.
Comment 3 irneb 2009-09-15 13:38:03 UTC
Created attachment 64770 [details]
Macro to convert to Eng / Si notation (revision 3) with Binary notation
Comment 4 irneb 2009-09-15 16:19:27 UTC
This may definitely be duplicate to Issue 24373, however this should also not be
closed due to the Binary prefixes. Maybe simply change the summary to reflect?
Comment 5 irneb 2010-07-06 15:47:24 UTC
Please see this wiki page:

There's some questions to be answered before it can be implemented fully /