[Libreoffice-bugs] [Bug 116106] FORMATTING: LO Calc Date as Number lost in saving

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Priority|medium                      |low
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1
                 OS|Linux (All)                 |All
           Severity|normal                      |minor

--- Comment #1 from Eike Rathke <erack at redhat.com> ---
If a cell has the General format and a formula expression yields a date or time
or boolean result then a corresponding number format of type Date or Time or
Boolean is assigned to that cell. Format General effectively means no specific
format applied.

Deriving a format on recalculation after load is done because Calc does not
know whether the General format is carried over from an older version saved
document where these formula result formats where not applied but recalculated
on the fly each time the formula was calculated, which led to other problems..

I'm not sure if this situation can be solved at all other than doing hacks
depending on the version with which a document was saved, which is quite
ill-advised.

Best if you want to force a numeric format in any case then assign a format of
type Number other than General, for example 0 for date serial numbers.

-- 
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/20180301/ffcdf3fd/attachment-0001.html>