Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Multiline cells in Calc - How to create them ? | ||
---|---|---|---|
Product: | Calc | Reporter: | rcabane <rcoo> |
Component: | code | Assignee: | bettina.haberer |
Status: | CLOSED FIXED | QA Contact: | issues@sc <issues> |
Severity: | Trivial | ||
Priority: | P3 | CC: | issues |
Version: | OOo 1.0.1 | ||
Target Milestone: | --- | ||
Hardware: | All | ||
OS: | All | ||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
rcabane
2003-05-17 07:53:52 UTC
This formula is broken in 1.1Beta1 (Win2k) ="ABC"&car(10)&"DEF" returns #NAME? ="ABC"&"DEF" returns ABCDEF Of course I'm using the french character CAR() function. I suppose that on english versions (like 1.1b at present) that function is CHAR(). Please check this; "12"&CHAR(65)&"34" shoud give you "12A34". Yes it works with CHAR <crying> Why did the dev team translate intrinsec functions ? See MS experience in 95/96 with excel 5.0 and VBA </crying> Laurent Hi Bettina, one4you Please have a look to issues #13497 and #14649: http://www.openoffice.org/issues/show_bug.cgi?id=13497 http://www.openoffice.org/issues/show_bug.cgi?id=14649 The present problem is quite different but might receive a similar solution, asking the user how to code the line break. CAN REPRODUCE with Win NT/2000/XP OS and 1.1.4 / 1.9.128 release CAN REPRODUCE with Win Linux Debian OS and 1.1.4 / 1.9.125 release The bug still exists in 3.0 beta 2. The patch in <a href="http://www.openoffice.org/issues/show_bug.cgi?id=35913">Issue 35913</a> also fixes this bug. I agree with the previous comment, the patch against http://www.openoffice.org/issues/show_bug.cgi?id=35913 is a good solution. Please close this issue. The following issue http://www.openoffice.org/issues/show_bug.cgi?id=35913 solves the referred problem. Thanks. I set to fixed as the reporter tells -< closed |