Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'd like to perform an operation on a set of non adjacent ranges in LibreOffice calc.

I can type: C4:GA4 into the "name" box in order to select a single range. Is there a way to select non adjacent ranges (eg. C4:GA4,C15:GA15), or am I stuck using the tedious and error-prone Ctrl-click and drag method?

Edit: To clarify, I want a way to SELECT these ranges. I'm not attempting to feed them into a formula. In this particular case, I want to select a set of ranges for use in building a chart. There are enough ranges that selecting each manually would be very time consuming.

share|improve this question

If I am reading your question correctly, calc allows use of multiple non-adjacent ranges in formulae:

The basic example I tried was:


Where it successfully applied SUM calculating every range.

I hope that answers your question.

share|improve this answer
Unfortunately, that's not really what I'm after. I've modified my question so that it is (hopefully) more clear. – vezult Feb 13 '13 at 18:53

One thing that you can do is to use another selection mode instead of the standard, then copy the contents to another place (choose an upper left cell) and perform the desired calculation.

My suggestion for your case. In the calc window, at the bottom, in the middle of the window, there are two symbols, The one on the left is grey. So, you select one of the cells at the extreme of the range (ex. C4). Then, you can press the adding selection. Press CTRL + SHIPT + RIGHT cursor to move to the other end of the contiguous block of cells (you're now at GA4).

Copy the cells to another sheet and possibly transpose the selection so that you have the cells in one column.

Repeat it to the 15th row and paste (and transpose) it to the end of the last set pasted. Name the extended set.

Now perform the calculation you need.

share|improve this answer
This doesn't scale well. If, for example, I needed to do that 50 times for very long would take forever. It is slightly less error prone than using the mouse, I'll give you that. – vezult Feb 13 '13 at 19:06

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .