https://bugs.documentfoundation.org/show_bug.cgi?id=156766
Bug ID: 156766
Summary: Complex formula with WEEKNUM result restarts after
31st week of year
Product: LibreOffice
Version: 3.6.0.4 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 108253
Created attachment 188964
--> https://bugs.documentfoundation.org/attachment.cgi?id=188964&action=edit
Example file from LO master
Attached user made (saved as ods from an Excel file by LO) file contains some
complex formula, mainly building on the WEEKNUM function.
The expectation is that in every fifth column the number of the week is
calculated next to the Monday cell of a week.
This works fine until the formula result is not greater than 31, but after that
it restarts at 1 instead of continuing with 32... until 52.
1. Open attached file
2. Notice the calculated week numbers in column AC of the first sheet
-> In AC17 the result is 1 instead of 32
Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 218a7650a5cf03f895bed19c68d6f02daec536e9
CPU threads: 15; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: threaded
and back until 3.6. In 3.5 however the numbering did not restart, although it
did not give the same results as today either - calculated results were larger
by 1.
Which interestingly is pretty similar how Excel 2016 calculates using the same
ods file.
Bibisect with linux-4.3all got this range, but nothing sticks out to me:
https://cgit.freedesktop.org/libreoffice/core/log/?qt=range&q=73202f8edc074ec035255d25ff29bfd4a8d8dfd6..6b11a18071254a443c8fe7e7b0b1c95b0f9fd35e
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=108253
[Bug 108253] [META] Calc cell formula bugs and enhancements
--
You are receiving this mail because:
You are the assignee for the bug.
