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
[libreoffice-users] Toolbar / Menu Icons
Is there any way to get a copy of LibreOffice's toolbar icons and menu icons(200px by 200px)? If there is vector version, it's more preferable. -- 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] Toolbar / Menu Icons
Hi Calvin, Calvin Kim schrieb: Is there any way to get a copy of LibreOffice's toolbar icons and menu icons(200px by 200px)? The icons are in installation path\Basis\share\config. Unpack the set. Most toolbar icons belong to commands. Those are in images\res\commandimagelist. You get them in small, large, highlighted small and highlighted large. If there is vector version, it's more preferable. They are all png. 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] Toolbar / Menu Icons
Thank you for quick reply. I also found scalable version at http://packages.ubuntu.com/oneiric/all/tango-icon-theme/download Although, it looks like some icons are missing in this package. Perhaps I should look at different theme. On 10/23/2011 12:19 PM, Regina Henschel wrote: Hi Calvin, Calvin Kim schrieb: Is there any way to get a copy of LibreOffice's toolbar icons and menu icons(200px by 200px)? The icons are in installation path\Basis\share\config. Unpack the set. Most toolbar icons belong to commands. Those are in images\res\commandimagelist. You get them in small, large, highlighted small and highlighted large. If there is vector version, it's more preferable. They are all png. 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
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] Attach files to records in Base
I did a search on attach files records, and did not find what I'm looking for. (I concede I may have missed it, so please have mercy if I did.) I want to attach various types of files to specific database records, including .doc, .txt, .jpeg, .pdf, .wav, .mp3 and possibly some other formats. The idea is that one record might have the usual information, but have a .doc and an .mp3, whereas another might have a .doc and a .pdf, or another a .pdf, .mp3 and three .jpegs. The idea is to attach all the files associated with a specific record so that I have everything in one place. Is this even possible without me having to write an app? I could probably install an extension if I knew where and how to find one. Thanks for any help. Anne B. -- View this message in context: http://nabble.documentfoundation.org/Attach-files-to-records-in-Base-tp3446550p3446550.html Sent from the Users mailing list archive at Nabble.com. -- 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] LibO 3.4.3 cannot open password protected Word 2010 file
On 10/22/2011 5:33 AM, Nguyen Vu Hung (kiei) wrote: Hello all, It seems that LibO 3.4.3 cannot open password protected Word 2010 file. Attached is a Word file saved with Mac Word 2010. The password for opening and modifying is 123456. Any ideas? The attachment did not survive. You will have to post it somewhere or use something similar to YouSendIt. David Teague -- nil significat nisi oscillat -- 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] hyperlink toolbar
I have wondered for a long time why there is a section in Options for internet search so I finally thought I would try and find out by reading the help file (never really could think why I would do this but help sounded interesting and might be useful). Says ViewToolbarhyperlink toolbar should let me do an internet search from within a document. Problem No hyperlink toolbar - have a hyperlink button for adding them to docs but not the one pictured in Help. Does this work/should it work? LibreOffice 3.4.3 (not the one from Ubuntu repositories but one from doc foundation) Kubuntu 11.10 -- View this message in context: http://nabble.documentfoundation.org/hyperlink-toolbar-tp3446488p3446488.html Sent from the Users mailing list archive at Nabble.com. -- 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] LibO 3.4.3 cannot open password protected Word 2010 file
Ngày 11/10/24 7:57, David B Teague sr viết: The attachment did not survive. You will have to post it somewhere or use something similar to YouSendIt. I did http://www.mediafire.com/?eqc9sh5hc49v6j5 -- 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] Attach files to records in Base
Anne, On 10/23/2011 06:34 PM, MsBriscow wrote: I did a search on attach files records, and did not find what I'm looking for. (I concede I may have missed it, so please have mercy if I did.) I want to attach various types of files to specific database records, including .doc, .txt, .jpeg, .pdf, .wav, .mp3 and possibly some other formats. The idea is that one record might have the usual information, but have a .doc and an .mp3, whereas another might have a .doc and a .pdf, or another a .pdf, .mp3 and three .jpegs. The idea is to attach all the files associated with a specific record so that I have everything in one place. Is this even possible without me having to write an app? I could probably install an extension if I knew where and how to find one. Thanks for any help. Do you need to actually to store the files? If you need to store them use the data type 'OTHER' also called Blob in other DBMS. It accepts any entry with a max size 2.1G. Are you familiar with using a table linked to a base table using a foreign key. You indicate that you may have different number of files stored. I would use a linked table to the main table. The linked table will have its own primary key and will use the main table's primary key as its foreign key. Anne B. -- View this message in context: http://nabble.documentfoundation.org/Attach-files-to-records-in-Base-tp3446550p3446550.html Sent from the Users mailing list archive at Nabble.com. -- Jay Lozier jsloz...@gmail.com -- 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