Apache OpenOffice (AOO) Bugzilla – Issue 111478
The usage of the Formular =Days360 (in German: =Tage360) seems to be changed
Last modified: 2013-01-29 21:48:27 UTC
Documents with =TAGE360("01.02.2010";Now()) doesn't work any more. Workaround: =TAGE360(DATWERT("01.02.2010");Now()) works fine. But the (german) helpfile tell you, you can use it as sample 1 above shows you.
DAYS() and WEEKDAY are also affected: DAYS(): same as DAYS360() WEEKDAY(Number; Type): Number: the internal number for the date but helps says, for example: =WEEKDAY("2000-06-14") btw: in OO 1.1.5 =WEEKDAY("2000-06-14") worked ...
Hi, I am not sure there is a bug here. I think you are experienced this change : http://tools.services.openoffice.org/EIS2/changesmails.EditFeature?Id=4526 In OOo 3.2.1 RC1 FR =JOURSEM("2010-05-13") works fine (JOURSEM = WEEKDAY) and =JOURS360("2009-05-13";MAINTENANT()) too but =JOURS360("13/05/2009";MAINTENANT()) give #VALUE! which is correct because "13/05/2009" is not ISO 8601. Regards. JBF
May it's correct, that =JOURS360("13/05/2009";MAINTENANT()) or =TAGE360("01.02.2010";Now()) isn't ISO conform. But till Openoffice Version 3.1 this works AND the german helpfile show's exact this as example! So if there is a new definition of the date-functions, then the help file is incorrect and existing tables get errors! Regards Vohe