Issue 43152

Summary:	Issue in compatibility with Excel cross page references.
Product:	Calc	Reporter:	alex_rus <cc>
Component:	editing	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	issues, jtatum
Version:	680m79
Target Milestone:	---
Hardware:	All
OS:	Windows 2000
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

Description alex_rus 2005-02-19 22:12:07 UTC

Hi, 
it seems there is compatibility issue in Cal with Excel. I understand that it
arise due to different way calc handles references but for me it's bug in
compatibility of Excel and Calc.
The issue is as follow:
The usage of complex formulas in Excel leads to error, for example:
i used the following formula in Excel:
=SUMIF(INDIRECT(CONCATENATE(D$3;"!";"K:K"));$A4;INDIRECT(CONCATENATE(D$3;"!";"I:I")))

As Calc has different cell reference style the formula must be read as:
=SUMIF(INDIRECT(CONCATENATE(D$3;".";"K1:K65536"));$A4;INDIRECT(CONCATENATE(D$3;".";"I1:I65536")))

so i must manually correct all formulas as they are not converted automatically.

Is there any chance to correct this issue? Basically to make Cal understand ref
like =sum(sheet1!C:C)

Alexander

Comment 1 frank 2005-02-21 20:53:23 UTC

Hi,

not a bug, but an enhancement request.

So re-assigned.

Frank

Comment 2 frank 2005-02-21 20:54:27 UTC

*** Issue 43154 has been marked as a duplicate of this issue. ***

Comment 3 alex_rus 2005-02-21 21:03:47 UTC

Hi, 
can't agree that it is enhancement, because there are many excel sheets with
such complex formulas and when user opens them in Calc he gets error 502 instead
of result, so that is clearly issue in compatibility.

I can accept that it will be enhancement if i can use such references (for
example A:A, instead of A1:A65536), but i think Calc must convert such
references to which it understands.

Alexander

Comment 4 jtatum 2005-10-09 17:17:28 UTC

Which issue is being covered by this issue?  The import problem or the cell
range specification?  It took me a while to find this due to the summary, can
the summary be changed for easier searching?

Comment 5 ace_dent 2008-05-16 01:41:10 UTC

OpenOffice.org Issue Tracker - Feedback Request.

The Issue you raised is currently assigned to 'Requirements' pending review, but
has not been updated within the last 2+ years. Please consider re-testing with
one of the latest versions of OOo, as the problem(s) may have already been
addressed. Either use the recent stable version:
http://download.openoffice.org/index.html
or consider trying the new OOo 3 BETA (still in testing):
http://download.openoffice.org/3.0beta/
 
Please report back the outcome so this Issue may be Closed or Progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further by checking the Issue Tracker:
http://www.openoffice.org/issues/query.cgi
 
Many thanks,
Andrew
 
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~
http://marketing.openoffice.org/3.0/announcementbeta.html