[Solved] Drag and Drop not working

[dizzy 7]

I've been using the drag and drop feature in OO Calc spreadsheets for years with no problem. I enter my formulas in the first row of a column and then as I add new rows I highlight the top cell, move the cursor to the lower right corner, drag it down to the new lower row and the formula automatically updates to the new row. However, in one of my spreadsheets, when I do that the formulas move and update to the new rows (d3/f3 becomes d4/f4, for instance) but the result does not change. It still gives the answer for d3/f3 even tho the formula in row 4 shows d4/f4. Obviously I've accidentally changed some setting for that spreadsheet but I can't figure out what. Can anyone help me?

[Zizi64]

Can you upload an ODF type sample file here?

[dizzy 7]

That's for offering to help, but after I posted my question I decided to give up and type all my data into a new spreadsheet. Fortunately there wasn't a huge amount of data involved. The new spreadsheet and all of my other old ones are working properly, so I just hope I never again do whatever I did and mess up another one.