similar to: R-OpenOffice.org Calc

Could anybody explain this results? >sin(2*pi) -2.449213e-16 #should be zero >(10^16)*sin(log2(4)*pi) -2.449213 #should be zero too and explain what to do to correct this events? Thanks!!! Branimir K. Hackenberger

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

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 =

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

Dear R-helpers! What it's means "Rank failure in Choleski decomposition" by using of function surf.gls {spatial}? Sincerely Yours Branimir K. Hackenberger

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.

This is some interesting: > -8^(1/3) [1] -2 > x=(-8:8) > y=x^(1/3) > y [1] NaN NaN NaN NaN NaN NaN NaN NaN 0.000000 1.000000 [11] 1.259921 1.442250 1.587401 1.709976 1.817121 1.912931 2.000000 So, can anybody explain this?! (Why is x[1]^(1/3)=y[1]=NaN, but -8^(1/3)=-2?) Thx!!! [[alternative HTML version deleted]]

Dear all! I am using wireframe function from lattice package. Is it possible to remove box around the plot but to keep axis (x, y, z)? Thanks in advance! [[alternative HTML version deleted]]

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

After some investigation I found out that constrained ordination is working fine under R version 6.5.0 and 6.5.1 but not under any of newer versions. Is it posible to repair/make something in for example newest version of R 7.0 lito enble correct using of constrained ordination under BiodiversityRGUI environment? [[alternative HTML version deleted]]

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

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

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

I've just install centos 5.0 on new PC. However it gives this error while installing per-Date-Calc: [root at piranha tmp]# perl -ivh perl-Date-Calc-5.4-1.2.2.1.i386.rpm Unrecognized character \xED at perl-Date-Calc-5.4-1.2.2.1.i386.rpm line 1. what could be the problem? --beast

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

Does anyone else find that using the Var.calc option (for heteroscedasticity consistent std. errors) in Match() (from the Matching library) slows down computation of the matching estimator by a lot? I don't really understand why when I use this option it slows down so much, but for me it does significantly. I want to use the heteroscedasticity consistent std. errors in my project, but as long

Hi, Can R read open office.org Calc files Thanks -- Shane [[alternative HTML version deleted]]