Ask Your Question

Reentered formula in Calc no longer produces result [closed]

asked 2014-04-05 03:57:22 +0100

unhandyman2003 gravatar image

updated 2015-09-09 11:56:34 +0100

Alex Kemp gravatar image

I am using windows 7. I made a simple spreadsheet to emulate a checkbook. I upgraded to the most current version thinking my problem may have been solved. I am now over 650 rows of data in it. Basically there are columns representing date, check number, remarks, deposits and one for checks/withdrawals and current balance. I deleted the info from a prior row in order to insert data and when I entered the new data the formula for the current balance cell was no longer there. Previously I had been able to extend the current balance column downward by just grabbing the lower right corner with the mouse pointer and moving it down some rows and the formula would generate based on the prior formula. (formula was new current balance=old current balance + new deposit -check/withdrawal using cell designations of course.) Grabbing the old cell would no longer generate the formula and when I entered the formula into the cell all I got was a display of the word value and some## in that cell and the cells directly below it in the column. Using enter or clicking on the accept icon after entering the formula did not make it work. I was ,however, able to get the cells below working on the generated formula by manually entering the correct current balance in the cell (which wiped out the formula for the cell.) Still the cells below work properly now. Any thoughts?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 18:59:17.476143


'#VALUE!' could mean that one of the entries is not numeric, causing an arithmetic error. To check this, toggle currency format (icon = coins). Inspect any cell that does not change with the rest.

Alternatively, '###' could mean that the columns are not wide enough to adequately display the values.

黄智壯 gravatar image黄智壯 ( 2014-04-05 11:12:49 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-04-05 13:08:46 +0100

ROSt52 gravatar image

I think @黄智壯 is right.

Simple test (=what I would do):
Insert a column next to the one where you observe the problem:
Enter in the first row the formula: = >first cell in you colum with problem<+1
Copy formula
Move cursor onto the first cell of the column with problems
ctrl+down you reach the end of the column
Move cursor the newly inserted column
ctrl+shift+up (you reach the top of the inserted colum)

Whenever you see #value in the column with the formulas, there is no number in the original cell.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-04-05 03:57:22 +0100

Seen: 112 times

Last updated: Apr 05 '14