How to get "automatic" matrix functions?

Asked by quantenemitter

Hi there,
I'm talking about autocompletion of functions in calc.

Step 1:
One example: Assume you like to add A1:A100 in B1, A2:A100 in B2 etc. To accomplisch that, you enter "=SUM(A1:A$100)" in B1. Afterwards, you "drag" the formula to B2 … B100 and everything will be fine.

Step 2:
But I'm using a matrix sum function as documented in http://www.ooowiki.de/SummeWenn (German!). A simple example of a matrix function would be: {=SUM((A1:A100>=90)*(A1:A100<=120)*(A1:A100))}
You don't enter the "{}" by hand, but you enter the rest and finish the command with CTRL+SHIFT+RETURN _or_ you go into the function editor and check "matrix" (you find it at the lower left).

The problem ist: I'm unable to "drag" the matrix function of Step 2 like described in Step 1.

What I've tried:
* Enter the matrix function and drag it. – Does not work.
* Enter the function without "{}" and drag it (works). But afterwards I'm unable to mark all those functions as matrix fanctions at once. I need to mark them seperately one-after-another.

So the question ist: How to "drag" a matrix function with the same behavior as "normal" functions (as described in Step 1)?

I hope you can understand my description.

Thank you for your help!

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu libreoffice Edit question
Assignee:
No assignee Edit question
Solved by:
Tony Pursell
Solved:
Last query:
Last reply:
Revision history for this message
Tony Pursell (ajpursell) said :
#1

Hi

This is what Help says:

Copying Array Formulae
1. Select the cell range or array containing the array formula.
2. Either press F2 or position the cursor in the input line.
3. Copy the formula into the input line by pressing Ctrl+C.
4. Select a range of cells into which you want to insert the array formula and either press F2 or position the cursor in the input line.
5. Paste the formula by pressing Ctrl+V in the selected space and confirm it by pressing Ctrl+Shift+Enter. The selected range now contains the array formula.

Hope that helps

Tony

Revision history for this message
quantenemitter (quantenemitter) said :
#2

Whow, not bad. Now _copying_ of array formulae is working fine :) Thank youi!

But I'd like to have the "dragging" bahaviour: the formula should be adjusted just like in "Step 1", not just copied. Any idea?

Revision history for this message
Best Tony Pursell (ajpursell) said :
#3

Here is where you start to make a request for product enhancement in LibreOffice

https://bugs.freedesktop.org/enter_bug.cgi?product=LibreOffice

although you might like to start at

http://www.libreoffice.org/get-involved/

for a more general view of how to get involved in LibreOffice.

Tony

Revision history for this message
quantenemitter (quantenemitter) said :
#4

Oops, do you indicate this function in not implemented yet? Thank you for this information. Let's post a request.

Revision history for this message
quantenemitter (quantenemitter) said :
#5

Thanks Tony Pursell, that solved my question.

Revision history for this message
quantenemitter (quantenemitter) said :
#6