Issue 5250 - Manual line break in cell breaks formula
Summary: Manual line break in cell breaks formula
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.0.0
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: ms_interoperability, oooqa
Depends on:
Reported: 2002-05-24 14:14 UTC by aschrage
Modified: 2017-05-20 11:13 UTC (History)
1 user (show)

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


Note You need to log in before you can comment on or make changes to this issue.
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 
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
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 roadmap
( 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

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

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