How to get "automatic" matrix functions?
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://
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
- Assignee:
- No assignee Edit question
- Solved by:
- Tony Pursell
- Solved:
- Last query:
- Last reply: