Issue 83666 - Line breaks in strings sometimes treated as spaces
Summary: Line breaks in strings sometimes treated as spaces
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on: 35913
Blocks:
  Show dependency tree
 
Reported: 2007-11-15 15:05 UTC by huw
Modified: 2013-08-07 15:14 UTC (History)
2 users (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 huw 2007-11-15 15:05:56 UTC 
Line breaks in some strings are treated as spaces.

Consider:
A1 contains two three letter words seperated by a soft line break - Ctrl+Enter. 
(It is displayed as a two line cell, and as two words seperated by a space in 
the input line - Issue 13870).
=CODE(MID(A1;4;1)) returns 32 instead of the expected 10

Yet if A2 contains =LEFT(A1;3)&char(10)&RIGHT(A1;3)
=CODE(MID(A2;4;1)) returns 10 as expected

and if A3 contains the same two words as A1, but seperated by a space instead 
of a soft line break
=EXACT(A1;A3) returns TRUE instead of the expected FALSE
Comment 1 frank 2007-11-16 11:46:20 UTC 
Hi Niklas,

the problem is just that the first output isn't correct. We should give the same
result as Excel do. 10 for the first formula and FALSE for the last one.

Frank
Comment 2 huw 2008-04-08 11:30:15 UTC 
Edit - I mean hard line break (Ctrl+Enter) not soft.
Comment 3 wsfulton 2008-07-30 15:10:52 UTC 
The patch in #35913 also fixes this bug.
Comment 4 ooo 2009-03-10 18:43:07 UTC 
Grabbing.
Comment 5 ooo 2009-03-10 18:43:53 UTC 
Fixed with issue 35913 in cws calcmultiline.
Comment 6 ooo 2009-03-12 15:44:00 UTC 
Reassigning to QA for verification.
Comment 7 oc 2009-04-24 10:26:12 UTC 
verified in internal build cws_calcmultiline
Comment 8 amy2008 2009-06-05 07:55:20 UTC 
Verified in DEV300m49 on WinXP
Closing