Issue 59362 - Localized R1C1 notation (Z1S1) used in string parameter to INDIRECT() function
Summary: Localized R1C1 notation (Z1S1) used in string parameter to INDIRECT() function
Status: ACCEPTED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.0
Hardware: All All
: P3 Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL: http://www.iwu.de/datei/Gradtagszahle...
Keywords:
Depends on: 20857
Blocks:
  Show dependency tree
 
Reported: 2005-12-14 17:13 UTC by sulimma
Modified: 2017-05-20 11:13 UTC (History)
3 users (show)

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

Attachments
testcase of Z1S1 localized R1C1 notation used as string parameter to INDIRECT() function (814.00 KB, application/vnd.ms-excel)
2005-12-15 12:31 UTC, ooo 		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 sulimma 2005-12-14 17:13:04 UTC 
When trying to use this file in OoCalc 2.0
http://www.iwu.de/datei/Gradtagszahlen_Deutschland.xls

I get an error message "Err:502" for each choice in combobox F10.

Apparently the reason is, that at another place a reference of the type
"Daten!Z182S22" is used and not understood by open office.
Comment 1 jlcheng 2005-12-15 07:15:16 UTC 
reproducible win OOo 2.0.1RC4 and windows 2k
Comment 2 frank 2005-12-15 09:28:12 UTC 
Hi,

the root cause for these Err:502 is the not implemented feature to address cells
by using R1C1 notation.

So this is a double to Issue 20857 .

Frank

*** This issue has been marked as a duplicate of 20857 ***
Comment 3 frank 2005-12-15 09:28:53 UTC 
closed double
Comment 4 ooo 2005-12-15 12:29:43 UTC 
Actually this isn't just a duplicate of issue 20857. Here we have also the case
where a German localized R1C1 notation (Z1S1) is used as a string parameter to
the INDIRECT() function. This isn't even handled by Excel itself in a non-German
version and results in #REF errors. To support such insane cases, additional
work would have to be done.

I'll attach the sample document referenced above before it vanishes from the web..

  Eike
Comment 5 ooo 2005-12-15 12:31:31 UTC 
Created attachment 32449 [details]
testcase of Z1S1 localized R1C1 notation used as string parameter to INDIRECT() function
Comment 6 ooo 2005-12-15 12:32:57 UTC 
Grabbing issue.
Comment 7 ooo 2005-12-15 12:36:15 UTC 
Accepted. Setting dependency on issue 20857. Adapting summary.
Comment 8 maison.godard 2006-10-24 11:58:07 UTC 
myself to CC
Comment 9 Marcus 2017-05-20 11:13:28 UTC 
Reset assigne to the default "issues@openoffice.apache.org".