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