Issue 5250

Summary:	Manual line break in cell breaks formula
Product:	Calc	Reporter:	aschrage <ansgar>
Component:	ui	Assignee:	AOO issues mailing list <issues>
Status:	ACCEPTED ---	QA Contact:
Severity:	Trivial
Priority:	P4	CC:	issues
Version:	OOo 1.0.0	Keywords:	ms_interoperability, oooqa
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description aschrage 2002-05-24 14:14:46 UTC

When you enter a manual line break into a cell with the formula, the formual is 
not computed any more. For example enter the following formula in the cell A3:
="The sum is " & sum(a1:a2)
This works fine. But now enter a manual line break (CTRL + Enter) after 
the 'is'. What I would expect to see is the text in the first line and the 
value in the second line. Instead of this Calc shows the text and formula 
itself.
When you import an Excel-Sheet into Calc that has such line breaks in a cell it 
works fine.

Comment 1 peter.junge 2002-06-10 13:37:47 UTC

Hi,
reproduced. Excel disregards the manual linebreak. But I think it
would be even nicer to use it as formatting feature.
Best regards, Peter

Comment 2 ooo 2002-06-10 14:58:32 UTC

Inserting a line break into the formula changes the cell type to a
complex edit cell, not being a formula cell anymore.

er->pj: With a "formatting feature" you're referring to a linebreak
inserted into the calculated formula output? No way.

Comment 3 ooo 2002-12-09 15:08:33 UTC

Target to OOo 2.0

Comment 4 ooo 2003-09-12 12:14:57 UTC

Developer notes: later.

Comment 5 oc 2003-09-22 10:39:27 UTC

According to the OpenOffice.org roadmap
(http://tools.openoffice.org/releases) this issue was retargeted to
OOo Later.

Comment 6 aschrage 2003-10-28 10:36:19 UTC

Added ms_interoperability keyword

Comment 7 peschtra 2005-02-06 04:51:42 UTC

In case anyone is still following this, it has not been implemented in 1.9.74.
Not saying it should, but I was here so I thought I would comment.

Comment 8 ooo 2005-02-07 13:48:52 UTC

Peschtra,

This issue was retargeted to OOoLater, which means that it will not go into OOo2.0.

Eike

Comment 9 aschrage 2009-02-28 12:35:16 UTC

Checking this in version 3.0.1 the error is still there.

Comment 10 Marcus 2017-05-20 11:13:52 UTC

Reset assigne to the default "issues@openoffice.apache.org".