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
Adding libreoffice-ux-advise@lists.freedesktop.org to CC to make sure it reaches them. Should it use the term "Font", as that's what's used in the Format > Character tabs "Font" and "Font effects", where all the corresponding commands are?
(In reply to Stéphane Guillou (stragu) from comment #1) > Should it use the term "Font", as that's what's used in the Format > > Character tabs "Font" and "Font effects", where all the corresponding > commands are? Note that not everything there is from "Font" (as noted in bug 152197). Another option: "Characters"?
Created attachment 185044 [details] Screenshot Screenshot for the lazy people. Although renaming Text to Character sounds good, the label aligns currently with Writer and Draw/Impress. And actually I wonder how changing the font weight to italic, for example, could be mistaken as formatting as text. In other words: does the (little) improvement of understanding the functionality outbalance the drawback of diverging labels?
(In reply to Heiko Tietze from comment #3) IMO, if this would be renamed, it should be renamed synchronously everywhere.
We discussed the topic in the design meeting. "Character" is used in Writer for the Character Style so out of the options. "Font Effect" is not correct as it excludes the font weight. "Text Formatting" could be an alternative but is not an improvement. We concluded that "Font" is okay and has no better replacement. Users need to learn the difference of number formatting and text formatting.