OpenOffice Calc - Drag down without Counting up?

figarow on 04/04/2017 - 18:34

Frustration has found me….
When dragging down a cell with a number in it, it will always count up the numbers up, so if I have '1' in the first cell when dragging down it will go, 2, 3, 4, etc. Is there a way to stop this? I just want to copy the contents of the cell down to other cells. Much appreciated. Thought I should ask before I destroy this rather expensive laptop….

Computing

Related Stores

openoffice.org
openoffice.org

Comments

  • Agarwal on 04/04/2017 - 19:20
    +1

    Can't you just use Control - C to copy the cell and Control V to paste it?

    • figarow on 04/04/2017 - 19:27

      Yes but dragging is MUCH faster!

  • endotherm on 04/04/2017 - 19:44
    +3

    I have an older version of OO installed, and it has far less features than Excel (which allows you to define how the drag feature works). The only way I have done it in the past is to put the same number in 2 stacked cells, select both of them, then drag down. e.g. A1=1, A2=1. highlight both, drag down. I think by default it tries to analyze the difference in the cells, then continues the series by incrementing by that amount. However if the cells are the same, it continue the series by adding the difference ("0"). This results in them being identical.

    • beaver2233 on 04/04/2017 - 19:59
      +2

      this. same default as excel I believe.

    • figarow on 04/04/2017 - 20:11

      It works! Great work around, thanks will save me much time :)

      • Master Bates on 05/04/2017 - 00:08

        Also try holding the 'ALt' key instead of 'Ctrl'. It works as you want in MS Excel, hopefully in OO too.

  • battler on 04/04/2017 - 20:25
    +2

    other options:
    1) hold ctrl when dragging down
    2) drag down (creates sequence) then CTRL-D to copy value in first cell into the range

    • endotherm on 05/04/2017 - 13:29
      +2

      Option 1 (holding ctrl) didn't work on the older version of OO I had installed, but it did work in the latest version. This would be the preferred (laziest :) ) method if it works in your program.

  • wasdw246 on 04/04/2017 - 20:43
    +1

    What happens when you type '1' in two cells, select both and drag down?

  • Diji1 on 04/04/2017 - 21:02
    -2

    Microsoft Excel is an alternative that works.

  • askedforitback on 04/04/2017 - 22:11
    +4

    You may also be interested to know (if you didn't already) that the OO.org project is essentially on life support and you should switch to LibreOffice which is a continuation of the old OO.org codebase. It's made significant progress since they split a few years ago.

    • Adz81 on 05/04/2017 - 11:18

      Oh, no shit?

      Thanks, I'd best update… it's been way too long since I've even looked at OO.

      Cheers!

Login or Join to leave a comment
Login Join