Apache OpenOffice (AOO) Bugzilla – Issue 86486
reference problem on column 26,52,...etc
Last modified: 2023-02-01 21:53:14 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 Field!$Z$1 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
Created attachment 51733 [details] simple reference to Sheet1!$Z1 but show Sheet1!A1
@oc: That seems to be Excel XML filter, am I right?
Hi Daniel, could you please have a look
dr->sus: are you still responsible for the MSO 2003 XML filter? If not, please return to me :)
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, Svante
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 and 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
Excel 2010: Sheet 2 A1 =Sheet1!Z1 (=1) Calc: Sheet 2 A1 =please check cell a1 on worksheet 2 AOO410m1(Build:9750) - Rev. 1543812 Rev.1543812 Win 7
Corrected Version
This is a duplicate of bug 81233, which was fixed recently. Thank you for your bug report and sample document :-). *** This issue has been marked as a duplicate of issue 81233 ***