https://bugs.freedesktop.org/show_bug.cgi?id=50950
Bug #: 50950
Summary: modify calc functions WEEKNUM, WEEKNUM_ADD to comply
with ODFF1.2
Classification: Unclassified
Product: LibreOffice
Version: LibO Master
Platform: Other
OS/Version: All
Status: NEW
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
The current UI functions WEEKNUM and WEEKNUM_ADD dor not strictly comply with
ODFF1.2 functions ISOWEEKNUM and WEEKNUM respectively.
I plan to correct this as suggested by Eike) by:
1 enhance UI WEEKNUM_ADD to support all ODF WEEKNUM modes
2 in the UI rename WEEKNUM to ISOWEEKNUM
3 change ISOWEEKNUM to accept only one parameter
4 during import's formula compile step for ISOWEEKNUM check if a second
argument is provided
a if so and if it is a constant value !=1 strip the argument (the
Monday case that was and is real ISO 8601)
b if it is a constant value ==1 map the function to WEEKNUM
* there's a slight chance that a user wanted exactly the behavior
"ISO but Sunday" resulting from the current undocumented
implementation details, which isn't supported by ODF WEEKNUM
definition, but I think that should be a very rare case, if at
all, and is neglectable
c if it is not a constant (i.e. computed) argument do nothing and let
the interpreter complain about the second parameter
A possible fifth step could be to rename UI WEEKNUM_ADD to WEEKNUM, with the
result that UI and ODF use the same function names.
This bug is a sub-bug of bug 50488
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
