Issue 53587 - Implement SI-prefix number formatting (System International)
Summary: Implement SI-prefix number formatting (System International)
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-08-22 00:04 UTC by madbop
Modified: 2013-08-07 15:12 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
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
Add an attachment (proposed patch, testcase, etc.)

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.
http://en.wikipedia.org/wiki/SI#SI_prefixes
For binary data the binary prefixes should be an option
http://en.wikipedia.org/wiki/Binary_prefix#IEC_standard_prefixes

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:
http://wiki.services.openoffice.org/wiki/Engineering_and_SI_Number_Format_in_Calc

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