Frequently asked questions - Calc

From The Document Foundation Wiki
< Faq‎ | Calc
Jump to: navigation, search

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 text, the excess content is simply hidden. 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, if the content of the cell is a number.
  • 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.