similar to: OpenOffice Calc ODBC equivalent

Under Windows, I have used RODBC to connect to Excel spreadsheets as per the example below: library(RODBC); connect = odbcConnectExcel("testdata.xls"); query = "SELECT [data$.ethn], [data$.sex], [data$.age], [data$.height], [data$.weight], [label$.label] FROM [data$], [label$] WHERE [data$.ethn] = [label$.ethn];" data =

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!

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, 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 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

1. I have used gdata::read.xls() with much happiness. But every now and then it breaks. I have not, as yet, been able to construct a mental model about the class of .xls files for which it works. Does someone have a simple rule for predicting the circumstances under which it will work? 2. Just like there is a read.xls(), it'd be great if we have a read.ods() which directly

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

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.

Hello, All: The "writeFindFn2xls" function in the "sos" package tries to write an Excel file with 3 sheets ('PackageSum2', 'findFn', 'call'). Unfortunately, it is often unable to do this because of configuration problems that are not easy to fix. I've found 3 contributed packages that provide facilities to write Excel files with

Hi, I'm having trouble getting my new install of OpenOffice 2.31 to find my newly installed Java Runtime Environment version jre1.6.0_04 (downloaded from Sun). I tried installing it via Tools>Options>Java (am using OpenOffice Calc to try to set it up). The options dialog box is finding the Free Software Foundation version 1.4.2, but it won't find the new JRE file. I tried

The thread "R licensing query" currently running has raised the classic critcisms of using Excel for statistics. I was wondering: Has anyone applied the same or similar set of tests to OpenOffice "calc"? Or would the Executive Summary be: "Calc is just like Excel"? (Not that I'm a spreadsheet user, if I can avoid it; but I sometimes get asked about such

Dear R users, I've learned today about RODBC package in order to import xls file to dataframes and export the dataframes to xls files. However I have some problems. Please excuse me if these are basic but as I said, I've just begun with this package. Also this email is quite long, but everything is related, so I don't think it would be better to split it. Moreover, there's a

Dear members of the R Development Team, I am looking for people with a deep understanding of R internals to assist in bridging R to OpenOffice. While R is a state of the art statistical environment, less experienced users often find it difficult to work with R. Therefore, I believe that a bridge between R and a spreadsheet program will make this transition less painful. I sincerely believe

Hello, R users, I am a very beginner of R and tried read.csv to import an excel file after saving an excel file as csv. But it added alternating rows of fictitious NA values after row number 16. When I applied read.delim, there were trailing several commas at the end of each row after row number 16 instead of NA values. Appreciate your help. Kyong [[alternative HTML version deleted]]

Hi group, I try to write a frame to a table (RODBC). I use colnames(temp6) <- c("ind_id","ser_id","period_id","year","calc","mean") sqlSave(channel, temp6, tablename = "series_indices_test",append= TRUE, rownames=FALSE, verbose = FALSE, test = FALSE, nastring = -999999, fast = FALSE) This is giving me an error: Error in

Hello! I have no problem reading Excel files (each worksheet in the file is a "table" which can be read - at least in my case). What I would like to do is to read such a table, change it (just the contents, not the format) and write it back, and this I can not do. I am getting the following error messages (3 slightly different attempts): > sqlSave(con, x, tablename =

The last few releases of OpenOffice have gotten very unstable on my desktop which is a CentOS 5.5 i386 system. After multiple crashes when doing embedded simple drawings in OpenOffice writer (circles and lines with connections), I started using the versions from Sun then Oracle. I am now using version 3.3: openooffice.org3-3.3.0-9567. I've lived with this but with version 3.x it has gotten

I'm trying to find a way to get remote connections from my Linux Desktop machine to a remote Linux box which is hosting a MySQL database, via SSH port 22, and then once connection is established, log in to the database port 3306 and have either an SSH and or SCP connection established so I can securely do edits and queries. I am able to connect this way from my Windows machine to remote

Hi, I have installed OpenOffice 3.1 downloaded from the openoffice.org website on CentOS 5.4 x86_64. The downloaded file is actually an archive containing RPMs. I did not use their setup tool but installed directly the RPMs I was interested in via 'yum localinstall' (my idea is in the future to put them on a custom yum repository, so that they can be managed via regular yum install /

Hi, I removed the openoffice 1.1 release from my system (kernel 2.6.9) for install the full OpenOffice 2.1. But after trying to start the new soffice, nothing happen. (may be java problem ?) Could someone help me ? Regards? __________________________ Ce message (et toutes ses pi?ces jointes ?ventuelles) est confidentiel et ?tabli ? l'intention exclusive de ses destinataires. Toute