Created attachment 14439 [details]
Array table calc

Created attachment 14440 [details]
Array table calc

In OOo you can use the arrayfunction MMULT.
=MMULT(A2:A37;D1:E1)

regina,  that is not the type of result I am trying to get (nor will I always
have the same number of columns as rows).  I am attaching an Excel spreadsheet
that shows the same problem. for what it is worth - Excel also has the MMULT()
function.  I suspect this bug causes a lot of other array-based problems!!

Created attachment 14443 [details]
Excel example

Forgot to mention: It does not matter what operator you use, you could be just
adding.  If you try to open the excel file in OOo you will see all the array
cells contain #N/A except for the first array cell. In Excel the results look
normal.

I do not understand you.
What is wrong with MMULT(A2:A37;B1:E1)? It produces the same results as in Excel
=B1:E1*A2:A37 does.
> is not the type of result I am trying to get
What do you mean with "type of result"? What "type of result" you are trying to get?
> nor will I always have the same number of columns as rows
It doesn't have the same number, there are 37 rows and 4 colums. 

Do you want a new feature in OOo, so that it behaves like Excel?
Do you want, that Excel's =B1:E1*A2:A37 is translated to MMULT when importing an
Excel-sheet? 

> I do not understand you.
> What is wrong with MMULT(A2:A37;B1:E1)?

Try putting that in OOo... It does not work.  What if I want to add ie:
A2:A37+B1:E1???

> What do you mean with "type of result"? What "type of result" you are trying
to get?

In QPro and in Excel, the array fills the table with each corresponding value. 
Look at the attached examples.  OOo will fill in the table only for a single column.

> Do you want a new feature in OOo, so that it behaves like Excel?

Dunno - I am trying to convert from QPro, not Excel, so I should say I want a
feature that behaves like QPro's @ARRAY()

> Do you want, that Excel's =B1:E1*A2:A37 is translated to MMULT when importing
> an Excel-sheet? 

Since QPro does not have MMULT(), I guess not. I think @MULT() is the closest
thing in QPro.

> I want a feature that behaves like QPro's @ARRAY()
I do not know, if such a feature will be implemented, I am an user like you, but
until that, have a look at "Multiple Operations..." in menu "Data". With that
you can generate a two-dimensional table with all calculations you like without
any arrayfunction.

>> Try putting that in OOo... It does not work.  What if I want to add ie:
>> A2:A37+B1:E1???

Ok I get it now, multiplying works with =MMULT(A2:A37;D1:E1) if you are smart
enough to hit ctrl-shift-enter - duh!, however some of the sheets I am trying to
convert do not multiply, they have addition and subtraction in some places.
Since OOo does not have QPro conversion, I am doing the conversions manually for
the client.  I don't want to have to tell him he now has to edit the formula in
every column!  Tried =SUM(A2:A37+B1:E1), it just adds the first column and first
row to every output cell.

>I do not know, if such a feature will be implemented, I am an user like you, but
until that, have a look at "Multiple Operations..." in menu "Data". With that
you can generate a two-dimensional table with all calculations you like without
any arrayfunction.

The real bummer is that Excel seems to work just fine :(

OOo version 680m_32 developer snapshot now shows #NAME? using MMULT() in an array..

Hi Eike,

as discussed as enhancement to you.

Frank

Accepted, interoperability.

> I do not know, if such a feature will be implemented, I am an user like you, but
until that, have a look at "Multiple Operations..." in menu "Data". With that
you can generate a two-dimensional table with all calculations you like without
any arrayfunction.

This definetly did the trick, in some ways it is actually better than @ARRAY,
Thank you VERY much regina!

Will be fixed with issue 46681.

*** This issue has been marked as a duplicate of 46681 ***

Closing dupe.