# Formulas proced with drag handle does not display correct values. [closed]

Oakland Emp & Unemp.odsDear Folks-- I have a Calc worksheet with simple columns of numbers representing employment and unemployment numbers and rates. These numbers were copied as individual columns from Excel spreadsheets downloaded from the U.S. Bureau of Labor Statistics. They did not bring any formatting or formulas with them that I can identify by looking in the cells - just numbers. I am trying to take the difference of several pairs of these columns. I write out the difference in a cell in the usual way, e.g. "=M12-G12" (without the quotation marks) at the top of a column. I then grab the cell handle and pull it down to the bottom of the column. This fills the column with copies of the formula that differ in having the current row number in place of the original row number from the first entry in the column, as I expected. However, all of these formulas evaluate to the same number - the number in the original cell. This number is incorrect for all of the numbers but the original, and does not match the result of calculating the formula in the cell.

I have tried the following things which do not work: Saving the file, closing it, and reopening it; Cutting the column and pasting it back in the same place; Cutting the column and pasting it back in the same place as formulas only; Cutting one of the copied columns and pasting it back as numbers only; Dragging from the bottom instead of the top; Dragging to the right or left instead of vertically (again the formulas are correct but the number remains the value of the original cell); Cutting the entire spreadsheet and pasting it into a different sheet; Dragging the handle while holding down the Ctrl or Shift key; Entering the formula in a different column; Summing the numbers in two of these results columns sums the numbers displayed, not the correct results from the formula; Placing the cursor at the end of the formula in the cell and hitting return; Placing the cursor at the end of the formula in the formula bar window, or whatever it is called, and hitting return.

If I place the cursor in the formula bar, make some change in the formula, such as deleting the final "2" in the example I provided above, and then type the 2 back in ...

Nope, karma is still 1. This sort of discourages new posters from putting up information that may be necessary to allow others to answer their question, no?

You should have a enough karma now.

I attached the file using the dialog box, and it rather oddly put the link at the very beginning of my post. See above.