First time here? Check out the FAQ!
I want to keep the values in the cells in plain metric units such that all formulas are the basic relations as would be found in a textbook, with no unnecessary, confusing, and mistake-prone constants in the formulas.
However, I want to display the values scaled to an easier to read order of magitude.
For division by powers of 1000, I can use commas, so I can use the format codes:
0.###,,,"G" 0.###,,"M" 0.###,"k" 0.###
Or I could even construct something more generic like this:
(There seems to be a bug that prevents me from using more than 3 conditions, so for now
G is omitted.)
But for m, μ, n, etc., I cannot find a way.
I found this clever looking hack but the percents don't seem to work properly:
answered 2013-03-01 05:42:43 +0200qubit
Hi @James Haigh,
Did you ever find a solution to your formatting question?
If you think that changes to the LibreOffice code could help you implement your desired formatting, please file an enhancement bug and provide as much information about this new feature as possible. Don't forget to mark your bug as an 'enhancement'. The QA team will be happy to help you triage your feature request in the bugtracker.
Please post a link to any bugs you file in a comment below using the format "fdo#123456".
answered 2012-11-09 02:12:03 +0200ROSt52
0.### format on a 1 shows correctly the result 1. Reason ### displays a maximum of 3 digits after the decimal point. Try to enter 1, 1.1, 1.11, 1.111, 1.11111 and you will see.
It is important to understand the 0 and #. I would neglect this first and work only with a 0. Your major problem is to adjust the display of a value smaller than 1 as as figure larger then 1 and not having the % visible.
I did a row of tests and found that - Calc does not accept the <crt j> or <crtlj> as a format. I don't know why. - "k" is not need just k is enough - comma and % work in the way as indicated in the link you provided when you raised your question
Problem I could not solve was the % shows up. Possible solution - ask a new question on how the % sign can be made disappearing in Calc or if there is another multiplier by 100 which does not show up like the comma for a division by 1000 - read through all the additional links given in the link you provided at the beginning
If you would like to have my test sheet, let me know.
Please understand that I cannot do more testing and searching for you. I feel I brought you on the track, good luck.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-10-30 00:07:07 +0200
Seen: 195 times
Last updated: Mar 14