Issue 72863 - Cells referencing others by the column header are broken in ods but not xls
Summary: Cells referencing others by the column header are broken in ods but not xls
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.0.4
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-12-22 00:08 UTC by colinfox
Modified: 2017-05-20 11:11 UTC (History)
2 users (show)

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

Attachments
Save this file as ODS and reload it. You'll see broken column references. (97.00 KB, application/vnd.ms-excel)
2006-12-22 00:09 UTC, colinfox 		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 colinfox 2006-12-22 00:08:42 UTC 
I'll attach an xls file that illustrates the problem. But basically, if you have
a cell that has a formula that uses a column header title instead of a regular
(A1,B5 etc) style reference, it works in xls but breaks in ods.

To see this, take the attached xls file and just save it as an ods file. Quit
OOo then reload the ods file into calc.
Comment 1 colinfox 2006-12-22 00:09:34 UTC 
Created attachment 41639 [details]
Save this file as ODS and reload it. You'll see broken column references.
Comment 2 kpalagin 2006-12-24 07:38:33 UTC 
Confirming with OO 2.1 on WinXP - saving attached file in .ods, closing and 
opening it produces error in the last column.
Comment 3 frank 2007-01-16 15:03:50 UTC 
Hi Niklas,

please have a look at this one.

Frank
Comment 4 Martin Hollmichel 2007-11-09 16:52:35 UTC 
change target from 2.x to 3.x according to
http://wiki.services.openoffice.org/wiki/Target_3x
Comment 5 Marcus 2017-05-20 11:11:25 UTC 
Reset assigne to the default "issues@openoffice.apache.org".