From 7dae48c4a4c4deac188cba54357fd4d1698ae966 Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Wed, 24 May 2017 00:01:54 -0300 Subject: Mute l10n for dozens of numbers and format codes Muted numbers and codes are not to be translated Change-Id: I4714318c6108a2735825d7ff7832d2b3733df7f7 Reviewed-on: https://gerrit.libreoffice.org/37974 Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot --- source/text/shared/01/05020301.xhp | 408 ++++++++++++++++++------------------- 1 file changed, 204 insertions(+), 204 deletions(-) diff --git a/source/text/shared/01/05020301.xhp b/source/text/shared/01/05020301.xhp index d2db2494a2..1a948ccc9a 100644 --- a/source/text/shared/01/05020301.xhp +++ b/source/text/shared/01/05020301.xhp @@ -80,7 +80,7 @@ - # + # Does not display extra zeros. @@ -88,7 +88,7 @@ - ? + ? Displays space characters instead of extra zeros. @@ -121,7 +121,7 @@ 3456.78 as 3456.8 - ####.# + ####.# @@ -129,7 +129,7 @@ 9.9 as 9.900 - #.000 + #.000 @@ -137,7 +137,7 @@ 13 as 13.0 and 1234.567 as 1234.57 - #.0# + #.0# @@ -145,7 +145,7 @@ 5.75 as 5 3/4 and 6.3 as 6 3/10 - # ???/??? + # ???/??? @@ -153,7 +153,7 @@ .5 as 0.5 - 0.## + 0.## @@ -161,7 +161,7 @@ .5 as 0.5   (with two extra spaces at the end) - 0.??? + 0.??? @@ -184,7 +184,7 @@ 15000 as 15,000 - #,### + #,### @@ -192,7 +192,7 @@ 16000 as 16 - #, + #, @@ -209,9 +209,9 @@ Spaces To use a character to define the width of a space in a number format, type an underscore ( _ ) followed by the character. The width of the space varies according to the width of the character that you choose. For example, _M creates a wider space than _i. To fill free space with a given character, use an asterisk (*) followed by this character. For instance: -*\0 +*\0 will display integer value (0) preceded by as many as needed backslash characters (\) to fill column width. For accounting representation, you may left align currency symbol with a format similar to: -$_-* 0.--;$-* 0.--;$_-* - +$_-* 0.--;$-* 0.--;$_-* - Color To set the color of a section of a number format code, insert one of the following color names in square brackets [ ]: @@ -219,34 +219,34 @@ - CYAN + CYAN - GREEN + GREEN - BLACK + BLACK - BLUE + BLUE - MAGENTA + MAGENTA - RED + RED - WHITE + WHITE - YELLOW + YELLOW
@@ -258,7 +258,7 @@ You can define a number format so that it only applies when the condition that you specify is met. Conditions are enclosed by square brackets [ ]. You can use any combination of numbers and the <, <=, >, >=, = and <> operators. For example, if you want to apply different colors to different temperature data, enter: -[BLUE][<0]#.0 "°C";[RED][>30]#.0 "°C";[BLACK]#.0 "°C" +[BLUE][<0]#.0 "°C";[RED][>30]#.0 "°C";[BLACK]#.0 "°C" All temperatures below zero are blue, temperatures between 0 and 30 °C are black, and temperatures higher than 30 °C are red. Positive and Negative Numbers @@ -271,14 +271,14 @@ To display numbers as percentages, add the percent sign (%) to the number format. Scientific Notation -Scientific notation lets you write very large numbers or very small fractions in a compact form. For example, in scientific notation, 650000 is written as 6.5 x 105, and 0.000065 as 6.5 x 10-5. Translators: use the decimal delimiter of your language (period or comma) for all number format codes in Calc.In %PRODUCTNAME, these numbers are written as 6.5E+5 and 6.5E-5, respectively. To create a number format that displays numbers using scientific notation, enter a # or 0, and then one of the following codes E-, E+, e- or e+. If sign is omitted after E or e, it won't appear for positive value of exponent. To get engineering notation, enter 3 digits (0 or #) in the integer part: ###.##E+00 for instance. +Scientific notation lets you write very large numbers or very small fractions in a compact form. For example, in scientific notation, 650000 is written as 6.5 x 105, and 0.000065 as 6.5 x 10-5. Translators: use the decimal delimiter of your language (period or comma) for all number format codes in Calc.In %PRODUCTNAME, these numbers are written as 6.5E+5 and 6.5E-5, respectively. To create a number format that displays numbers using scientific notation, enter a # or 0, and then one of the following codes E-, E+, e- or e+. If sign is omitted after E or e, it won't appear for positive value of exponent. To get engineering notation, enter 3 digits (0 or #) in the integer part: ###.##E+00 for instance. Fraction Representation To represent a value as a fraction, format consists of two or three parts: integer optional part, numerator and denominator. Integer and numerator are separated by a blank or any quoted text. Numerator and denominator are separated by a slash character. Each part can consist of a combination of #, ? and 0 as placeholders. Denominator is calculated to get the nearest value of the fraction with respect to the number of placeholders. For example, PI value is represented as 3 16/113 with format: -# ?/??? +# ?/??? Denominator value can also be forced to the value replacing placeholders. For example, to get PI value as a multiple of 1/16th (i.e. 50/16), use format: -?/16 +?/16 Number Format Codes of Currency Formats The default currency format for the cells in your spreadsheet is determined by the regional setting of your operating system. If you want, you can apply a custom currency symbol to a cell. For example, enter #,##0.00 € to display 4.50 € (Euros).Translators: use the decimal delimiter of your language (period or comma) for all number format codes in Calc. @@ -305,7 +305,7 @@ Month as 3. - M + M @@ -313,7 +313,7 @@ Month as 03. - MM + MM @@ -321,7 +321,7 @@ Month as Jan-Dec - MMM + MMM @@ -329,7 +329,7 @@ Month as January-December - MMMM + MMMM @@ -337,7 +337,7 @@ First letter of Name of Month - MMMMM + MMMMM @@ -345,7 +345,7 @@ Day as 2 - D + D @@ -353,7 +353,7 @@ Day as 02 - DD + DD @@ -361,7 +361,7 @@ Day as Sun-Sat - NN or DDD + NN or DDD @@ -369,7 +369,7 @@ Day as Sunday to Saturday - NNN or DDDD + NNN or DDDD @@ -377,7 +377,7 @@ Day followed by comma, as in "Sunday," - NNNN + NNNN @@ -385,7 +385,7 @@ Year as 00-99 - YY + YY @@ -393,7 +393,7 @@ Year as 1900-2078 - YYYY + YYYY @@ -401,7 +401,7 @@ Calendar week - WW + WW @@ -409,7 +409,7 @@ Quarterly as Q1 to Q4 - Q + Q @@ -417,7 +417,7 @@ Quarterly as 1st quarter to 4th quarter - QQ + QQ @@ -425,7 +425,7 @@ Era on the Japanese Gengou calendar, single character (possible values are: M, T, S, H) - G + G @@ -433,7 +433,7 @@ Era, abbreviation - GG + GG @@ -441,7 +441,7 @@ Era, full name - GGG + GGG @@ -449,7 +449,7 @@ Number of the year within an era, without a leading zero for single-digit years - E + E @@ -470,7 +470,7 @@ -The above listed formatting codes work with your language version of %PRODUCTNAME. However, when you need to switch the locale of %PRODUCTNAME to another locale, you will need to know the formatting codes used in that other locale. +The above listed formatting codes work with your language version of %PRODUCTNAME. However, when you need to switch the locale of %PRODUCTNAME to another locale, you need to know the formatting codes used in that other locale. For example, if your software is set to an English locale, and you want to format a year with four digits, you enter YYYY as a formatting code. When you switch to a German locale, you must use JJJJ instead. The following table lists only the localized differences. @@ -499,26 +499,26 @@ - English - en + English - en and all not listed locales - Y + Y - M + M - D + D - H + H - N + N - G + G @@ -526,12 +526,12 @@ German - de - J + J - T + T @@ -545,14 +545,14 @@ Netherlands - nl - J + J - U + U @@ -564,17 +564,17 @@ French - fr - A + A - J + J - O + O @@ -584,20 +584,20 @@ Italian - it - A + A - G + G - O + O - X + X @@ -605,7 +605,7 @@ Portuguese - pt - A + A @@ -614,7 +614,7 @@ - O + O @@ -624,7 +624,7 @@ Spanish - es - A + A @@ -633,7 +633,7 @@ - O + O @@ -649,7 +649,7 @@ - T + T @@ -667,7 +667,7 @@ - T + T @@ -685,7 +685,7 @@ - T + T @@ -697,16 +697,16 @@ Finnish - fi - V + V - K + K - P + P - T + T @@ -734,7 +734,7 @@ - [~buddhist] + [~buddhist] Thai Buddhist Calendar @@ -742,7 +742,7 @@ - [~gengou] + [~gengou] Japanese Gengou Calendar @@ -750,7 +750,7 @@ - [~gregorian] + [~gregorian] Gregorian Calendar @@ -766,7 +766,7 @@ - [~hijri] + [~hijri] Arabic Islamic Calendar @@ -774,7 +774,7 @@ - [~jewish] + [~jewish] Jewish Calendar @@ -782,7 +782,7 @@ - [~ROC] + [~ROC] Republic Of China Calendar @@ -914,7 +914,7 @@ Hours as 0-23 - H + H @@ -922,7 +922,7 @@ Hours as 00-23 - HH + HH @@ -930,7 +930,7 @@ Hours as 00 up to more than 23 - [HH] + [HH] @@ -938,7 +938,7 @@ Minutes as 0-59 - M + M @@ -946,7 +946,7 @@ Minutes as 00-59 - MM + MM @@ -954,7 +954,7 @@ Minutes as 00 up to more than 59 - [MM] + [MM] @@ -962,7 +962,7 @@ Seconds as 0-59 - S + S @@ -970,7 +970,7 @@ Seconds as 00-59 - SS + SS @@ -978,7 +978,7 @@ Seconds as 00 up to more than 59 - [SS] + [SS]
@@ -992,10 +992,10 @@ NatNum modifiers To display numbers using native number characters, use a [NatNum1], [NatNum2], ... [NatNum11] modifier at the beginning of a number format codes. The [NatNum1] modifier always uses a one to one character mapping to convert numbers to a string that matches the native number format code of the corresponding locale. The other modifiers produce different results if they are used with different locales. A locale can be the language and the territory for which the format code is defined, or a modifier such as [$-yyy] that follows the native number modifier. In this case, yyy is the hexadecimal MS-LCID that is also used in currency format codes. For example, to display a number using Japanese short Kanji characters in an English US locale, use the following number format code: -[NatNum1][$-411]0 +[NatNum1][$-411]0 In the following list, the Microsoft Excel [DBNumX] modifier that corresponds to %PRODUCTNAME [NatNum] modifier is shown. If you want, you can use a [DBNumX] modifier instead of [NatNum] modifier for your locale. Whenever possible, %PRODUCTNAME internally maps [DBNumX] modifiers to [NatNumN] modifiers. Displaying dates using [NatNum] modifiers can have a different effect than displaying other types of numbers. Such effects are indicated by 'CAL: '. For example, 'CAL: 1/4/4' indicates that the year is displayed using the [NatNum1] modifier, while the day and month are displayed using the [NatNum4] modifier. If 'CAL' is not specified, the date formats for that particular modifier are not supported. -[NatNum0] +[NatNum0] Try to convert any native number string to ASCII Arabic digits. If already ASCII, it remains ASCII. [NatNum1] @@ -1392,7 +1392,7 @@ -[NatNum3] +[NatNum3] @@ -1839,7 +1839,7 @@
- NN + NN Numeral @@ -1853,13 +1853,13 @@ - 01 + 01 Arabic - 1234567890 + 1234567890 all @@ -1867,433 +1867,433 @@ - 02 + 02 Eastern Arabic - ١٢٣٤٥٦٧٨٩٠ + ١٢٣٤٥٦٧٨٩٠ - 401 - 1401, 3c01, 0c01, 801, 2c01, 3401, 3001, 1001, 1801, 2001, 4001, 2801, 1c01, 3801, 2401 + 401 + 1401, 3c01, 0c01, 801, 2c01, 3401, 3001, 1001, 1801, 2001, 4001, 2801, 1c01, 3801, 2401 - 03 + 03 Persian - ۱۲۳۴۵۶۷۸۹۰ + ۱۲۳۴۵۶۷۸۹۰ - 429 + 429 - 04 + 04 Devanagari - १२३४५६७८९० + १२३४५६७८९० - 439 - 44E, 461, 861 + 439 + 44E, 461, 861 - 05 + 05 Bengali - ১২৩৪৫৬৭৮৯০ + ১২৩৪৫৬৭৮৯০ - 445 - 845 + 445 + 845 - 06 + 06 Punjabi - ੧੨੩੪੫੬੭੮੯੦ + ੧੨੩੪੫੬੭੮੯੦ - 446 + 446 - 07 + 07 Gujarati - ૧૨૩૪૫૬૭૮૯૦ + ૧૨૩૪૫૬૭૮૯૦ - 447 + 447 - 08 + 08 Oriya - ୧୨୩୪୫୬୭୮୯୦ + ୧୨୩୪୫୬୭୮୯୦ - 448 + 448 - 09 + 09 Tamil - ௧௨௩௪௫௬௭௮௯0 + ௧௨௩௪௫௬௭௮௯0 - 449 - 849 + 449 + 849 - 0A + 0A Telugu - ౧౨౩౪౫౬౭౮౯౦ + ౧౨౩౪౫౬౭౮౯౦ - 44A + 44A - 0B + 0B Kannada - ೧೨೩೪೫೬೭೮೯೦ + ೧೨೩೪೫೬೭೮೯೦ - 44B + 44B - 0C + 0C Malayalam - ൧൨൩൪൫൬൭൮൯൦ + ൧൨൩൪൫൬൭൮൯൦ - 44C + 44C - 0D + 0D Thai - ๑๒๓๔๕๖๗๘๙๐ + ๑๒๓๔๕๖๗๘๙๐ - 41E + 41E - 0E + 0E Lao - ໑໒໓໔໕໖໗໘໙໐ + ໑໒໓໔໕໖໗໘໙໐ - 454 + 454 - 0F + 0F Tibetan - ༡༢༣༤༥༦༧༨༩༠ + ༡༢༣༤༥༦༧༨༩༠ - 851 + 851 - 10 + 10 Burmese - ၁၂၃၄၅၆၇၈၉၀ + ၁၂၃၄၅၆၇၈၉၀ - 455 + 455 - 11 + 11 Tigrina - ፩፪፫፬፭፮፯፰፱0 + ፩፪፫፬፭፮፯፰፱0 - 473 - 873 + 473 + 873 - 12 + 12 Khmer - ១២៣៤៥៦៧៨៩០ + ១២៣៤៥៦៧៨៩០ - 453 + 453 - 13 + 13 Mongolian - ᠑᠒᠓᠔᠕᠖᠗᠘᠙᠐ + ᠑᠒᠓᠔᠕᠖᠗᠘᠙᠐ - C50 - 850 + C50 + 850 - 1B + 1B Japanese - 一二三四五六七八九〇 + 一二三四五六七八九〇 - 411 + 411 - 1C + 1C (financial) - 壱弐参四伍六七八九〇 + 壱弐参四伍六七八九〇 - 1D + 1D (fullwidth Arabic) - １２３４５６７８９０ + １２３４５６７８９０ - 1E + 1E Chinese - simplified - 一二三四五六七八九○ + 一二三四五六七八九○ - 804 - 1004, 7804 + 804 + 1004, 7804 - 1F + 1F (financial) - 壹贰叁肆伍陆柒捌玖零 + 壹贰叁肆伍陆柒捌玖零 - 20 + 20 (fullwidth Arabic) - １２３４５６７８９０ + １２３４５６７８９０ - 21 + 21 Chinese - traditional - 一二三四五六七八九○ + 一二三四五六七八九○ - C04 - 1404 + C04 + 1404 - 22 + 22 (financial) - 壹貳參肆伍陸柒捌玖零 + 壹貳參肆伍陸柒捌玖零 - 23 + 23 (fullwidth Arabic) - １２３４５６７８９０ + １２３４５６７８９０ - 24 + 24 Korean - 一二三四五六七八九０ + 一二三四五六七八九０ - 812 + 812 - 25 + 25 (financial) - 壹貳參四伍六七八九零 + 壹貳參四伍六七八九零 - 26 + 26 (fullwidth Arabic) - １２３４５６７８９０ + １２３４５６７８９０ - 27 + 27 Korean - Hangul - 일이삼사오육칠팔구영 + 일이삼사오육칠팔구영 @@ -2306,13 +2306,13 @@
- CC + CC Calendar - Example (YYYY-MM-DD) + Example (YYYY-MM-DD) Supported LCID @@ -2320,13 +2320,13 @@ - 00 + 00 Gregorian - 2016-08-31 + 2016-08-31 All @@ -2334,13 +2334,13 @@ - 03 + 03 Gengou - 28-08-31 + 28-08-31 411 (Japanese) @@ -2348,13 +2348,13 @@ - 05 + 05 Unknown - 4349-08-31 + 4349-08-31 Unsupported @@ -2368,7 +2368,7 @@ Hijri - 1437-11-28 + 1437-11-28 401 (Arabic - Saudi Arabia), 1401 (Arabic - Algeria), 3c01 (Arabic - Bahrain), 0c01 (Arabic - Egypt), 801 (Arabic - Iraq), 2c01 (Arabic - Jordan), 3401 (Arabic - Kuwait), 3001 (Arabic - Lebanon), 1001 (Arabic - Libya), 1801 (Arabic - Morocco), 2001 (Arabic - Oman), 4001 (Arabic - Qatar), 2801 (Arabic - Syria), 1c01 (Arabic - Tunisia), 3801 (Arabic - U.A.E.), 2401 (Arabic - Yemen) and 429 (Farsi) @@ -2376,13 +2376,13 @@ - 07 + 07 Buddhist - 2559-08-31 + 2559-08-31 454 (Lao), 41E (Thai) @@ -2390,13 +2390,13 @@ - 08 + 08 Jewish - 5776-05-27 + 5776-05-27 40D (Hebrew) @@ -2404,13 +2404,13 @@ - 10 + 10 Indian - 1938-06-09 + 1938-06-09 Unsupported @@ -2424,7 +2424,7 @@ Unknown - 2016-07-29 + 2016-07-29 Unsupported @@ -2451,7 +2451,7 @@ ROC - 0105-08-31 + 0105-08-31 404 (Chinese - Taiwan) @@ -2462,4 +2462,4 @@ - + \ No newline at end of file -- cgit