I want to add formulas and functions to calc

users
#1

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?

#2

Hi.
http://help.libreoffice.org/Calc/User-Defined_Functions
steve

#3

Is there a way that the community can benefit from this?

#4

Hi,

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

#5

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

#6

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.

#7

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

#8

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.

#9

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.

#10

Well I did the function and It worked so thank u. now I want others to be
able to use them but I do not know how to do make extension. Im still
waiting for someone willing to make the extension.

#11

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

#12

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.

#13

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.hamilton@acm.org gsm: +1-206-779-9430 @orcmid

#14

I'm interested in that, too.

On Sat, 22 Oct 2011 21:12:59 -0400, you wrote in gmane.comp.documentfoundation.libreoffice.user:

#15

I'm interested, too

On Sat, 22 Oct 2011 21:12:59 -0400, you wrote in gmane.comp.documentfoundation.libreoffice.user:

#16

Thanks.

#17

Hi :slight_smile:
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 :slight_smile:

#18

but how about if the libreoffice team integrate it, so theres no need for a
add-on