Bug 72038

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