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: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL: http://docs.oasis-open.org/office/v1....
Whiteboard: target:7.4.0
Keywords:
Depends on:
Blocks: Help-Changes-Features
  Show dependency treegraph
 
Reported: 2018-10-01 18:05 UTC by Regina Henschel
Modified: 2022-01-07 13:12 UTC (History)
1 user (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 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 https://bugs.documentfoundation.org/show_bug.cgi?id=72174#c26).
Hope there won't be others.
Comment 2 Olivier Hallot 2022-01-04 14:34:10 UTC
Fast forward, the Help has been updated independent of this report (bug#141929)

The current help page 
https://help.libreoffice.org/7.4/en-US/text/scalc/01/func_convert.html?DbPAR=CALC#bm_id3148446

is compliant with ODFF1.3 except for the following units

Pennyweight
Glass
Humpen
Middy
Schooner
Sixpack
Comment 3 Regina Henschel 2022-01-04 16:12:17 UTC
The updated help pages still miss information, which units are deprecated and should not be used.
And there is still no comment why unit "at" should not be used.
Comment 4 Commit Notification 2022-01-06 13:45:35 UTC
Olivier Hallot committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/help/commit/4ce4649ea3b21406c4e95e81930097968cb95cf6

tdf#120247 Update CONVERT() Calc funct  wrt ODFF1.3