similar to: RJDBC to OpenOffice Calc as RODBC to MS Excel

Hi all, I'd like to do a multiplication between 2 matrices buy only want resulsts of cloumn 1 * column 1, column 2 * column 2 and so on. Now I do C <- diag(t(A) %*% B) Is there a bulit in way to do this? Thank you. [[alternative HTML version deleted]]

Hi all, It's possible to create an alias of a device? Something like a device loN that all it's traffic is send to ethN, so ethN and loN are equivalent. It's for a bridged setup, i'm not trying to setup another IP on a device. Thanks! Jordi -- ...................................................................... __ / / Jordi Prats C E / S / C A

I have been very satisfied with R-Excel interface (DCOM). Few months ago I have changed my OS to Linux-Mandrake, and now I am using OpenOffice.org Calc as spreadsheet. I would like to know does exist some R-OpenOffice.org interface or how is possible to use R-functions in OpenOffice.org Calc? Thanks a lot!

Hi R users: I am using RODBC to create some new ".xls" files each with several sheets (about 100) with sqlSave() from a data.frame inside R without any problem, but on windows XP platform. I would like to know if it is posible to make a similar solution on linux with openoffice? RODBC work only (for the moment) with ".xls" on windows, via the ODBC driver. Is it posible to

I am in awe of the project you developed but wish to do something simpler. I have recently decided to give up on Microsoft Office and wish to use OpenOffice exclusively. In the past I have used the RODBC package to read data from excel files. Do you know how to read data directly from OpenOffice calc files into R? Farrel Buchinsky

Hi all, Has anyone upgraded OpenOffice.org 3.1.1 on Centos 5.3? Everything seemed fine but I have found 1 problem on Calc. The autofill does not work. Example, when I type "Jan" in cell A5 and drag the handle to cell D5, the Fill Settings dialog box pops up instead of the Feb, Mar, Apr filling in the cell automatically. When OpenOffice.org 3.1.1 from Sun is installed, it works.

I am attempting to create a simple line chart graphing three columns from a soffice-calc spreadsheet. I expect it to take the leftmost column as the X-Axis, plotting the others on the Y-Axis, but it always creates an X-Axis of the row number in the columns, and the first column amongst the data. I have tried this on OpenOffice.org 3.2.0, NeoOffice(R) 3.0.2 Patch 2, iWork Pages, and Excel 12.2.4

Hi list, I'm trying Centos7 and using systemD. I've noticed that interfaces name does not have anymore eth0,eth1, ethN but a different name. What do you think about predictable network if name assigned by systemd?

Hi, Until now I've been a happy user of CentOS. Everything just works(tm), and I don't care if application versions are slightly outdated. Next week I have to give a series of classes for a company that recently made the switch to Linux. On schedule is a one-week course for Writer and Calc. And right now I discover that one crucial function of Calc, "fill series",

I have read a few ways to do this, but not 100% sure. I need the interfaces reliably associated to the hardware (there are more than one), so the ifcfg-ethn has the mac address in it. I need to match the mac address of an old router that is about to be removed so I need not change any dns related config. Thanks! jlc

I am trying to override the mac addr. Now this is on an armv7 actually running the F19 kernel and Redsleeve 6, but it SHOULD be standard Centos6 ifcfg-eth0 content. Of course RSEL does not start with a ifcfg-eth0 file, letting network services do all the work, so I am starting from scratch, using the file from one of my C6 boxes with static addressing. My file has in it:

Hi all, Up until now, we''ve been using Xen 3.0 on CentOS 5.x. Under this setup, dom0 was given a virtual ''ethX'' with the original ''ethX'' (now ''pethX'') IP address. Under this older config, neither ''pethX'' or ''xenbrX'' had an IP address. The logic was to keep traffic from the domU''s, through

Hello all, I had a very strange looking problem that turned out to be due to unexpected (by me at least) format changes to one of my data files. We have a small lab study in which each run is represented by a row in a tab-delimited file; each row identifies a repetition of the experiment and associates it with some subjective measurements and times from our notes that get used to index another

After installing RJDBC on RedHat Linux and using it successfully with mySQL JDBC driver i am trying to use it with Oracle database. I use the JDBC driver that works fine elsewhere (use it in DBVizualizer). However, when i try to load the driver, drv<-JDBC("oracle.jdbc.driver.OracleDriver", "/home/az05625/DBdrivers/ojdbc6.jar", identifier.quote="`") it gives me

Hi, I'm working with R on Cassandra and need to install RJDBC on my Ubuntu virtual machine. The traditional commands (install.packages(RJDBC, dep=TRUE) and library(RJDBC)) don't work: they throw an error that they can't find the package. I tried installing it using the Rkward GUI, but can't write to any of the pre-set directories because of permissions issues. When I try running

Dear all Backend is Ingres DBMS I use RJDBC with Ingres JDBC driver I have this csv file "","Strategy","par1","m.1997.09.01" "1","ALF",2,0.1244 which I try to load it RJDBC require (RJDBC) drv <- JDBC("com.ingres.jdbc.IngresDriver","/home/ingres/ingresv1/ingres/lib/iijdbc.jar") conn <- dbConnect(drv,

Trying to install the above two packages via the "install.packages("package_name")" command and the "R CMD INSTALL file.tar.gz". I receive the following error either way "sh: ./configure: /bin/sh: bad interpreter: Permission denied". I have tried to chmod and chown permissions and also ran dos2unix in hopes that there is a CRLF in some of the tar.gz files,

Trying to install the above two packages via the "install.packages("package_name")" command and the "R CMD INSTALL file.tar.gz". I receive the following error either way "sh: ./configure: /bin/sh: bad interpreter: Permission denied". I have tried to chmod and chown permissions and also ran dos2unix in hopes that there is a CRLF in some of the tar.gz files,

Rjdbc consistently gives me an execution error with postgresql 9.0s JDBC4 driver. It's probably something trivial so am including my code below: library("RJDBC") param <- 249 param2 <- 188129 postgres <- JDBC("org.postgresql.Driver", ".m2/repository/postgresql/postgresql/9.0-801.jdbc4/postgresql-9.0-801.jdbc4.jar") con <- dbConnect(postgres,

Hi R-helpers, i am using the following dataset.This dataset is stored in a mysql database. W(x) pH(y) 10 1 15 1 20 4 5 7.5 3 13 9 5 11.5 13.5 3 16 2 1 9.6 1 I am using RJDBC package to read the data from the database into a dataFrame.The commands used are, jdbcDriver<-JDBC(driverClass="com.mysql.jdbc.Driver",