https://bugs.documentfoundation.org/show_bug.cgi?id=116106
Eike Rathke <[email protected]> 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 <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
