Issue 113715 - spread sheet's Z column taking wrong reference.
Summary: spread sheet's Z column taking wrong reference.
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 3.2.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact: Suchithra
URL:
Keywords:
: 113716 (view as issue list)
Depends on:
Blocks:
 
Reported: 2010-08-06 21:04 UTC by krishna_36
Modified: 2013-02-19 00:58 UTC (History)
2 users (show)

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

Attachments
This file dispays the error (20.64 KB, text/plain)
2010-08-07 15:41 UTC, krishna_36 		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 krishna_36 2010-08-06 21:04:57 UTC 
I am trying to open a xml file in open office spreadsheet which has a some 
columns of data and a sum of each columns... formula is in built in using xml
 while everything is fine.. for the columns with 'Z' like Z, AZ ... the formula is 
not adding the z column sum, it is adding the sum of A. Like 'Z' column adds A 
column sum, AZ column adds 'B' column. This happens for z column only.
Comment 1 krishna_36 2010-08-07 15:41:28 UTC 
Created attachment 71002 [details]
This file dispays the error
Comment 2 krishna_36 2010-08-07 15:43:16 UTC 
Open the attachement in a excel and and open calc the z column formula referencing  
in open calc would be different to the ms office.
Comment 3 Regina Henschel 2010-08-07 19:49:05 UTC 
There are already issue 90108 and issue 81233 with similar problems.
Comment 4 krishna_36 2010-08-08 05:29:19 UTC 
Ok.

Any resolution ...!
Comment 5 krishna_36 2010-08-08 06:18:45 UTC 
The issue is similar but a little different that issue 81233. In there the open 
office skipped the z column. But in here the open office is taking the wrong 
reference. It is taking the A column sum instead of the Z column.
Comment 6 frank 2010-08-16 09:18:34 UTC 
*** Issue 113716 has been marked as a duplicate of this issue. ***
Comment 7 Suchithra 2013-01-24 17:47:56 UTC 
This issue is reproducible in build:9593  - Rev. 1372282 on MAC OSX 10.6.8. 

For the columns with 'Z' like Z, AZ ... the formula is 
not adding the z column sum.
Comment 8 Suchithra 2013-01-29 14:31:25 UTC 
This issue is reproducible in build:9593  - Rev. 1372282 on MAC OSX 10.6.8. 

For the columns with 'Z' like Z, AZ ... the formula is 
not adding the z column sum.