Frequently asked questions - Calc

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


    Какое максимальное число ячеек, строк, столбцов и листов в электронных таблицах LibreOffice?

    • Максимальное число столбцов 1 024 (от столбца A до столбца AMJ);
    • максимальное число строк 1 048 576 (220);
    • максимальное число ячеек в одном листе 1 073 741 824 (230);
      • максимальное число символов в одной ячейке 32767;
    • максимальное число листов в одном документе электронной таблицы 10 000.
    • the maximum number of columns is 16384 (from column A to column XFD), in older versions 7.3 and below it was 1,024 (from column A to column AMJ);
    • the maximum number of rows is 1,048,576 (220);
    • the maximum number of cells in one sheet is 1,073,741,824 (230 which is more than 1 billion cells);
      • the maximum number of characters in one cell is 32767 (needs updating - likely 231 is the programmatic limit; tested to accept 70 million characters, although worked exceptionally laggy);
        • the maximum number of characters in a function result is 228 (256Mi)[1];
        • the maximum number of a formula's tokens (internal data units after parsing the formula) is 8192[2]. This does not map 1:1 to number of characters or functions in a formula, but still limits its complexity (would give error for too complex formulas);
    • the maximum number of individual sheets in a complete worksheet is 10000.