https://bugs.documentfoundation.org/show_bug.cgi?id=168584
Bug ID: 168584
Summary: Excel's WEEKNUM is imported as ODF WEEKNUM, instead of
WEEKNUM_EXCEL2003
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: filter:xlsx
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 203001
--> https://bugs.documentfoundation.org/attachment.cgi?id=203001&action=edit
An Excel 2016 generated WEEKNUM sample
Open the attached XLSX. It was created in Excel 2016; it is expected to show
the data as in Excel (at least when using en-US locale, which was used in Excel
when creating it).
In Calc, it imports as WEEKNUM; and that is the ODF WEEKNUM [1], which differs
in behavior in the last days of the year, which may be the same actual week as
the next year's Jan 1, but in Excel, these last days are numbered 53 - compare
columns C and D, which are plain numbers demonstrating what I see in column B
on my system.
There is WEEKNUM_EXCEL2003 [2], which is described as "for interoperability
with legacy documents created with older versions of Microsoft Excel", and
which calculates as expected (a separate issue is WEEKNUM_EXCEL2003 doesn't
allow missing second argument). However, it seems that newer Excel versions
still use that version, so the import should produce WEEKNUM_EXCEL2003 in the
document.
Another related issue is that WEEKNUM_EXCEL2003 isn't stored to ODS, but that's
for a different bug report.
[1]
https://docs.oasis-open.org/office/OpenDocument/v1.4/OpenDocument-v1.4-part4-formula.html#WEEKNUM
[2]
https://wiki.documentfoundation.org/Documentation/Calc_Functions/WEEKNUM_EXCEL2003
--
You are receiving this mail because:
You are the assignee for the bug.
