[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

--- Comment #8 from Mike Kaganski <mikekaganski at hotmail.com> ---
The behaviour is documented, e.g., here:
https://help.libreoffice.org/Calc/Error_Codes_in_Calc - the very first row. ###
never means other errors: if it is shown, it always means that what is to be
shown doesn't fit. It may happen that an error message doesn't fit; then - yes,
there would be ### there, to show the same: show string doesn't fit.

You also may select the cell and look at the status bar, where the error would
be explained (if there is an error), or the cell value (or sum, or average,
etc.) would be shown for normal cells (like in this case).

Wrt strings - well, for a string, it's enough to show a red triangle meaning
that there's something left; but for a number, any part of a number doesn't
make sense by itself.

-- 
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/20180325/cda845bf/attachment.html>