[Libreoffice-bugs] [Bug 116591] Negative Time shows as ### when opening xlsx file

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #6 from Mike Kaganski <mikekaganski at hotmail.com> ---
The file is OK; but possibly there's some slight change in text/cell width
calculation that makes the "-16:05" to not fit to the cell. Just make the cell
slightly wider.

Generally it's impossible to achieve ideal fidelity up to single pixel, e.g.
because OOXML and ODF use different length units, and thus riunding errors may
lead up to two smaller units difference; so it is advisable to not try to make
cells as narrow as possible, without any extra space, because it would
eventually lead to such problems (with new versions of fonts/software/even OS).

See http://youtu.be/Q8YiYw9TtEg?hd=1 for the screencast with Version: 6.0.3.1
(x64)
Build ID: 62abb169b0efa1520d7bee1f586865354060b989
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: ru-RU (ru_RU); Calc: CL.

I will close the issue as NOTABUG. If you find an evidence of really wrong
width calculations, please reopen as UNCONFIRMED with explanation and test
case.

-- 
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/20180324/23795fd3/attachment.html>