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.