Issue 86486 - reference problem on column 26,52,...etc
Summary: reference problem on column 26,52,...etc
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC Windows, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: needhelp
Depends on:
Reported: 2008-02-26 20:03 UTC by danjperron
Modified: 2014-03-01 18:53 UTC (History)
3 users (show)

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

simple reference to Sheet1!$Z1 but show Sheet1!A1 (2.30 KB, text/xml)
2008-02-26 20:09 UTC, danjperron
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description danjperron 2008-02-26 20:03:57 UTC
I try to create stand alone xml page. Everything works in excel but

  in calc it doesn't.   

    if the xml file containt

   <Cell ss:Formula="=Field!R1C26">

   the cell will be link to worksheet Field!$A$1 and it suppose to be

    if the xml file containt

   <Cell ss:Formula="=Field!R1C52"> it is now on Field!B$1 and
   it is supposed to be Field!$AZ$1

   I found the same problem with indirect reference "R[]C[]"

  The only way to make it works is to use   

  <Cell ss:Formula="=Field!$Z$1">  but excel doesn't like it!

  The problem is only if the reference is to an other worksheet!

Daniel Perron
Comment 1 danjperron 2008-02-26 20:09:46 UTC
Created attachment 51733 [details]
simple reference to Sheet1!$Z1 but  show Sheet1!A1
Comment 2 jogi 2008-09-12 15:48:07 UTC
@oc: That seems to be Excel XML filter, am I right?
Comment 3 oc 2008-09-19 13:40:02 UTC
Hi Daniel, could you please have a look
Comment 4 daniel.rentz 2008-09-19 14:58:43 UTC
dr->sus: are you still responsible for the MSO 2003 XML filter? If not, please
return to me :)
Comment 5 svante.schubert 2008-12-05 13:20:44 UTC
Changed target to "OOo please help" as I need help from the community!

The Office 2003 filters are no longer maintained by myself. My priority has
shifted to the ODF file format and the ODF Toolkit project (e.g. ODFDOM) and
even MS is working now on OOXML instead of their old XML 2003 formats, therefore
Sun has been implemented and is now supporting the OOXML import filter with OOo 3.0.

Kind regards,
Comment 6 Rainer Bielefeld 2013-10-12 11:27:09 UTC
Seems to be a Calc file-open problem?

I don't understand at all what about the report might be, but I see a difference between 
* "AOO 4.0.1   – German UI / German locale  [Rev. 1524958 2013-09-20 11:40:29]" on  German WIN7 Home Premium (64bit)", “historic”  4.0  User Profile used for all  predecessor versions
LibO 420:

Steps how to reproduce:
0. Create a copy of reporter's sample document
1. From an  empty Calc document open reporter's sample document in AOO
2. From an  empty LibO Calc document open reporter's sample document in LibO
3. Compare formulas and results in Sheet2:A1
   AOO:  =Sheet1.A1
   LibO: =Sheet1.A1, but shows "1" of Sheet1:Z1, what will change to text 
         in Sheet1:A1 after "Update all"

My EXCEL viewer can't open reporter's sample 

My SML knowledge is too rare to decide whether observed behavior is a bug
Comment 7 Edwin Sharp 2013-11-22 11:54:47 UTC
Excel 2010:
Sheet 2 A1 =Sheet1!Z1 (=1)
Sheet 2 A1 =please check cell a1 on worksheet 2

AOO410m1(Build:9750)  -  Rev. 1543812
Win 7
Comment 8 Rainer Bielefeld 2014-03-01 18:53:32 UTC
Corrected Version