https://bugs.documentfoundation.org/show_bug.cgi?id=170339
Regina Henschel <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #2 from Regina Henschel <[email protected]> --- There are a lot of reports about WEEKNUM calculations, e.g. bug 112320, bug 139342, bug 139548, bug 162598. If the spreadsheet was exported to *.ods by Excel, we cannot do anything but need to follow the ODF specification. If you think, that the ODF specification needs improvements, please report it to the ODF Technical Committee. If we import an *.xlsx file, we could use the WEEKNUM_EXCEL2003 function. That does not happen currently. This problem is already tracked in bug 168584. It is not clear in the description, which file format is used and whether the file was created from scratch in LibreOffice or created by another application and opened in LibreOffice. Reading the comments in the above listed bug reports, I suggest to close this one as NOTABUG too. If compatibility is necessary, use ISOWEEKNUM, both in Excel and LibreOffice. -- You are receiving this mail because: You are the assignee for the bug.
