Created attachment 69650 [details]
Simple array test
Win 7x64 Ultimate.
1) new spreadsheet.
2) introduce from A1 a simple data like:
titulo1 titulo titulo3 titulo4 titulo5 titulo6 titulo7
hola 1 3 vay 2 3 vay
adios 2 4 ven 3 4 ven
3) in any cell out of this range introduce as array formula:
4) result in:
titulo1 1 3 titulo4 2 3 titulo7
hola 2 4 vay 3 4 vay
adios ven ven
5) where there is an number in the second cell of the column, is moved a row up in the resulting array.
Confirmed. I'll take a look.
Thanks for testing the master build. We appreciate it. :-)
Kohei Yoshida committed a patch related to this issue.
It has been pushed to "master":
fdo#56829: Correctly pass element values to matrix.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
Hi Kohei, thanks for the quick fix.
Seems to be solved in MinGW
Out of curiosity, why it only happened with numbers in cells?
(In reply to comment #5)
> Out of curiosity, why it only happened with numbers in cells?
It only happened when the range had a mix of texts and numbers. The code that processed the input was simply doing the wrong thing.
Hi Kohei, thanks.