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

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 109119
           Summary: Formated number and date calc cell formats don't
                    respect automatic cell wrap
           Product: LibreOffice
           Version: 4.1.6.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: glogow at fbihome.de

Created attachment 134627
  --> https://bugs.documentfoundation.org/attachment.cgi?id=134627&action=edit
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 https://bz.apache.org/ooo/show_bug.cgi?id=111387, 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
(http://www.fileformat.info/info/unicode/char/00a0/index.htm), 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.

-- 
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/3b5bbd01/attachment-0001.html>