Issue 76526 - INDIRECT is not XL compatible
Summary: INDIRECT is not XL compatible
Status: CLOSED DUPLICATE of issue 30172
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.2
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2007-04-19 15:50 UTC by pagalmes.lists
Modified: 2008-05-17 23:48 UTC (History)
1 user (show)

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

Attachments
the doc (280.50 KB, application/vnd.ms-excel)
2007-04-19 15:52 UTC, pagalmes.lists 		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 pagalmes.lists 2007-04-19 15:50:39 UTC 
Check the XLS document under OOo. There is an error on cell I27. The result
should be "7".

In the formula, the problem comes from "Fériés!E" not converted to "Fériés.E"
("!" not converted to ".").
Comment 1 pagalmes.lists 2007-04-19 15:52:04 UTC 
Created attachment 44546 [details]
the doc
Comment 2 pagalmes.lists 2007-04-19 15:52:58 UTC 
OOo expects:

=EQUIV(DATEVAL(I$8&"/"&MOIS($A26)&"/"&Année_5);INDIRECT("Fériés.E"&$AL$2&":E"&$AL$2+20);0)

Instead of:

=EQUIV(DATEVAL(I$8&"/"&MOIS($A26)&"/"&Année_5);INDIRECT("Fériés!E"&$AL$2&":E"&$AL$2+20);0)
Comment 3 jodygoldberg 2007-04-19 17:54:10 UTC 
duplicate of the #30172 that will be solved when the XL compatible versions from
the R1C1 patch are enabled.

*** This issue has been marked as a duplicate of 30172 ***
Comment 4 ace_dent 2008-05-17 21:43:42 UTC 
The Issue you raised has been marked as 'Resolved' and not updated within the
last 1 year+. I am therefore setting this issue to 'Verified' as the first step
towards Closing it. If you feel this is incorrect, please re-open the issue and
add any comments.

Many thanks,
Andrew
 
Cleaning-up and Closing old Issues
~ The Grand Bug Squash, pre v3 ~
http://marketing.openoffice.org/3.0/announcementbeta.html
Comment 5 ace_dent 2008-05-17 23:48:35 UTC 
As per previous posting: Verified -> Closed.
A Closed Issue is a Happy Issue (TM).

Regards,
Andrew