Scaling of values on axis
Submitted by Morten Welinder
Link to original bug (#748295)
Description
Created attachment 302145 xlsx Sample
XL has the ability to scale numbers shown on axes.
For example, if the data has units of micrograms then XL can show 50 for 50ug instead of 5e-5.
Their gui is clunky: you can either pick from a predefined list containing only positive powers of ten, or you can enter a unit. The ability to enter a value is not at all obvious.
LO does not appear to have this abilty.
I don't think we can currently do this, but I think we should. We can currently fake it for certain units:
- For 10^(3n) we can use
n
comma scaling operators in the format. - For 10^(-2) we can use percent in format, but "%" will be visible.
Attachment 302145, "xlsx Sample":
yunits.xlsx
Version: GIT