Frequently asked questions - Calc

    From The Document Foundation Wiki
    < Faq‎ | Calc
    This page is a translated version of the page Faq/Calc/137 and the translation is 0% complete.
    Outdated translations are marked like this.


    Как ввести число процентов в ячейку? (проблема волнует только пользователей французской локали)

    Проблема

    Если я ввожу значение 19,6% в ячейку, то перед знаком % автоматически вставляется пробел. При проверке значения текст оказывается выровнен по левой стороне, указывая на то, что содержимое ячейки рассматривается как текст, а не как числовое значение. Таким образом, ячейка не может использоваться для расчетов.

    Problem

    When I type a value like 19,6% into a cell , a space is automatically inserted just before the % character. When I validate, the text aligns to the left, indicating that the content of the cell is considered as text and not a numeric value. The cell is therefore not usable for calculations.

    Объяснение

    Параметр Добавлять неразрывный пробел перед некоторыми знаками пунктуации на французском языке, доступный в меню Сервис > Параметры автозамены > Национальные, позволяет вставить неразрывный пробел перед двойными символами, такими как (:;?!%), как это рекомендовано типографскими правилами французского языка.

    The option, selected from the menu Tools ▸ AutoCorrect Options ▸ Localized Options, entitled Add non-breaking space before specific punctuation marks in French text, allows you to insert a non-breaking space in front of double punctuation marks such as (:;?!%), as required by French typographical rules. règles typographiques française.

    Обходной путь

    Некоторые возможные пути обхода данной проблемы:

    • preformat the cell with the format percentage ; the symbol % will be automatically inserted without a space after entry
      • either by applying a style,
      • or by using the format menu (or the context menu),
      • or directly with the key combination Ctrl + ⇧ Shift + 5,
      • or simply by clicking on the Format tool in the Formatting toolbar
    copie d'écran barre d'outils formatage
    Preformating with the button or the keyboard
    • deactivate the function. The consequence is that this functionality will be deactivated in all modules (Writer, Impress...)
    • delete the space inserted automatically :
      • either a posteriori by editing the content of the cell
      • or immediately after entering the character % using Ctrl + Z
    • force the recognition of a numeric value
      • begin cell content with an = sign
      • begin cell content with a + sign (it doesn't matter if the value is negative)
    • modify the language to one for which this option is not active. For example in Canadian French, the non-breaking space is only inserted before the : character.
      • In the Styles and Formatting window, right-click on Default cell style ▸ Modify
      • Font tab
      • modify the language (money values will not be affected as they are defined by Tools ▸ Options ▸ Language settings ▸ Languages, Default currency)

    Some possible ways of working around this are:

    • preformat the cell with the format percentage ; the symbol % will be automatically inserted without a space after entry
      • either by applying a style
      • or by using the format menu (or the context menu)
      • or directly with the key combination Ctrl + ⇧ Shift + 5
      • or simply by clicking on the Format tool in the Formatting toolbar
    copie d'écran barre d'outils formatage
    Preformating with the button or the keyboard
    • deactivate the function. The consequence is that this functionality will be deactivated in all modules (Writer, Impress...)
    • delete the space inserted automatically :
      • either a posteriori by editing the content of the cell
      • or immediately after entering the character % using Ctrl + Z
    • force the recognition of a numeric value
      • begin cell content with an = sign
      • begin cell content with a + sign (it doesn't matter if the value is negative)
    • modify the language to one for which this option is not active. For example in Canadian French, the non-breaking space is only inserted before the : character.
      • In the Styles sidebar deck, right-click on Default cell style ▸ Modify
      • Font tab
      • modify the language (money values will not be affected as they are defined by Tools ▸ Options ▸ Language settings ▸ Languages, Default currency)