> in Calc is function EFFECT_ADD converted after save and reopen into function > EFFECTIVE. But ODF define function with name EFFECT. > For me it looks like EFFECTIVE should have name EFFECT or function EFFECT > should be added for compatibility with ODF? The UI name EFFECTIVE is the same function as EFFECT defined in ODFF or OOXML, it just has a different name, which IMHO is and was always wrong/unnecessary. In fact there's a bug in OOXML import/export where we also write and expect EFFECTIVE instead of EFFECT. I'll fix that independently for current releases.
OOXML import/export fixed in master with https://gerrit.libreoffice.org/gitweb?p=core.git;a=commitdiff;h=ed5bcef57b678cb92c68bf842a72e50f4dd1e2ea https://gerrit.libreoffice.org/gitweb?p=core.git;a=commitdiff;h=f3f89f4f3180b0fd63c5290c665894c6a27f2ae2 In 5-2 with https://gerrit.libreoffice.org/gitweb?p=core.git;a=commitdiff;h=087b0b88dbbfa297d2f3d47e4e7ea7e02dfff4f0 Pending review https://gerrit.libreoffice.org/26704 for 5-1
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=48f018ea9bb94be0d1485fd2a02957bad962976c tdf#100641 change UI name of EFFECTIVE to EFFECT It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://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 "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d480e5c7f68d61cf51c233f62c07293f212b9f4a rename *effective to *effect, tdf#100641 related It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://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 "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=2795cb694b6563772e1326b74cfd678ed251681f add an isPODF() block to ScCompiler::IsOpCode(), tdf#100641 related It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://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-5-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=4c6685a93cc4b82d2a9300f9a4fd64c5c54fb568&h=libreoffice-5-1 tdf#100641 correct OOXML function name is EFFECT instead of EFFECTIVE It will be available in 5.1.5. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
verified.Version: 5.3.0.0.alpha0+ Build ID: a2c557d80ac68c06ea59586245a7431e061938f0 CPU Threads: 4; OS Version: Linux 4.4; UI Render: default; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2016-07-15_23:35:01