https://issues.apache.org/ooo/show_bug.cgi?id=125743
--- Comment #4 from Jim DeLaHunt <[email protected]> --- Microsoft Excel 2008 for Mac (version 12.3.6 (130206) has different behaviour than OO.o Calc 4.0.1. I tried permutations of (vector parameter for row, 0 for column) and (0 for row, vector parameter for column) with (2-row 1-column) and (1-row 2-column) vector parameters. In each case the value in the upper-left cell is the same between Excel and OO.o. However, the values in the remaining cells differ. Also, when I define the array formula, Excel doesn't replicate it to adjoining cells, the way OO.o Calc does when it has a multi-cell array to return. Wrapping the INDEX() expression in ROWS() and COLUMNS() functions seems to indicate that Excel does return an array, not a single cell. My next step is to make a test spreadsheet which tries the permutations and shows the results. One can open this spreadshset in both OO.o and Excel to compare. -- You are receiving this mail because: You are the assignee for the issue. You are watching all issue changes.
