I see three hash signs ('###'} in a cell that formerly held data. How can I see my data again?

From Apache OpenOffice Wiki
< Documentation‎ | FAQ‎ | Calc‎ | Errors
Jump to: navigation, search


I see three hash signs ('###'} in a cell that formerly held data. How can I see my data again?


When the content of a cell is too long to be displayed in a single cell, it will be clipped at the standard width and height of the cell itself. The rest of the content is simply hidden.

  • Go to the heading row and drag one of the column edges until it is wide enough to display your data properly if the cell content is a number; or
  • Double-click on the cell if the cell content is text and a little red triangle appears on the right side of the cell to signal that this is an overflowing one.


Personal tools