Apache OpenOffice (AOO) Bugzilla – Issue 94406
range operator ':' not fully compatible with Excel
Last modified: 2009-07-12 01:59:29 UTC
A forum poster has imported from Excel: SMALL(INDEX(J2:AG2;;F2):AG2;1) where F2 contains a number which doesn't work in Calc, even as SMALL(INDEX(J2:AG2;1;F2):AG2;1) (in case the missing parameter is a problem) INDEX does return a reference - eg ROW(INDEX(...)) works OK. I _think_ that the range operator ':' is probably not understanding the single cell reference returned by INDEX(J2:AG2;1;F2)
please attach the original Excel spreadsheet/one that shows the problem.
The range operator was implemented for OOo3.0, with regression in OOo3.1, fixed again for OOo3.1.1, see also issue 101544. *** This issue has been marked as a duplicate of 4904 ***
Closing dup.