similar to: OpenOffice.org 3.1.1 Calc autofill does not work

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

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

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

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

CentOS Errata and Security Advisory 2012:0411 Important Upstream details at : https://rhn.redhat.com/errata/RHSA-2012-0411.html The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) i386: a12b51b7c205752597b75bd0e97de496f7d2f9adef99c09b9823e1341a1aae3f openoffice.org-base-3.1.1-19.10.el5_8.1.i386.rpm

CentOS Errata and Security Advisory 2012:0705 Important Upstream details at : https://rhn.redhat.com/errata/RHSA-2012-0705.html The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) i386: 1c23fd431fae859c3785afc2b01b16efeb245203a7e49fa9f2a24b62fdcd865e openoffice.org-base-3.1.1-19.10.el5_8.3.i386.rpm

CentOS Errata and Security Advisory 2012:1136 Important Upstream details at : https://rhn.redhat.com/errata/RHSA-2012-1136.html The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) i386: c9546097ba8b063cdf1bacbabf28ff0cccc9bae7665d876458cf01b2eaaa30ae openoffice.org-base-3.1.1-19.10.el5_8.4.i386.rpm

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

CentOS Errata and Security Advisory 2011:0182 Important Upstream details at : https://rhn.redhat.com/errata/RHSA-2011-0182.html The following updated files have been uploaded and are currently syncing to the mirrors: ( md5sum Filename ) x86_64: 0fcc8980fc295385c0ee0c2a71c88910 openoffice.org-base-3.1.1-19.5.el5_5.6.x86_64.rpm f1ed5757f44520c5f75f7a733cc0d973

CentOS Errata and Security Advisory 2010:0459 Moderate Upstream details at : https://rhn.redhat.com/errata/RHSA-2010-0459.html The following updated files have been uploaded and are currently syncing to the mirrors: ( md5sum Filename ) i386: d57925d52e7175b822b02f0deb56ee21 openoffice.org-base-3.1.1-19.5.el5_5.1.i386.rpm 5f981b1deedc11f1a9fd1e2aa28c7a8e

CentOS Errata and Security Advisory 2011:0182 Important Upstream details at : https://rhn.redhat.com/errata/RHSA-2011-0182.html The following updated files have been uploaded and are currently syncing to the mirrors: ( md5sum Filename ) i386: 8ff1d432d02a981f5918ed7bec53b863 openoffice.org-base-3.1.1-19.5.el5_5.6.i386.rpm eea433d27f0a7d2514231ed98db46622

CentOS Errata and Security Advisory 2010:0459 Moderate Upstream details at : https://rhn.redhat.com/errata/RHSA-2010-0459.html The following updated files have been uploaded and are currently syncing to the mirrors: ( md5sum Filename ) x86_64: ae41ba0696a6a9986bae400a2aabee4c openoffice.org-base-3.1.1-19.5.el5_5.1.x86_64.rpm 9df64bbafa4ce5743a158b890fbd7032

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

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

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