Rick C. Hodgin rick.c.hodgin at
Fri Jan 8 16:52:49 PST 2016

I am a developer and would be willing to make these changes for the
project, but I've never worked on the LibreOffice code base and would need
some help getting started with the correct source files.

I had an idea to allow for a new type of cell formatting under *"Category."*
It would be for numbers, and operate similarly to the standard numbers on
integer values, but for fractions it would perform some special processing.

The category is called *"Metric."*

When conveying fractional values, such that 1.2345E-08 (which is
0.000,000,012,345), it would do so in a metric-relative way using the
standard milli (10^-3), micro (10^-6), nano (10^-9), pico (10^-12), and so

In the example, the *Metric* display would cause the value to show up
as "*12,345
pu*" (pico-units) if the thousands separator was used.  There would be an
option to override the default "u" character in use, changing it into
something that may have significance for the cell, such as "s" or "seconds"
for seconds, "m" or "meters" for meters, and so on.

An ability to lock in a working range would also exist, such as *"show
everything in nano-units"* so that everything is adjusted to that base.  In
such a case, the above example above would present as "*12.345 nu*" instead
of in its default *pu*.

Thank you in advance.

Best regards,
Rick C. Hodgin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <>

More information about the LibreOffice mailing list