Ask Your Question
1

Does LibreOffice support Engineering (a.k.a. Technical) notation?

asked 2014-09-16 21:45:50 +0200

com2 gravatar image

updated 2014-09-23 15:22:33 +0200

oweng gravatar image

In my old Hewlett Packard C 25 pocket calculator I had the choice between three notations (formats). Beside Fixed comma and Scientific you had also Technical notation. Technical is different type of Scientific notation. With Scientific notation you would display 100 000 as 1.10⁵ while Technical notation would display it as 100.10³ to help you to see the kilo or mega, giga or milli, micro and pico values easier. It would use only 3, 6, 9 and 12 exponents.

59 200 000 is displayed as 59,2 . 10⁶

5 920 000 is displayed as 5,92 . 10⁶

592 000 is displayed as 592 . 10³

It also allowed you to choose the number of digits after the comma, zero would be like in the previous examples. With one digit would be:

59 200 000 is displayed as 59,20 . 10⁶

5 920 000 is displayed as 5,920 . 10⁶

592 000 is displayed as 592,0 . 10³

Since we live in a technical world why was this never implemented in spreadsheet world? My feature request is to both include this old HP like technical notation but also extend it to optionally display the exponent as letter k,M,G, m, μ, p

Please note that I use the European comma, not the US dot notation

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2014-09-16 23:53:48 +0200

m.a.riosv gravatar image
edit flag offensive delete link more

Comments

Related enhancement is fdo#30716.

oweng gravatar imageoweng ( 2014-09-17 04:50:03 +0200 )edit

Is there a way to display it as k, M, etc instead of E+3?

endolith gravatar imageendolith ( 2016-05-12 18:50:57 +0200 )edit
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2014-09-16 21:45:50 +0200

Seen: 1,403 times

Last updated: Sep 23 '14