Issue 59362

Summary: Localized R1C1 notation (Z1S1) used in string parameter to INDIRECT() function
Product: Calc Reporter: sulimma <openoffice>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: ACCEPTED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, maison.godard, pascal1.lib
Version: OOo 2.0   
Target Milestone: ---   
Hardware: All   
OS: All   
URL: http://www.iwu.de/datei/Gradtagszahlen_Deutschland.xls
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on: 20857    
Issue Blocks:    
Attachments:
Description Flags
testcase of Z1S1 localized R1C1 notation used as string parameter to INDIRECT() function none

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