With ODF 1.4 the function EASTERSUNDAY becomes an ordinary, standardized function. This is tracked in OASIS in issue https://issues.oasis-open.org/browse/OFFICE-3851 LibreOffice needs to be adapted in some places. Tasks: The import needs to be changed to accept of:=EASTERSUNDAY in addition to of:=ORG.OPENOFFICE:EASTERSUNDAY. That change should be done to all active LibreOffice versions and on master. The export has to be changed to write of:=EASTERSUNDAY in case of save to ODF 1.4. That has to be done on master. Unit tests for import and export. The documentation in https://wiki.documentfoundation.org/Documentation/Calc_Functions/EASTERSUNDAY needs an update in section 'ODF standard' with remark 'since ODF 1.4'. I think this is an easyHack because only filters are affected and there exist a lot of examples in the code how to consider the ODF version.
(In reply to Regina Henschel from comment #0) > With ODF 1.4 the function EASTERSUNDAY becomes an ordinary, standardized > function. > This is tracked in OASIS in issue... https://issues.oasis-open.org/browse/OFFICE-2164
I will like to work on this but I can't seem to uderstand what the bug description is about and I couln't figure out possible code pointers.
I had suggested this as easyHack, but I was wrong. Writing EASTERSUNDAY instead of ORG.OFFICE.EASTERSUNDAY is controlled by the entries in formula/inc/core_resource.hrc and sc/source/core/too/compiler.cxx around line 2963 The file 'formula/source/core/resource/core_resource.src' mentioned in the comment is in the meantime the file 'formula/inc/core_resource.hrc. From the comments in both files I guess EASTERSUNDAY and ORG.OFFICE.EASTERSUNDAY have to be exchanged in these lists. Older versions of LibreOffice are able to read EASTERSUNDAY, because that was used in OpenOffice 1.0. But I see no way how to write ORG.OFFICE.EASTERSUNDAY in case of ODF 1.3 and pure EASTERSUNDAY in case of ODF 1.4. BTW, validation against the rng does not detect, that EASTERSUNDAY does not belong to ODF 1.3 because the datatype for the table:formula attribute is 'String'.
Regina Henschel committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/c377e211785c799a56cd72a9ecba9611d5993311 tdf#162177 Adapt function EASTERSUNDAY to ODF 1.4 It will be available in 25.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
I had tried to get a review from Eike, but he had not respond. I have submitted it now. In case the approach is wrong, we can revert it.
Sorry, I'm not much active lately. The change looks ok to me. I'll submit a follow-up change to treat the function name mapping in sc/source/filter/oox/formulabase.cxx
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/f91f3484bbac46ed762bf9ff356b690224e20096 Excel im-/export function name mapping for EASTERSUNDAY, tdf#162177 follow-up It will be available in 25.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-25-2": https://git.libreoffice.org/core/commit/5545a3d22f152e628f7ad9969af87b34e55b5fe4 Excel im-/export function name mapping for EASTERSUNDAY, tdf#162177 follow-up It will be available in 25.2.0.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.