Issue 54581 - row() & column() array functions should be same as Excel
Summary: row() & column() array functions should be same as Excel
Status: CLOSED DUPLICATE of issue 46681
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.0 Beta
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: requirements
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-09-14 06:20 UTC by richhill
Modified: 2013-08-07 15:12 UTC (History)
2 users (show)

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

Attachments
.xls file with OOo format formulae (8.00 KB, application/vnd.ms-excel)
2005-09-14 06:21 UTC, richhill 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description richhill 2005-09-14 06:20:59 UTC 
row() and column() functions should behave the same as Excel for arrays. 

A row of cells with {=row()} should have more than first entry filled.

{=column(A1:A7)} should give a column of 1's.

See attached document for useful application that works in Excel but
not in OOo. (Summing odd columns)
Comment 1 richhill 2005-09-14 06:21:57 UTC 
Created attachment 29545 [details]
.xls file with OOo format formulae
Comment 2 frank 2005-09-14 10:12:21 UTC 
Not a bug but an enhancement request.

So re-assigned to requirements.

Frank
Comment 3 ooo 2005-09-14 11:43:07 UTC 
Funny sample document.. loading the document in Excel 2003 results in
a #VALUE! error in cell E7, apart from some #NAME! errors for the
=FORMULA(...) cells. However, the original request is about repeating
values of a one-dimensional array if it is used in two dimensions, as
can be also seen in A15:B18 and A20:B23. This is already covered by
issue 46681.


*** This issue has been marked as a duplicate of 46681 ***
Comment 4 ooo 2005-09-14 11:43:37 UTC 
Closing dup.