https://bugs.freedesktop.org/show_bug.cgi?id=72038
Priority: medium
Bug ID: 72038
Assignee: [email protected]
Summary: LOCALHELP: Unclear Help Text of Options “Number
recognition” and “Number format recognition”
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.3.2 release
Component: Documentation
Product: LibreOffice
Problem description:
The Help Text of the Writer options (Menu: Table > Number Format...) “Number
recognition” and “Number format recognition” is not very specific and irritated
me. Hence I propose to replace the existing text with:
< Beginning of description >
_Number recognition_
Determines that the number recognition in tables is active. A number category
is assigned to each cell. Generally the number recognition only works in cells
with number categories Percent, Currency, Date, Time, Scientific, Fraction and
Boolean Value. The number recognition works as follows:
(1) A number is always recognized, if the input is recognized as a valid number
value with a unit according to the number category of the cell. The cell is
formatted according the format assigned in the Number Format dialog.
Examples: An input of “12 %” in a cell with category Percent changes to
“12.00%” or an input “10/05/20” in category Date changes to “2010-05-20”.
(2) Furthermore a number is always recognized, if the input is a valid number
value without a unit. The cell is formatted according the category and the
format assigned in the Number Format dialog. (Hint: Value is converted, if
category is Date or Time.)
Examples: An input of “12.345” in a cell with category Percent changes to
“12.35%”, an input of “1234.56” in category Currency changes to “$1,234.56” or
an input “23456.78” in category Date or Time changes to “03/20/1964 18:43:12”.
(3) If the option “Number format recognition” is marked, an inputted number
with a unit is also recognized even the unit is different to the number format
of the cell. The unit has to be in accordance with a unit of one of the
categories. The category changes according to the inputted unit. The cell is
formatted with a default format of the according category.
Example: An Input of “12.345%” in a cell with the category Currency changes to
category Percent and “12.35%” is displayed.
(4) With all other inputs the number category changes to “Text” and the
inputted text is not changed.
If “Number recognition” is not active, all inputted numbers are always saved in
text format.
< End of description >
I made this proposal already in bug 48758. Hence in that bug several problems
are described, I split those problems into different bug reports. This report
is one of them.
Operating System: Windows 7
Version: 4.1.3.2 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
