<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Formated number and date calc cell formats don't respect automatic cell wrap"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=109119">109119</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Formated number and date calc cell formats don't respect automatic cell wrap
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>4.1.6.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>glogow@fbihome.de
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=134627" name="attach_134627" title="Example document with first cell not wrapped">attachment 134627</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=134627&action=edit" title="Example document with first cell not wrapped">[details]</a></span>
Example document with first cell not wrapped
Calc can set the alignment option for formated cells to "Wrap cells
automatically" (Alignment _> properties).
I was told one of the first fixes for LO Calc was to prevent breaking of date
and number values, ignoring the format and the "wrap cells" setting, but I
couldn't find any reasoning.
I also know AOO - at some point - prevented to break the actual numbers / dates
values, which I could also not understand, but this probably improves
visibility. There is also <a href="https://bz.apache.org/ooo/show_bug.cgi?id=111387">https://bz.apache.org/ooo/show_bug.cgi?id=111387</a>, but
this just prevents breaking of numbers, if they use the autodecimal feature.
But in the case of a number formated as a string with spaces, this doesn't make
much of a sense and is actually counter-intuitive, especially since the "Wrap
cells automatically" defaults to off.
The attached document has user defined format code of "nächste Besprechung:
"DD.MM.YY. In AOO 4.1.0 the cell is line wrapped after the column resulting in
a two line cell. LO just displays ###. BTW: "Wrap cells automatically" is
selected.
Now there is a crazy workaround, probably due to some inconsistency: set the
alignment of the cell to justification, but this doesn't help with existing
documents.
I was told this is "expected" behaviour for number and date formated cells.
BTW: unicode has actually NO-BREAK SPACE
(<a href="http://www.fileformat.info/info/unicode/char/00a0/index.htm">http://www.fileformat.info/info/unicode/char/00a0/index.htm</a>), which is not
regarded as a whitespace, and so prevents a line break, but I guess it's too
late to use this for all the old formattings.
I probably missed the documentation, but at least there was no information in
the online doc for the "Wrap cells automatically" feature.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>