Bug 43534

Summary:	EDITING: CELL doesn't support external references.
Product:	LibreOffice	Reporter:	Kohei Yoshida <kohei>
Component:	Calc	Assignee:	Kohei Yoshida <kohei>
Status:	RESOLVED FIXED
Severity:	normal
Priority:	medium
Version:	Master old -3.6
Hardware:	Other
OS:	All
Whiteboard:	target:3.5
Crash report or crash signature:		Regression By:

Description Kohei Yoshida 2011-12-05 06:41:35 UTC

Built-in CELL function doesn't support external references, but it should.

Comment 1 Kohei Yoshida 2011-12-05 06:44:37 UTC

Another external ref bug.  I should fix this for 3.5.

Comment 2 Kohei Yoshida 2011-12-07 09:25:00 UTC

Some references:

http://office.microsoft.com/en-us/excel-help/cell-HP005209008.aspx?CTT=5&origin=HP005204211 (Excel 2007)

http://docs.oasis-open.org/office/v1.2/cos01/OpenDocument-v1.2-cos01-part2.html#__RefHeading__1018348_715980110 (ODF 1.2)

Comment 3 Kohei Yoshida 2011-12-07 10:37:31 UTC

Initially just COL and ROW.

http://cgit.freedesktop.org/libreoffice/core/commit/?id=c8552bc97b9f860494bc45091936010d98fff1cb

More on the way.

Comment 4 Kohei Yoshida 2011-12-07 19:36:44 UTC

Now officially fixed.

http://cgit.freedesktop.org/libreoffice/core/commit/?id=2419d3c2de9ddcf1c9884d4216775ce70f652f5a

We intentionally don't support PROTECT, PREFIX and WIDTH with external references.