Issue 43152 - Issue in compatibility with Excel cross page references.
Summary: Issue in compatibility with Excel cross page references.
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 680m79
Hardware: All Windows 2000
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 43154 (view as issue list)
Depends on:
Reported: 2005-02-19 22:12 UTC by alex_rus
Modified: 2013-08-07 15:12 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description alex_rus 2005-02-19 22:12:07 UTC
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:

As Calc has different cell reference style the formula must be read as:

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)

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

not a bug, but an enhancement request.

So re-assigned.

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

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 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:
or consider trying the new OOo 3 BETA (still in testing):
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:
Many thanks,
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~