From 3f82ba1d59d3bf4aa5e347f8dfb76f79ffd68bb0 Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Thu, 8 Mar 2018 19:29:12 -0300 Subject: tdf#72038 Improve number format recognition help Change-Id: I403d2021114f432d85dd2915ca8722c04acb50a3 Reviewed-on: https://gerrit.libreoffice.org/50976 Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot --- source/text/shared/optionen/01040500.xhp | 16 ++++++++++++++-- 1 file changed, 14 insertions(+), 2 deletions(-) diff --git a/source/text/shared/optionen/01040500.xhp b/source/text/shared/optionen/01040500.xhp index 13cf3cbaa2..dd8fef48b6 100644 --- a/source/text/shared/optionen/01040500.xhp +++ b/source/text/shared/optionen/01040500.xhp @@ -18,7 +18,7 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - + @@ -74,13 +74,25 @@ Number recognition -Specifies that numbers in a text table are recognized and formatted as numbers. + +Specifies that numbers in a text table are recognized and formatted as numbers. Table cells in %PRODUCTNAME Writer can recognize a number when it is represented in one of the number formats available in categories of Numbers, Percent, Currency, Date, Time, Scientific, Fraction and Boolean. + +The recognized number is displayed with default number format for table cells, and sets the cell format to the recognized category. For example, if a number is recongized as Date, the cell format category is set to Date. You can set a specific number format for the cell, for example, a date entered as 8/3/2018 displays as Thursday March 8, 2018 when the cell number format is set to "Friday, December 31, 1999" in the Number Format dialog. + +Recognized Date and Time numbers are converted to internal date and time serial values. Percent numbers are converted internally to their numeric values. Boolean values are converted internally to 0 or 1. + +When an input cannot be recognized as a number, the number category changes to Text and the input is not changed. + If Number recognition is not marked, numbers are saved in text format and are automatically left-aligned.
Number format recognition If Number format recognition is not marked, only input in the format that has been set at the cell is accepted. Any other input resets the format to Text. + +For example, if a cell contains a date value and has its cell format as date, a new input of a percent value in the cell set the cell format to Text and the percent input number is not recognized. + +When Number format recognition is marked, input numbers sets the cell format to the recognized number category.
-- cgit v1.2.3