Issue 30781 - manual line break reference
Summary: manual line break reference
Status: CLOSED DUPLICATE of issue 35913
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 680m41
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: bettina.haberer
QA Contact: issues@sc
URL:
Keywords:
: 45729 55410 57109 77195 81017 (view as issue list)
Depends on:
Blocks:
 
Reported: 2004-06-27 20:11 UTC by bartkramer
Modified: 2008-08-10 17:06 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
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 bartkramer 2004-06-27 20:11:34 UTC 
first I'd like to say that I really like the new option to add manual line
breaks in calc cells. The following problem occured to me when making a
reference to a cell with a line break.

1. I inserted a few lines of text in cell 'A1' with manual line breaks (ctrl+enter)
2. I cell 'A2'I refer to cell 'A1'with formula '=A1'
3. I cell 'A2' the text of cell 'A1' appears without manual line breaks.
Comment 1 frank 2004-06-28 09:07:39 UTC 
Hi,

as we act like Excel do and this is not a defect, I chnaged the Issue type and
send this for evaluation to Bettina.

Frank
Comment 2 john_c 2004-12-09 12:52:17 UTC 
hi,
I take the point that this is not a defect if it isn't in the original design, 
however this does work in excel and there is therefor a compatability issue. I 
opened an excel doc in OOo to find that all the formatting had been lost and so 
the data was unprintable within OOo. my only way round this; to convert all 
formulas to values in excel first. I am particularly interested in the 
concatenate function being able to 'see' line breaks but even the simple '=' 
reference would really help.

john
Comment 3 john_c 2004-12-09 12:53:33 UTC 
hi,
I take the point that this is not a defect if it isn't in the original design, 
however this does work in excel and there is therefore a compatibility issue. I 
opened an excel doc in OOo to find that all the formatting had been lost and so 
the data was unprintable within OOo. my only way round this; to convert all 
formulas to values in excel first. I am particularly interested in the 
concatenate function being able to 'see' line breaks but even the simple '=' 
reference would really help.
Comment 4 frank 2005-10-05 11:07:28 UTC 
*** Issue 55410 has been marked as a duplicate of this issue. ***
Comment 5 frank 2005-12-05 14:37:09 UTC 
*** Issue 45729 has been marked as a duplicate of this issue. ***
Comment 6 frank 2005-12-05 14:38:11 UTC 
*** Issue 57109 has been marked as a duplicate of this issue. ***
Comment 7 frank 2007-05-10 15:54:24 UTC 
*** Issue 77195 has been marked as a duplicate of this issue. ***
Comment 8 Regina Henschel 2007-08-25 11:47:37 UTC 
*** Issue 81017 has been marked as a duplicate of this issue. ***
Comment 9 erack 2008-08-10 17:05:57 UTC 
Please transfer your vote to issue 35913.

*** This issue has been marked as a duplicate of 35913 ***
Comment 10 erack 2008-08-10 17:06:35 UTC 
Closing dup.