OpenOffice Calc FAQ – Error handling

  • Why do I see the formula text and not the result of the formula?
  • Why does deleting filtered rows remove other rows too?
  • I see three hash signs in a cell that formerly held data. How can I see my data again?

 

Why do I see the formula text and not the result of the formula?

 

  • Make sure that all formulas will start with the equal sign (=)

If your formula starts with the = character, check that the options are set to not view the formula:

  1. Select Tools – Options from the main menu
  2. Select OpenOffice.org Calc – View (in OpenOffice.org 1.1.x: Spreadsheet – View)
  3. Make sure that the Formulas Option under Display is not checked

Why does deleting filtered rows remove other rows too?

 

When using Calc filters, selections that span a range of cells include filtered and hidden rows. Deleting a range of rows with a filter enabled will delete all rows in that range, whether they are visible or hidden, not just the visible rows.

To select multiple rows individually, select the first row, then use CTRL+Click to select each additional row.

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.