Example: Set Language settings to English UK. Enter 07/02/2011 (7th February) as the date in cell A1 Set A2 as =weeknum(A1,1) Set A3 as =A1 and format cell as WW A2 returns 6 A3 returns 7 Cell A2 (value 6) is correct for the UK. Cell A3 has the correct value for the US but incorrect for the UK. Expected: it should return the same value for both when language settings are English UK.
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian
This bug still exists in LibreOffice 3.5.4.2
At least I can confirm the Locale related difference in various LibO Versions like with parallel installation of Master "LOdev 3.7.0.0.alpha0+ - WIN7 Home Premium (64bit) ENGLISH UI [Build ID: 7d8cd0a]" (tinderbox: 2008R2@20, pull time 2012-08-10 23:27:17) But I can't tell whether the problem really is a bug. I see in an example similar to reporter's: 07/04/97 15 15 (that's OK) 07/04/98 14 15 (that's NOT OK, the problem appears 1998) With German locale I see for reporter's sample: 07.02.11 6 6 but 04.07.98 26 27 Currently I can't tell whether that really is a bug. May be =Weeknum() uses an other week counting scheme that a localized formatting WW? @Eike: Can you bring some light into the dark? @seumas: Why do you think this is a bug? Can you cite some Help, norms, ...? Only "unexpected" does not make a bug.
Well, I would have have thought that asking for the week number and getting two different answers, depending on where you asked, would obviously be a bug! :) weeknum() is the one returning the correct value. The WW formatting seems to have different code (why?! - surely it should basically be applying a formula to itself?) and gives what appears to the the USA calculation for week number. Under the Europe/ISO standard, the first week of the year is the week that has the first Thursday of the year. Under the US standard, the first week of the year is the week that has the first of January (or something; I don't know the exact calculation). That's why some years they match up and some years they don't. But it's not like it requires any new code: weeknum() gets it right! Just make sure that WW is using the correct weeknum() code, yes?
@seumas: Sounds plausible @Eike, András: I did a quick test in a WRITER table, also delivers Week 7 inserting "07/02/11" with 'Locale settin = English UK' (others not tested). That problem seems to related to reporter's.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (4.3.5 or later): https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) Thank you for your help! -- The LibreOffice QA Team
Bug still exists exactly as previously described.
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.