[Libreoffice-bugs] [Bug 112320] FILEOPEN: WEEKNUM in an XLSX gives different result than in Excel

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Sep 13 05:53:33 UTC 2017


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

--- Comment #5 from Winfried Donkers <winfrieddonkers at libreoffice.org> ---
(In reply to Mike Kaganski from comment #0)
> When opening attachment 113150 [details] from bug 89139, the WEEK column on
> Dati sheet shows 1 for cells D727:D730, while in Excel, these give 53. If
> the function WEEKNUM in these cells is replaced with WEEKNUM_EXCEL2003, then
> the result is as expected.

@Mike: Can you tell me which version of Excel you used?

-- 
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/20170913/fd764471/attachment.html>


More information about the Libreoffice-bugs mailing list