similar to: Bridging R to OpenOffice

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!

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

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

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

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

Dear list members, Every "modern" OS comes with dozens of useless fonts, so that the current font drop-down list in most programs is overcrowded with fonts one never will use. Selecting a useful font becomes a nightmare. In an attempt to ease the selection of useful fonts, I began looking into sorting fonts using some statistical techniques. I summed my ideas on the OpenOffice.org

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

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

Since rpm from openoffice.org was not nicely integrate with Centos, what is the best way to make OO uptodate, can i use (or depend on) package from fedora (it slightly outdate but not too far from OO release). Having see the huge spec file (around 3700 lines), building it ourself is really not fun :( --beast

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

I am trying to use R2HTML (just downloaded from CRAN) to paste R (2.6.0) results output via the clipboard to OpenOffice Writer and Calc (version 2.3on WinXPPro) Pasting into Excel gives a formatted table of results (as expected), but pasting into Calc simply pastes the HTML code. Trying paste special only gives an option to paste unformatted text. Equally, with Writer, in the past when I tried

I had a corrupted installation of OpenOffice.org 3.1. When I used "yum remove openoffice.org-core" the response was "package openoffice.org-core available but not installed", but then, when I used "yum install openoffice.org-core there was a long list of Transaction Check Errors. I then removed openoffice.org3.1-redhat-menus-noarch which was in the errors. Here's the

Hi. First of all, I will probably post this question several places, at least here, on the ubuntu forums, and perhaps OpenOffice forums. It is a problem that I'm not sure if really is samba related, Openoffice related or perhaps even OS related. As stated in the heading, it's about file locking, so many apps come into play. I work at a school where we teachers use mainly Ubuntu Hardy and

I have just install OOo 2.3 on new centos 5 box. However OO keep open registration wizard everytime launched, even though i already select "i do not want to register". I've been playing with "$HOME/.openoffice.org2/" but still no luck. This problem did not happen on FC6, so i guess its not OOo bug. --beast

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 /

CentOS Errata and Security Advisory CESA-2010:0101 openoffice.org security update for CentOS 4 i386: https://rhn.redhat.com/errata/RHSA-2010-0101.html The following updated file has been uploaded and is currently syncing to the mirrors: i386: updates/i386/RPMS/openoffice.org-1.1.5-10.6.0.7.EL4.3.i386.rpm updates/i386/RPMS/openoffice.org-i18n-1.1.5-10.6.0.7.EL4.3.i386.rpm

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.