Faq/Calc/002

    From The Document Foundation Wiki
    < Faq‎ | Calc


    How to view the contents of a cell which displays ###

    Even if the content of a cell is too big for it to be displayed in a single cell, the cell keeps its default height and width. If it contains a number, the number is replaced by ###.

    You can:

    • Go to the head of the column and drag one of the edges of the column until the width is sufficient (or double-click on the edge to adjust it automatically) allowing a correct display.
    • Double-click on any cell that contains text together with a little red triangle in the corner of the cell to signal that the content exceeds the display.

    You may also wish to consult the table of errror codes for spreadsheets in FAQ 015.