Apache OpenOffice (AOO) Bugzilla – Issue 124051
remove insert: formating mark: non-breaking space from calc
Last modified: 2014-01-19 13:45:12 UTC
in calc one can insert non-breaking spaces (insert -> formating -> non-breaking space) it even saves the non-breaking space in the ods-file (hex C2A0) but calc doesn't support it, so the user inserts it and wonders why it wont work. maybe he finally reads the help: "In Calc, you cannot insert non-breaking spaces." *gr*
?? For me this feature works in Calc and it should nothing be removed. Type a text into the cell, were you put a non-breaking space between e.g. number and unit, for example "This texts has 3 cm column width." Set the cell to automatically wrap. Change the column width so that "3" would be on one line and "cm" on the next line. Notice, that the whole part "3 cm" is moved to the next line. Repeat the same with an ordinary space between "3" and "cm". Notice, that "3" is in one line and "cm" goes to the next line.
(In reply to Regina Henschel from comment #1) > ?? For me this feature works in Calc and it should nothing be removed. > > Type a text into the cell, were you put a non-breaking space between e.g. > number and unit, for example "This texts has 3 cm column width." Set the > cell to automatically wrap. Change the column width so that "3" would be on > one line and "cm" on the next line. Notice, that the whole part "3 cm" is > moved to the next line. > Repeat the same with an ordinary space between "3" and "cm". Notice, that > "3" is in one line and "cm" goes to the next line. well I tried it with "1000 kg" and calc always wraps the 1000 in one and kg in the next line. I expected the text to be cut and the cell to small indicators to be shown like when you decrease the width further. but I confirm it works with your example
1000 kg works, but help section needs to be corrected. AOO410m1(Build:9750) - Rev. 1557669 2014-01-14_04:11:13 - Rev. 1557927 Debian