Issue 57109 - Text field including newline can't be referenced
Summary: Text field including newline can't be referenced
Status: CLOSED DUPLICATE of issue 30781
Alias: None
Product: Calc
Classification: Application
Component: configuration (show other issues)
Version: OOo 2.0
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-11-01 10:41 UTC by rscarlet
Modified: 2005-12-05 14:38 UTC (History)
1 user (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description rscarlet 2005-11-01 10:41:47 UTC 
Text within a cell can contain a newline (by editing within the cell and using
ctrl-enter). However a reference to such a cell loses the newlines. That is, if
text is entered in $B$3 with a newline, then another cell containing =$B$3 will
not show the newline.

Also, newlines cannot be included within quotes in functions or concatenations.
(Using the explicit newline CHAR(10) also doesn't work.)

By contrast, Excel allows newlines in all cases, using alt-enter. I have a
spreadsheet that constructs a text field with a conditional newline in Excel,
but I can't find any way to imitate such a construct in Calc.
Comment 1 frank 2005-12-05 14:38:12 UTC 
double to Issue 30781 and some others

*** This issue has been marked as a duplicate of 30781 ***
Comment 2 frank 2005-12-05 14:38:43 UTC 
closed double