[Libreoffice-bugs] [Bug 114107] New: Feature Request: Engineering Notation in LibreOffice Calc under Format Cells

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=114107

            Bug ID: 114107
           Summary: Feature Request: Engineering Notation in LibreOffice
                    Calc under Format Cells
           Product: LibreOffice
           Version: 3.3.0 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: playinmyblues at hotmail.com

Description:
A very useful formatting option in LibreOffice Calc would be to provide
engineering notation in addition to the scientific notation already provided.

There is a current similar bug: 77951

Engineering notation is commonly found in use in many fields of science to
allow for easy and standardized understanding of units and magnitudes of
numbers. It also allows for easy conversion between magnitudes of units.

One very common example is the conversion of units of capacitance in
electronics. One of the most commonly used units of capacitance is the
micro-Farad, often seen in typed documents as uF. When used on capacitors of
small physical size, numbers are often written as 106. This is a 1 followed by
a 0 and followed by 6 additional zeroes to make 10,000,000 pF (pico-Farads).

This is only one example of a conversion used very frequently but is found in
multitudes of instances every day. Engineering notation makes scientific
notation easier to understand, much like metric, using its natural system of
magnitudes of 10's, in both whole numbers and real numbers, easier to use.

In short, time saved on converting in the mind by simply seeing what is in a
spreadsheet would make things much faster and more useful.

Actual Results:  
Currently using scientific notation or grouping in 1,000's.

Expected Results:
Currently using scientific notation or grouping in 1,000's.


Reproducible: Always


User Profile Reset: No



Additional Info:
Software should provide engineering notation.


User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:57.0) Gecko/20100101
Firefox/57.0

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171128/01419054/attachment.html>