RE: Calc/ODFF spreadsheet functions
> Van: Eike Rathke [mailto:er...@redhat.com] > Verzonden: donderdag 24 mei 2012 01:44 > > > >> From the Small Group, all but AVERAGIF are available. I wil keep from AVERAGEIF (and fdo 41214), as communicated in the bug. >From the Medium Group, at least ISOWEEKNUM seems to be missing in calc. I'm still checking the availability of other functions, as I used version 3.5.3 (NL) to compare with and not all function names are present in English (some are in Dutch, even though I set the options to use English function names). Is it OK if I work on ISOWEEKNUM? Winfried ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
Re: Calc/ODFF spreadsheet functions
Hi Winfried, On Wednesday, 2012-05-23 13:14:56 +0200, Winfried Donkers wrote: > > >> From the Small Group, all but AVERAGIF are available. > > > > It is (an other functions) in > > http://hg.services.openoffice.org/cws/calcishmakkica/. But that CWS has not > > been integrated to Apache OpenOffice yet. > > > > If you will use it for LibreOffice, you should ask Apache to get it under > > APL2.0 > > otherwise it is not possible to use it with MPL/LGPLv3+ dual license, which > > is > > intended for LibreOffice. > > You will have to help me (again) on that, either by explaining how to ask > whom for what, or by doing it for me. > It certainly makes it simple to implement these functions. > I could expand fdo41214 to COUNTIF, SUMIFS, AVERGAEIF and AVERAGEIFS and > submit there. All these functions are implemented in CWS calcishmakkica that is not integrated yet. The code was ready and IIRC even QA'ed but didn't make it before feature freeze into OOO340 that was the base for AOO340. We should not duplicate that work (and it was quite some work) but instead have the affected files among the first in the relicensing process. I added a comment to fdo#41214 and the other functions to it's summary. > > Besides missing functions of ODF1.2, there is a lot to do in improving the > > Excel import/export filters. Excel 2010 has a lot of new functions. > > I don't have (access to) Excel 2010, so I can't use that as > reference/source of inspiration, but I guess ODFF1.2 Medium (and > Large) group will keep me busy for a while :) Probably :-) Eike -- LibreOffice Calc developer. Number formatter stricken i18n transpositionizer. GnuPG key 0x293C05FD : 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD pgp61mteoRRjH.pgp Description: PGP signature ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
RE: Calc/ODFF spreadsheet functions
> >> From the Small Group, all but AVERAGIF are available. > > It is (an other functions) in > http://hg.services.openoffice.org/cws/calcishmakkica/. But that CWS has not > been integrated to Apache OpenOffice yet. > > If you will use it for LibreOffice, you should ask Apache to get it under > APL2.0 > otherwise it is not possible to use it with MPL/LGPLv3+ dual license, which is > intended for LibreOffice. You will have to help me (again) on that, either by explaining how to ask whom for what, or by doing it for me. It certainly makes it simple to implement these functions. I could expand fdo41214 to COUNTIF, SUMIFS, AVERGAEIF and AVERAGEIFS and submit there. > Besides missing functions of ODF1.2, there is a lot to do in improving the > Excel import/export filters. Excel 2010 has a lot of new functions. I don't have (access to) Excel 2010, so I can't use that as reference/source of inspiration, but I guess ODFF1.2 Medium (and Large) group will keep me busy for a while :) Winfried ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
Re: Calc/ODFF spreadsheet functions
Hi Winfried, Winfried Donkers schrieb: Just give us a heads-up what you would like to pick so we can get into details. If possible we should focus on functions defined in the Small/Medium/Large sets of ODFF in that order, see http://docs.oasis-open.org/office/v1.2/cs01/OpenDocument-v1.2-cs01- part2.html#__RefHeading__1018916_7159801101 I think we cover all of Small and most of Medium, only a few missing, a double check would be good. From the Small Group, all but AVERAGIF are available. Do you want me to start on this formula? If so, do you have suggestions/warnings/likewise formulas to copy from? There is no bug for it (yet), but fdo41214 mentions that AVERAGEIF should be in AOOo 3.4. It is (an other functions) in http://hg.services.openoffice.org/cws/calcishmakkica/. But that CWS has not been integrated to Apache OpenOffice yet. If you will use it for LibreOffice, you should ask Apache to get it under APL2.0 otherwise it is not possible to use it with MPL/LGPLv3+ dual license, which is intended for LibreOffice. Besides missing functions of ODF1.2, there is a lot to do in improving the Excel import/export filters. Excel 2010 has a lot of new functions. Kind regards Regina ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
RE: Calc/ODFF spreadsheet functions (was: [PUSHED][PATCH] fdo#44456 added calc function DATEDIF as in ODF 1.2)
> Just give us a heads-up what you > would like to pick so we can get into details. If possible we should > focus on functions defined in the Small/Medium/Large sets of ODFF in > that order, see > http://docs.oasis-open.org/office/v1.2/cs01/OpenDocument-v1.2-cs01- > part2.html#__RefHeading__1018916_7159801101 > > I think we cover all of Small and most of Medium, only a few missing, > a double check would be good. >From the Small Group, all but AVERAGIF are available. Do you want me to start on this formula? If so, do you have suggestions/warnings/likewise formulas to copy from? There is no bug for it (yet), but fdo41214 mentions that AVERAGEIF should be in AOOo 3.4. Winfried ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
RE: Calc/ODFF spreadsheet functions (was: [PUSHED][PATCH] fdo#44456 added calc function DATEDIF as in ODF 1.2)
> > Also, coukld this page be a source for me to add more formulas that are in > ODF1.2 and not yet in calc? > > Yes, it should be pretty up-to-date. Just give us a heads-up what you would > like to pick so we can get into details. If possible we should focus on > functions > defined in the Small/Medium/Large sets of ODFF in that order, see > http://docs.oasis-open.org/office/v1.2/cs01/OpenDocument-v1.2-cs01- > part2.html#__RefHeading__1018916_7159801101 > > I think we cover all of Small and most of Medium, only a few missing, a > double check would be good. Opologies for the late reply, I have been absent for some time. Thank you, I will give you a message with the function(s) I intend to work on. Winfried ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
Re: Calc/ODFF spreadsheet functions
On 22/05/12 11:02, Eike Rathke wrote: > Hi Regina, > > On Tuesday, 2012-05-22 08:19:13 +0200, Regina Henschel wrote: > I don't see any LibreOffice comments, would this (DATEDIF) be the first one? >>> >>> Yes, indeed, this would be an interesting precedence case.. it's >>> probably better to setup our own page for this. >> >> I'm not sure about that. It means to double the work and makes >> information scattered. > > That's indeed a good argument against duplication, especially because > you are working on both projects. Ok, let's see if we can peacefully > coexist on that page. yes, why not try that approach (we can always copy the page once the usual suspects start complaining that we are polluting the sacred Apache-owned Wiki with evil LibreOffice propaganda...) ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
Re: Calc/ODFF spreadsheet functions
Hi Regina, On Tuesday, 2012-05-22 08:19:13 +0200, Regina Henschel wrote: > >>I don't see any LibreOffice comments, would this (DATEDIF) be the first one? > > > >Yes, indeed, this would be an interesting precedence case.. it's > >probably better to setup our own page for this. > > I'm not sure about that. It means to double the work and makes > information scattered. That's indeed a good argument against duplication, especially because you are working on both projects. Ok, let's see if we can peacefully coexist on that page. > Also Wolfgang's BIT* > >functions are in LibO, so would need to be flagged as integrated, same > >with Regina's CSC/SEC functions. > > Yes, I haven't update the Wiki. But it is a Wiki and in no way _my_ > page. So you can alter it as needed. Heh :-) That wasn't meant as "you didn't update the page", I was just gathering status. Eike -- LibreOffice Calc developer. Number formatter stricken i18n transpositionizer. GnuPG key 0x293C05FD : 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD pgp6n5KNPrdYl.pgp Description: PGP signature ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
Re: Calc/ODFF spreadsheet functions
Hi, Eike Rathke schrieb: Hi, On Wednesday, 2012-05-16 09:28:16 +0200, Winfried Donkers wrote: Ehh.. I'm not familiar with adding content to (wiki/web) pages. And anyway, Eike deserves at least as much credit for this patch. I've no problem with being not explicitly mentioned, but add me if you think I deserve it ;-) I don't see any LibreOffice comments, would this (DATEDIF) be the first one? Yes, indeed, this would be an interesting precedence case.. it's probably better to setup our own page for this. I'm not sure about that. It means to double the work and makes information scattered. Also Wolfgang's BIT* functions are in LibO, so would need to be flagged as integrated, same with Regina's CSC/SEC functions. Yes, I haven't update the Wiki. But it is a Wiki and in no way _my_ page. So you can alter it as needed. @Regina: As all significant work on that OOo wiki page is your's, would you be willing to contribute it in its entirety to the TDF/LibO wiki? If you want to copy the content, you may do it. But I see no necessity. Btw, seeing your work on IMSEC and such is lingering as a patch attached to https://issues.apache.org/ooo/show_bug.cgi?id=111609 what's the state of the patch? Would it be ready to be integrated? And if so, would you contribute it? Oh, that is two years old and I've lost sight of it. As far as I remember, the mathematics are right, but there have been some problems with xls and sxc file format, import/export and round trips. Some problems are mentioned in http://www.mail-archive.com/dev@sc.openoffice.org/msg02387.html, for example. And the parts for the help are missing too. So no, that is not ready to integrate. From point of license I prefer to get it under APL2.0 license too, otherwise an integration to AOO will be difficult. Differences in UI for AOO and LO are OK, but things which are close to ODF file format and touch import/export filters should be exchangeable. Also, coukld this page be a source for me to add more formulas that are in ODF1.2 and not yet in calc? Yes, it should be pretty up-to-date. Just give us a heads-up what you would like to pick so we can get into details. If possible we should focus on functions defined in the Small/Medium/Large sets of ODFF in that order, see http://docs.oasis-open.org/office/v1.2/cs01/OpenDocument-v1.2-cs01-part2.html#__RefHeading__1018916_7159801101 I think we cover all of Small and most of Medium, only a few missing, a double check would be good. Kind regards Regina ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice