Issue 94406 - range operator ':' not fully compatible with Excel
Summary: range operator ':' not fully compatible with Excel
Status: CLOSED DUPLICATE of issue 4904
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 2.4.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: needmoreinfo, oooqa
Depends on:
Blocks:
 
Reported: 2008-09-29 06:31 UTC by drking
Modified: 2009-07-12 01:59 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
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.