Re: [libreoffice-users] I want to add formulas and functions to calc
Hi :) So, a good oppotunity to get ahead of the game then. I guess there are add-on packages or something for MS Office that might not be so easy to find as our extensions website? Regards from Tom :) --- On Sun, 23/10/11, Brian Barker b.m.bar...@btinternet.com wrote: From: Brian Barker b.m.bar...@btinternet.com Subject: Re: [libreoffice-users] I want to add formulas and functions to calc To: users@global.libreoffice.org Date: Sunday, 23 October, 2011, 14:56 At 09:36 23/10/2011 -0400, Alberto Sanchez wrote: On Sun, Oct 23, 2011 at 6:50 AM, Regina Henschel rb.hensc...@t-online.dewrote: Alberto Sanchez schrieb: I'm a finance major so I use excel a lot, but I don't have the money for it so I use calc. I see that there's is a lot of financial formulas that are missing but that excel has, so my question is, how can I add that function so that many others in my position can benefit from them? I don't believe that there are a lot of financial formula that Excel has but Calc not, please name them. If they are listed in ODF1.2, they should be added to the core. I will name them, the ones on my mind now is PVIF and FVIF. they are quite easy. I would also add ones that are not in excel but we could beat excel at that. we could have the most comprehensive group of formulas and functions. For what it's worth, these two functions do not appear to exist in Excel, in fact. At least, as evidenced by their web site, Microsoft seem to have no knowledge of them! Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] I want to add formulas and functions to calc
Hi, Am 23.10.2011 04:35, schrieb Alberto Sanchez: Is there a way that the community can benefit from this? so my question is, how can I add that function so that many others in my position can benefit from them? Make an Extension and put into the Extensions Repository. http://www.libreoffice.org/features/extensions/ http://extensions-test.libreoffice.org/ If you do not know how to create an extension and if you do not want to learn it (which isn´t difficult), you could post the Code and a description of your new function and hope that some other old man will pick it up and create and publish it as an extension. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] I want to add formulas and functions to calc
Hi Alberto, Alberto Sanchez schrieb: Hi all, I'm a finance major so I use excel a lot, but I don't have the money for it so I use calc. I see that there's is a lot of financial formulas that are missing but that excel has, so my question is, how can I add that function so that many others in my position can benefit from them? I don't believe that there are a lot of financial formula that Excel has but Calc not, please name them. If they are listed in ODF1.2, they should be added to the core. Kind regards Regina -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] I want to add formulas and functions to calc
I will name them, the ones on my mind now is PVIF and FVIF. they are quite easy. I would also add ones that are not in excel but we could beat excel at that. we could have the most comprehensive group of formulas and functions. On Sun, Oct 23, 2011 at 6:50 AM, Regina Henschel rb.hensc...@t-online.dewrote: Hi Alberto, Alberto Sanchez schrieb: Hi all, I'm a finance major so I use excel a lot, but I don't have the money for it so I use calc. I see that there's is a lot of financial formulas that are missing but that excel has, so my question is, how can I add that function so that many others in my position can benefit from them? I don't believe that there are a lot of financial formula that Excel has but Calc not, please name them. If they are listed in ODF1.2, they should be added to the core. Kind regards Regina -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] I want to add formulas and functions to calc
At 09:36 23/10/2011 -0400, Alberto Sanchez wrote: On Sun, Oct 23, 2011 at 6:50 AM, Regina Henschel rb.hensc...@t-online.dewrote: Alberto Sanchez schrieb: I'm a finance major so I use excel a lot, but I don't have the money for it so I use calc. I see that there's is a lot of financial formulas that are missing but that excel has, so my question is, how can I add that function so that many others in my position can benefit from them? I don't believe that there are a lot of financial formula that Excel has but Calc not, please name them. If they are listed in ODF1.2, they should be added to the core. I will name them, the ones on my mind now is PVIF and FVIF. they are quite easy. I would also add ones that are not in excel but we could beat excel at that. we could have the most comprehensive group of formulas and functions. For what it's worth, these two functions do not appear to exist in Excel, in fact. At least, as evidenced by their web site, Microsoft seem to have no knowledge of them! Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] I want to add formulas and functions to calc
The long name is Present Value Interest Factor and Future Value Interest Factor. but apparently it was a add-in or something cause I remember it was =pvif(i,n) being i the interest and n the periods compounding. On Sun, Oct 23, 2011 at 9:56 AM, Brian Barker b.m.bar...@btinternet.comwrote: At 09:36 23/10/2011 -0400, Alberto Sanchez wrote: On Sun, Oct 23, 2011 at 6:50 AM, Regina Henschel rb.hensc...@t-online.de **wrote: Alberto Sanchez schrieb: I'm a finance major so I use excel a lot, but I don't have the money for it so I use calc. I see that there's is a lot of financial formulas that are missing but that excel has, so my question is, how can I add that function so that many others in my position can benefit from them? I don't believe that there are a lot of financial formula that Excel has but Calc not, please name them. If they are listed in ODF1.2, they should be added to the core. I will name them, the ones on my mind now is PVIF and FVIF. they are quite easy. I would also add ones that are not in excel but we could beat excel at that. we could have the most comprehensive group of formulas and functions. For what it's worth, these two functions do not appear to exist in Excel, in fact. At least, as evidenced by their web site, Microsoft seem to have no knowledge of them! Brian Barker -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] I want to add formulas and functions to calc
well then, being that there's a lot of financial formulas we can make a extension of them. I'm not a programmer, but I can say which are the most used and how they are used, so that we as a community can beat excel at formulas. If theres someone willing to help the cause I am available. On Sun, Oct 23, 2011 at 10:08 AM, Alberto Sanchez alberto.sanchez3...@gmail.com wrote: The long name is Present Value Interest Factor and Future Value Interest Factor. but apparently it was a add-in or something cause I remember it was =pvif(i,n) being i the interest and n the periods compounding. On Sun, Oct 23, 2011 at 9:56 AM, Brian Barker b.m.bar...@btinternet.comwrote: At 09:36 23/10/2011 -0400, Alberto Sanchez wrote: On Sun, Oct 23, 2011 at 6:50 AM, Regina Henschel rb.hensc...@t-online.de**wrote: Alberto Sanchez schrieb: I'm a finance major so I use excel a lot, but I don't have the money for it so I use calc. I see that there's is a lot of financial formulas that are missing but that excel has, so my question is, how can I add that function so that many others in my position can benefit from them? I don't believe that there are a lot of financial formula that Excel has but Calc not, please name them. If they are listed in ODF1.2, they should be added to the core. I will name them, the ones on my mind now is PVIF and FVIF. they are quite easy. I would also add ones that are not in excel but we could beat excel at that. we could have the most comprehensive group of formulas and functions. For what it's worth, these two functions do not appear to exist in Excel, in fact. At least, as evidenced by their web site, Microsoft seem to have no knowledge of them! Brian Barker -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] I want to add formulas and functions to calc
Hi Alberto, Alberto Sanchez schrieb: The long name is Present Value Interest Factor and Future Value Interest Factor. but apparently it was a add-in or something cause I remember it was =pvif(i,n) being i the interest and n the periods compounding. PVIF(i;n) should equal 1/(1+i)^n and FVIF(i;n) should equal (1+i)^n Or do I understand them wrong? Why do you need functions for them? So I'm really interested in what functions do you miss. I guess, that there already exist equivalent solutions. Kind regards Regina -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] I want to add formulas and functions to calc
that's the right formula. those were easy one, but I accepted that I may have been wrong, I saw those formulas on excel but maybe it was an extension, cause it did work as a function. My interest now is just adding formulas like these ones to the suite. On Sun, Oct 23, 2011 at 11:31 AM, Regina Henschel rb.hensc...@t-online.dewrote: Hi Alberto, Alberto Sanchez schrieb: The long name is Present Value Interest Factor and Future Value Interest Factor. but apparently it was a add-in or something cause I remember it was =pvif(i,n) being i the interest and n the periods compounding. PVIF(i;n) should equal 1/(1+i)^n and FVIF(i;n) should equal (1+i)^n Or do I understand them wrong? Why do you need functions for them? So I'm really interested in what functions do you miss. I guess, that there already exist equivalent solutions. Kind regards Regina -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] I want to add formulas and functions to calc
There should be care in naming extensions and avoiding collisions with OpenFormula and other extensions (implementation- or user-defined). It might be good to review the specification of OpenFormula in ODF 1.2 for all of the functions defined there. There may be OpenFormula functions of interest that are not yet implemented in LibreOffice Calc and it would, in those cases, be useful to implement them as part of the full set. Also, there needs to be agreement on how extensions not provided for in ODF are identified. I recommend against using org.openoffice simply because there would need to be some sort of joint arrangement to manage that as a shared namespace. Not a bad idea, but absent that it might be useful that one use a unique name prefix for LO-defined extensions (as opposed to user-defined functions). This is all to avoid collision of names among implementations when LibreOffice Calc documents are interchanged with other ODF-supporting spreadsheet implementations. For user-defined extensions, one might want to have a naming policy so those extensions don't collide as well. - Dennis E. Hamilton tools for document interoperability, http://nfoWorks.org/ dennis.hamil...@acm.org gsm: +1-206-779-9430 @orcmid -Original Message- From: Stefan Weigel [mailto:stefan.wei...@bildungskreis.org] Sent: Saturday, October 22, 2011 23:10 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] I want to add formulas and functions to calc Hi, Am 23.10.2011 04:35, schrieb Alberto Sanchez: Is there a way that the community can benefit from this? so my question is, how can I add that function so that many others in my position can benefit from them? Make an Extension and put into the Extensions Repository. http://www.libreoffice.org/features/extensions/ http://extensions-test.libreoffice.org/ If you do not know how to create an extension and if you do not want to learn it (which isn´t difficult), you could post the Code and a description of your new function and hope that some other old man will pick it up and create and publish it as an extension. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] I want to add formulas and functions to calc
Hi all, I'm a finance major so I use excel a lot, but I don't have the money for it so I use calc. I see that there's is a lot of financial formulas that are missing but that excel has, so my question is, how can I add that function so that many others in my position can benefit from them? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted