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
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.