Issue 94406

Summary:	range operator ':' not fully compatible with Excel
Product:	Calc	Reporter:	drking <openoffice>
Component:	programming	Assignee:	spreadsheet <spreadsheet>
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	OOo 2.4.1	Keywords:	needmoreinfo, oooqa
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description drking 2008-09-29 06:31:57 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)

Comment 1 lohmaier 2009-07-11 14:31:30 UTC

please attach the original Excel spreadsheet/one that shows the problem.

Comment 2 ooo 2009-07-12 01:59:08 UTC

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 ***

Comment 3 ooo 2009-07-12 01:59:29 UTC

Closing dup.