Issue 72863

Summary:

Cells referencing others by the column header are broken in ods but not xls

Product:

Calc

Reporter:

colinfox <cfox>

Component:

open-import

Assignee:

AOO issues mailing list <issues>

Status:

CONFIRMED ---

QA Contact:

Severity:

Trivial

Priority:

CC:

issues, kpalagin

Version:

OOo 2.0.4

Target Milestone:

---

Hardware:

All

OS:

All

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
Save this file as ODS and reload it. You'll see broken column references.	none

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