Bug 86700 - Add more Number Formats
Summary: Add more Number Formats
Status: RESOLVED WONTFIX
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
4.3.4.1 release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
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:


Attachments

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 
-1.234,57

in the Format code field I have this:
#.##0,00

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
https://help.libreoffice.org/latest/en-US/text/shared/01/05020301.html?DbPAR=SHARED#bm_id3153514

The format is defined and limited because of backward and cross-plattform/-application compatibility.
https://api.libreoffice.org/docs/idl/ref/namespacecom_1_1sun_1_1star_1_1i18n_1_1NumberFormatIndex.html
https://support.microsoft.com/en-us/office/available-number-formats-in-excel-0afe8f52-97db-41f1-b972-4b46e9f1e8d2

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