Ask Your Question

Calc: How to extend the range of cells affected by SUM? [closed]

asked 2014-02-17 01:09:26 +0200

bwva gravatar image

updated 2015-09-12 14:51:57 +0200

Alex Kemp gravatar image

In Excel whenyou click SUM below a column of numbers containing some gaps it will select the nearest range of consecutive filled cells and you can drag the edge of the range to include other cells above, treating empty cells as zero value. This doesn't seem possible in Calc. (Ver; Win 8.1)

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 10:49:18.333030

2 Answers

Sort by » oldest newest most voted

answered 2014-02-17 02:50:47 +0200

m.a.riosv gravatar image

I think you move the range up, dragging with the hand on the first cell of the range, to the top-left of the new range, and then extend it down/right.

edit flag offensive delete link more

answered 2014-02-17 03:24:46 +0200

ROSt52 gravatar image

updated 2014-02-18 04:38:39 +0200

Since a while I wanted to write an enhancement request on this...

The hand is nice! But it only moves the existing range up, down, left, and right and does not expand the range. For extension of the range, the hand must be used to move the existing range up and than clicking on the little square at the right bottom corner of the range must be extended to the bottom or bottom right or bottom left. The little square can also be used to reduce the range.

It would be much better if the hand could be used on
- the left or right side of the range for moving the existing range to anywhere without changing its size - on top and bottom of the range to expand it up or up and right or down or down and left.

edit flag offensive delete link more


I just wrote the enhancement request. Here it is. Please feel free to add comments.

ROSt52 gravatar imageROSt52 ( 2014-02-17 03:33:28 +0200 )edit

HI @ROSt52 this is an enhancement in new releases.

m.a.riosv gravatar imagem.a.riosv ( 2014-02-17 03:39:56 +0200 )edit

Hi @mariosv - This is great news!!!! Do you know by any chance in which release this will be?

ROSt52 gravatar imageROSt52 ( 2014-02-17 06:44:57 +0200 )edit

Question Tools

1 follower


Asked: 2014-02-17 01:09:26 +0200

Seen: 507 times

Last updated: Feb 18 '14