Bug 86700 - Add more Number Formats
Summary: Add more Number Formats
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
(earliest affected) release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Keywords: needsUXEval
Depends on:
Blocks: Number-Format
  Show dependency treegraph
Reported: 2014-11-25 12:33 UTC by Frank Berke
Modified: 2020-09-21 07:48 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Frank Berke 2014-11-25 12:33:29 UTC
Please extend the default number formats to reflect common measurements like centi/kilo-meter, square meter, cubic meter, pieces (pcs), volume in (hecto-)liters, weight in kilograms/tons and so on.

- Or -

Please make that user-defined number formats are not stored per document but for LO in general.
Comment 1 tommy27 2014-12-13 17:53:56 UTC
enhancement request. status NEW.
Comment 2 BogdanB 2020-09-20 19:39:16 UTC
OR... we can start from a number format we choose (how many decimals, and so on) and after that expresion we could just add "Kilometres" in the Format code field.

So easy to do, so I can have cats, dogs and so on... Whatever I want I can have in my cell.


For example:
if I like the format 

in the Format code field I have this:

It need just to add "cats", meaning to have this
#.##0,00 "cats"

So if I insert 3, I will have:
3,00 cats
Comment 3 Heiko Tietze 2020-09-21 07:48:29 UTC
Bogdan is right with the user-defined solution. Online help is here

The format is defined and limited because of backward and cross-plattform/-application compatibility.

Keep also in mind that we have the imperial vs. metric system.