[Libreoffice-bugs] [Bug 109119] Formated number and date calc cell formats don' t respect automatic cell wrap

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Jul 14 14:28:28 UTC 2017


https://bugs.documentfoundation.org/show_bug.cgi?id=109119

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |DUPLICATE

--- Comment #2 from Eike Rathke <erack at redhat.com> ---
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 bug 40685 ***

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170714/ca325024/attachment-0001.html>


More information about the Libreoffice-bugs mailing list