https://bugs.documentfoundation.org/show_bug.cgi?id=153300
Bug ID: 153300
Summary: Format->Text menu name is confusing in Calc
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: needsUXEval, topicUI
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
In Calc, there is an important concept of cells' number format, which
determines both content formatting, and recognition (conversion) of newly
entered text. It is available through Format->Cells (Ctrl+1), "Numbers" tab
[1]. The number formats are divided into categories, e.g. Number, Date, Text.
The latter category, when applied to a cell, makes all following entry into the
respective cell to be not converted to numbers and formulas, which is important
for many use cases.
There is rather established, common across many spreadsheet applications, idiom
like "format cells as text". It means precisely the application of a number
format from the respective category.
In Calc, since 5.1, there is Format->Text menu [2]. It lists assorted items,
some of which apply character formatting, others may edit the cell text itself
(tdf#152197). These elements are not connected to the number formats discussed
above.
The name of the Format->Text menu creates a confusion in users [3]. People who
get an advice to format cells as text, may try the Format->Text subentries.
The proposal is to rename the Text menu name (which is common across different
modules, i.e. Writer, Draw, ...) to something else - like maybe "Text Effects",
or "String", or whatever (I realize that my wording is awful - I hope it just
gives an idea).
[1]
https://help.libreoffice.org/7.5/en-US/text/shared/01/05020300.html?DbPAR=CALC
[2]
https://help.libreoffice.org/7.5/en-US/text/shared/submenu_text.html?&DbPAR=CALC
[3] https://ask.libreoffice.org/t/keeping-zeros-infront-of-a-number/83306/3
--
You are receiving this mail because:
You are the assignee for the bug.
