Hi Eike,
The correct place would be a duplicate of saFuncTableOdf[], say
saFuncTableOOoLO[], just to keep things cleanly separated because the
functions are only known to LO and not defined in OpenFormula. The
saFuncTableOOoLO also needs to be added to
FunctionProviderImpl::FunctionProviderImpl() after the init of
saFuncTableOdf.
...
If I understand you correctly, WEEKS in an ods should translate to 'org.openoffice.weeks' when
saving tp xlsx, which should be translated to WEEKS when saving to ods. Am I correct?
Yes. Respectively use uppercase ORG.OPENOFFICE.WEEKS for .xlsx; setting
the table up like described should solve things.
I don't seem to get anywhere for some reason.
The behaviour as described in the february-comments in bug 59727 could be reproduced with version
4.0.0, but can't be reproduced with version 4.0.3 or master. It can be reproduced with version 3.6
(openSUSE).
On master the behaviour with or without patched code (saFuncTableOOoLO added including addition to
FunctionProviderImpl::FunctionProviderImpl()) is the same: in a reopened xlsx file the add-in
function is shown as com.sum.star.sheet.addin.datefunctions.getdiffweeks(...).
Not having Excel (don't want to) nor having experience with building other versions than master, I
don't know how to proceed.
I can send the diff to gerrit marked as WIP, but the code is straightforward, I've only added
WEEKS, MONTHS YEARS to test with.
Winfried
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.