Apache OpenOffice (AOO) Bugzilla – Issue 5250
Manual line break in cell breaks formula
Last modified: 2017-05-20 11:13:52 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.
Hi, reproduced. Excel disregards the manual linebreak. But I think it would be even nicer to use it as formatting feature. Best regards, Peter
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.
Target to OOo 2.0
Developer notes: later.
According to the OpenOffice.org roadmap (http://tools.openoffice.org/releases) this issue was retargeted to OOo Later.
Added ms_interoperability keyword
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.
Peschtra, This issue was retargeted to OOoLater, which means that it will not go into OOo2.0. Eike
Checking this in version 3.0.1 the error is still there.
Reset assigne to the default "issues@openoffice.apache.org".