Issue 48026 - Improve Scientific Number Format
Summary: Improve Scientific Number Format
Status: CLOSED DUPLICATE of issue 5930
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.0 Beta
Hardware: PC Windows XP
: P4 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2005-04-23 20:50 UTC by sulimma
Modified: 2009-09-15 16:08 UTC (History)
1 user (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description sulimma 2005-04-23 20:50:37 UTC
The scientific number format representation lacks functionality.
Currently there is always a fixed number of digits displayed in front of the
decimal point. This means that 34,5 and 345 show up either as 3,45e1 and 3,45e2
or as 34,5e0 and 34,5e1 respectively.

It should be possible to limit the exponents to values devisible by three as it
is comon in engineering. This means there should be a number format were the
values show up as 34,5e0 and 345,0e0 while 3450 and 34500 show up as 3,4e3 and

It also would be really nice to be able to display ISO/SI/ANSI suffixes for the
exponents. E.g. k for e3, M for e6, m for e-3 and so on. The last two examples
would show as 3,40k and 34,5k (or optionally as 3k4 and 34k5)
Comment 1 frank 2005-04-25 10:31:49 UTC
double to Issue 5930

*** This issue has been marked as a duplicate of 5930 ***
Comment 2 frank 2005-04-25 10:32:09 UTC
closed double
Comment 3 irneb 2009-09-15 13:37:15 UTC
A similar (if not entirely duplicate) of this seems to be Issue 5357. Where that
differs from this issue is the 2nd request for Binary notation. See that issue
for the additional Conversion function to Binary notation (e.g. 1024 becomes 1.0Ki)
Comment 4 irneb 2009-09-15 16:06:04 UTC
Sorry, mistype. It should read Issue 53587 ... and no I don't agree that this is
a duplicate of Issue 5930. SI and Engineering formats are not the same thing.

This issue needs to be re-opened & renamed so the Engineering portion is
removed. That is duplicate to 5930.
Comment 5 irneb 2009-09-15 16:08:17 UTC
This may possibly be a duplicate of Issue 23373 (which is also marked as
duplicate of 5930).