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.
enhancement request. status NEW.
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
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.