Download it now!
Bug 120247 - Help users to avoid deprecated units in CONVERT function, especially not to use "at"
Summary: Help users to avoid deprecated units in CONVERT function, especially not to u...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Help-Changes-Features
  Show dependency treegraph
Reported: 2018-10-01 18:05 UTC by Regina Henschel
Modified: 2019-02-22 10:47 UTC (History)
2 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 Regina Henschel 2018-10-01 18:05:55 UTC
The function CONVERT has a lot of units, which are deprecated in ODF 1.2. LibreOffice should better not allow these units in new documents and at least warn users in the help, that these units are deprecated.

A special warning is needed in case of the deprecated unit "at", because "at" is treated as "atm" although it is a different unit, see bug 72174.

So my suggestion for immediate improvement:
Change the help. For example remove such units from the regular list and add the information, that these units should not be uses although LibreOffice can handle them. Add a dedicated warning for unit "at".

In the long term LibreOffice should get a feature to show warning indicators at cells. But that is a different issue.
Comment 1 Julien Nabet 2018-10-02 08:13:49 UTC
Just personal thought: it's a real shame (I'd say insulting for those who work on the concerned domain) that not only Excel but also OASIS was wrong about "at". Oasis should should check units on real sources, not compare with what Excel does.
Now this symbol is lost forever (see
Hope there won't be others.