[Solved] Drag and Drop not working

Discuss the spreadsheet application
Post Reply
dizzy 7
Posts: 2
Joined: Thu Aug 06, 2020 4:50 pm

[Solved] Drag and Drop not working

Post by 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?
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
User avatar
Zizi64
Volunteer
Posts: 11483
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Drag and Drop not working

Post by Zizi64 »

Can you upload an ODF type sample file here?
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
dizzy 7
Posts: 2
Joined: Thu Aug 06, 2020 4:50 pm

Re: Drag and Drop not working

Post by 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.
open office 4.17 on windows 10 pro
Post Reply