<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED DUPLICATE - Formated number and date calc cell formats don't respect automatic cell wrap"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=109119">bug 109119</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>NEW
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>DUPLICATE
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED DUPLICATE - Formated number and date calc cell formats don't respect automatic cell wrap"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=109119#c2">Comment # 2</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED DUPLICATE - Formated number and date calc cell formats don't respect automatic cell wrap"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=109119">bug 109119</a>
from <span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span></b>
<pre>Consider user defined formats like
[$$-409]_ _-_ 0.00;[$$-409] - 0.00
You do not want to line break the display anywhere, even worse if the row
height is not tall enough to display excess lines.
We could replace all unquoted spaces with NBSP to prevent breaks at those
positions, but that would have to be done for all number (not date) format
codes including those read from file formats. That still does not solve the
problem that row heights may not be sufficient to display subsequent lines for
date format codes that do use normal spaces.
A far better approach IMHO is to automatically widen the column after input
(only!) if it is too narrow and was not yet set to a fixed width by the user.
Which also Gnumeric and Excel do.
Both also do not wrap numeric and date display strings if wrap is enabled, so
we'd display significantly different content if we implemented wrapping here.
*** This bug has been marked as a duplicate of <a class="bz_bug_link
bz_status_NEW "
title="NEW - FORMATTING Request for wrapping long Date and Time formats"
href="show_bug.cgi?id=40685">bug 40685</a> ***</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>