Un addin OpenOffice.org/LibreOffice RCalc permet d'utiliser dans le tableur OpenOffice.org/LibreOffice Calc les fonctions et les graphiques de du langage statistique R. Il s'agit d'un addin qui n'est pas encore stable dans sa version courante (0.1.12) de février 2008 mais très intéressant. Ainsi, après avoir étudier RExcel et son compère ROOo dans un billet précédent, il est temps de découvrir RCalc !
Préparation de la distribution de R
Pour déployer les prérequis de R, il faut ouvrir la console de R et taper les commandes suivantes :
> install.packages("Rserve")
... Après avoir choisi le bon site miroir CRAN de http://cran.rproject.org/
package 'Rserve' successfully unpacked and MD5 sums checked
> install.packages("odesolve")
...
package 'odesolve' successfully unpacked and MD5 sums checked
> install.packages("scatterplot3d")
...
package 'scatterplot3d' successfully unpacked and MD5 sums checked
> install.packages("sna")
...
package 'sna' successfully unpacked and MD5 sums checked
> install.packages("survival")
...
package 'survival' successfully unpacked and MD5 sums checked
Enregistrement manuel de l'addin R4Calc par OpenOffice/LibreOffice Calc
Après avoir téléchargé le fichier dans le répertoire PortableOpenOffice\App\openoffice\share\uno_packages pour ou dans le répertoire "C:\Program Files\OpenOffice.org 3\share\uno_packages" pour la distribution windows standard. L'utilitaire "OpenOffice.org 3\program\unopkg.exe" s'occupe de l'enregistrement manuel des extensions openoffice. Pour enregistrer l'addin, il faut ouvrir une fenêtre Invite de commandes Windows et taper les commandes suivantes si vous avez PortableOpenOffice :
Microsoft Windows XP [version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. cd J:\UBS\clients\Bureautique\PortableOpenOffice\App\openoffice openoffice>
ou si vous avez la distribution standard :
Microsoft Windows XP [version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. cd "C:\Program Files\OpenOffice.org 3" C:\Program Files\OpenOffice.org 3>
puis placez vous dans le sous-répertoire program pour utiliser unopkg :
openoffice>cd program
program>unopkg list
all deployed user packages:
<none>
program>unopkg add ..\share\uno_packages\RAddon.uno.pkg
program>unopkg list
all deployed user packages:
Identifier: org.openoffice.legacy.RAddon.uno.pkg
URL: vnd.sun.star.expand:$UNO_USER_PACKAGES_CACHE/uno_packages/7C.tmp_/RAddon.
uno.pkg
is registered: yes
Media-Type: application/vnd.sun.star.package-bundle
Description:
bundled Packages: {
URL: vnd.sun.star.expand:$UNO_USER_PACKAGES_CACHE/uno_packages/7C.tmp_/RAd
don.uno.pkg/RFuncs.uno.rdb
is registered: yes
Media-Type: application/vnd.sun.star.uno-typelibrary;type=RDB
Description:
URL: vnd.sun.star.expand:$UNO_USER_PACKAGES_CACHE/uno_packages/7C.tmp_/RAd
don.uno.pkg/Addons.xcu
is registered: yes
Media-Type: application/vnd.sun.star.configuration-data
Description:
URL: vnd.sun.star.expand:$UNO_USER_PACKAGES_CACHE/uno_packages/7C.tmp_/RAd
don.uno.pkg/RAddon.xcu
is registered: yes
Media-Type: application/vnd.sun.star.configuration-data
Description:
URL: vnd.sun.star.expand:$UNO_USER_PACKAGES_CACHE/uno_packages/7C.tmp_/RAd
don.uno.pkg/RAddon.uno.jar
is registered: yes
Media-Type: application/vnd.sun.star.uno-component;type=Java
Description:
URL: vnd.sun.star.expand:$UNO_USER_PACKAGES_CACHE/uno_packages/7C.tmp_/RAd
don.uno.pkg/RFuncs.uno.jar
is registered: yes
Media-Type: application/vnd.sun.star.uno-component;type=Java
Description:
}
program>
L'enregistrement manuel s'est bien passé. Ce wiki peut vous donner des précisions supplémentaires.
Enregistrement de l'addin R4Calc par le gestionnaire des extensions OpenOffice/LibreOffice Calc
Après avoir téléchargé le fichier dans un répertoire, il faut ouvrir Openoffice ou Calc et procéder à partir du menu Outils.
Si vous ouvrez maintenant Calc, vous pouvez constater l'apparition d'une nouvelle entrée dans le menu nommée R4Calc.
Démarrage du serveur Rserv
La commande de lancement du serveur n'est pas encore fonctionnelle dans l'addin RCalc.
Il faut donc procéder manuellement dans la console de R avant de commencer à utiliser l'addin RCalc avec les commandes library(Rserve) et Rserve() :
R version 2.11.0 (2010-04-22) Copyright (C) 2010 The R Foundation for Statistical Computing ISBN 3-900051-07-0 R is free software and comes with ABSOLUTELY NO WARRANTY. You are welcome to redistribute it under certain conditions. Type 'license()' or 'licence()' for distribution details. R is a collaborative project with many contributors. Type 'contributors()' for more information and 'citation()' on how to cite R or R packages in publications. Type 'demo()' for some demos, 'help()' for on-line help, or 'help.start()' for an HTML browser interface to help. Type 'q()' to quit R. > library(Rserve) Warning message: package 'Rserve' was built under R version 2.11.1 > Rserve() Starting Rserve... J:/UBS/outils/R-Portable/App/R-2.11.0/../../Data/library/Rserve/Rserve.exe >
Comments
Bravo
Magnifique ton sujet que je trouve très
sympa. C'est clair, félicitations à toi. Même si je suis épisodiquement en harmonie avec tout ce qui est dit, j'ai pu remarquer deux points qui m'ont scandalisé et dont je suis en profond désaccord. Cela a, au moins le mérite de m'avoir fait
réfléchir, cela me rappelle un peu mon étonnement que j'ai eu en rédigeant l'article sur
le blog Caramba Poker.
Le lien pour http://www.11-55.org ne fonctionne plus.
Savez-vous comment je peux utiliser R depuis LibreOffice calc ?
Merci.
http://en.sourceforge.jp/projects/sfnet_aoo-extensions/downloads/627/0/RAddon.uno.pkg
Dans le fichier zip de
http://www.softpedia.com/progDownload/R4Calc-R-Statistics-for-OOoCalc-Download-104765.html , il y a le manuel (manual.odt). Il y a aussi des exemples de GUI.
including cold weather to be spring and coil, you will get a split flair, making use of tight pants or skirts thrown on the ground additionally the cardy hunters kind of up higher buttoned in cold months along with distorted heat and wearing your favorite spg cuffed boot slouched in.
Hello Web Admin, I noticed that your On-Page SEO is is missing a few factors, for one you do not use all three H tags in your post, also I notice that you are not using bold or italics properly in your SEO optimization. On-Page SEO means more now than ever since the new Google update: Panda. No longer are backlinks and simply pinging or sending out a RSS feed the key to getting Google PageRank or Alexa Rankings, You now NEED On-Page SEO. So what is good On-Page SEO?First your keyword must appear in the title.Then it must appear in the URL.You have to optimize your keyword and make sure that it has a nice keyword density of 3-5% in your article with relevant LSI (Latent Semantic Indexing). Then you should spread all H1,H2,H3 tags in your article.Your Keyword should appear in your first paragraph and in the last sentence of the page. You should have relevant usage of Bold and italics of your keyword.There should be one internal link to a page on your blog and you should have one image with an alt tag that has your keyword....wait there's even more Now what if i told you there was a simple Wordpress plugin that does all the On-Page SEO, and automatically for you? That's right AUTOMATICALLY, just watch this 4minute video for more information at. <a href="http://www.SEORankingLinks.com">Seo Plugin</a>
Hello Web Admin, I noticed that your On-Page SEO is is missing a few factors, for one you do not use all three H tags in your post, also I notice that you are not using bold or italics properly in your SEO optimization. On-Page SEO means more now than ever since the new Google update: Panda. No longer are backlinks and simply pinging or sending out a RSS feed the key to getting Google PageRank or Alexa Rankings, You now NEED On-Page SEO. So what is good On-Page SEO?First your keyword must appear in the title.Then it must appear in the URL.You have to optimize your keyword and make sure that it has a nice keyword density of 3-5% in your article with relevant LSI (Latent Semantic Indexing). Then you should spread all H1,H2,H3 tags in your article.Your Keyword should appear in your first paragraph and in the last sentence of the page. You should have relevant usage of Bold and italics of your keyword.There should be one internal link to a page on your blog and you should have one image with an alt tag that has your keyword....wait there's even more Now what if i told you there was a simple Wordpress plugin that does all the On-Page SEO, and automatically for you? That's right AUTOMATICALLY, just watch this 4minute video for more information at. <a href="http://www.SEORankingLinks.us">Seo Plugin</a>
Hello Web Admin, I noticed that your On-Page SEO is is missing a few factors, for one you do not use all three H tags in your post, also I notice that you are not using bold or italics properly in your SEO optimization. On-Page SEO means more now than ever since the new Google update: Panda. No longer are backlinks and simply pinging or sending out a RSS feed the key to getting Google PageRank or Alexa Rankings, You now NEED On-Page SEO. So what is good On-Page SEO?First your keyword must appear in the title.Then it must appear in the URL.You have to optimize your keyword and make sure that it has a nice keyword density of 3-5% in your article with relevant LSI (Latent Semantic Indexing). Then you should spread all H1,H2,H3 tags in your article.Your Keyword should appear in your first paragraph and in the last sentence of the page. You should have relevant usage of Bold and italics of your keyword.There should be one internal link to a page on your blog and you should have one image with an alt tag that has your keyword....wait there's even more Now what if i told you there was a simple Wordpress plugin that does all the On-Page SEO, and automatically for you? That's right AUTOMATICALLY, just watch this 4minute video for more information at. <a href="http://www.SEORankingLinks.xyz">Seo Plugin</a>