Issue 53587

Summary:

Implement SI-prefix number formatting (System International)

Product:

Calc

Reporter:

madbop <bp>

Component:

formatting

Assignee:

AOO issues mailing list <issues>

Status:

CONFIRMED ---

QA Contact:

Severity:

Trivial

Priority:

CC:

irne.barnard, issues, ooo

Version:

OOo 2.0 Beta

Target Milestone:

---

Hardware:

All

OS:

All

Issue Type:

ENHANCEMENT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
Macro to convert to Eng / Si notation (revision 3) with Binary notation	none

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.