[Libreoffice-bugs] [Bug 119509] FILEOPEN wrong column format in ODS but not XLSX

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #9 from Dan Arnfield <dan at arnfield.com> ---
Surely part of this behavior is a bug, though? If the General format is
supposed to result in a date for this formula, shouldn't it display as a date
when explicitly selecting Number Format > General from the menu and not just on
reopening the file?

I can confirm that a formula of the form "=A2-DATE(2018, 6, 26)" results in a
number when formatted as General, both when you select that format and when you
reopen the file.

-- 
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/20180829/afecbe76/attachment.html>