Markus Mohrhard markus.mohrhard at
Mon Jan 11 09:00:08 PST 2016

Hey Rick,

On Sat, Jan 9, 2016 at 1:52 AM, Rick C. Hodgin <rick.c.hodgin at>

> 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
> on...
> 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*.

All in all this sounds a bit like the idea behind the unit verification
that has been planned and partly been implemented in a feature branch. It
might be a good idea to have a look at that before implementing it
completely in the number formatter.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <>

More information about the LibreOffice mailing list