calc: function WEEKNUM seems not to conform to ODFF1.2

Winfried Donkers W.Donkers at dci-electronics.nl
Thu Jun 7 23:15:02 PDT 2012


Hi Eike,
 
> Great we agree :)

Yes, isn't it :)

> Note that UI names may (and sometimes do) differ from ODF file format
> names, the relation is
> UI WEEKNUM     == ODF ISOWEEKNUM
> UI WEEKNUM_ADD == ODF WEEKNUM
> 
> see also formula/source/core/resource/core_resource.src
> Resource RID_STRLIST_FUNCTION_NAMES_ENGLISH_ODFF
>     String SC_OPCODE_WEEK { Text = "ISOWEEKNUM" ; };
> 
> and the sc/source/core/tool/odffmap.cxx entry for WEEKNUM
> 
> The mapping Excel WEEKNUM to WEEKNUM_ADD is taken care of in the
> import/export filters and Analysis Add-In.

Thank you for your explanation, I will start working on it the next couple of days.
You'll hear from me :)

Winfried


More information about the LibreOffice mailing list