by dizzy 7 » Thu Aug 06, 2020 5:03 pm
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?
Last edited by
dizzy 7 on Thu Aug 06, 2020 8:40 pm, edited 2 times in total.
open office 4.17 on windows 10 pro