Apache OpenOffice (AOO) Bugzilla – Issue 14558
Multiline cells in Calc - How to create them ?
Last modified: 2009-08-05 22:45:00 UTC
********* THE DEFECT ********* It's easy to create multiline cells in Calc, typing some text, then tapping Control-Enter. This is a KEYBOARD entry method. Alas, CALCULATED entry doesn't seem to work. For instance, the following FORMULA ="ABC"&car(10)&"DEF" displays ABC?DEF in the cell, nothing else. Trying to replace car(10) by car(13) or car(31) gives nothing different. ********* THE ENHANCEMENT **** I suggest to change the CAR() function so that CAR(10) or CAR(13) or car(31) work as line separators (these values are unused at present). As a reference, FileMaker Pro can export multiline cells using the CAR(31) character as separator, while Excel seems to use CAR(10)=LF. I fact, the formula ="ABC"&car(10)&"DEF" doesn't work as entry in Excel ne marche pas davantage dans Excel mais but at export the individual lines come separated by a LF. ************** Below in french **************** Dans Calc on peut créer des cellules contenant du texte sur plusieurs lignes, séparant les lignes à l'entrée en appuyant sur Contrôle-Entrée. En revanche on ne peut pas créer ce genre de cellule par formule. Ainsi: ="ABC"&car(10)&"DEF" affiche ABC?DEF et rien d'autre. Et remplacer car(10) par car(13) ou car(31) ne donne rien de mieux. J'aimerais que car(10) ou car(13) ou car(31) soit pris en compte comme séparateur. On peut penser à car(31) parce que c'est effectivement le séparateur qu'on obtient dans les documents texte exportés par FileMaker Pro, mais Excel préfère car(10) (la formule ="ABC"&car(10)&"DEF" ne marche pas davantage dans Excel mais à l'exportation on récupère un caractère LF entre les différentes lignes et ça marche aussi en importation). De fait, Calc perd cette mise en forme à l'exportation vers un fichier CSV, DIF ou SLK, il met une espace à la place du saut de ligne.
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