Displaying 20 results from an estimated 600 matches similar to: "Creating an Excel file with multiple spreadsheets"
2009 Apr 10
1
png with ggplot on windows xp
Hi Group,
I posted this question on the ggplot list and was advised to try here
also. The code
below produces a plot as a png and pdf. The pdf looks great, and I cannot
make the png look this way. I've tried various combinations of
height, width, and dpi, but it has not worked out so
far. Any suggestions to make the png look like the pdf? I received a
response that
the problem does not occur
2009 Feb 26
1
bottom legends in ggplot2 ?
Has anyone had success with producing legends to a qplot graph such that the legend is placed on the bottom, under the abcissa rather than to the right hand side ?
The following doesn't move the legend:
library(ggplot2)
qplot(mpg, wt, data=mtcars, colour=cyl, gpar(legend.position="bottom") )
I am using ggplot2_0.8.2.
Thanks in advance,
Avram
2010 Jul 20
1
RGoogleDocs ability to write to spreadsheets broken as of yesterday
Hi,
I'm using RGoogleDocs/RCurl to update a Google Spreadsheet. Everything
worked OK until this morning, when my ability to write into spreadsheet
cells went away. I get the following weird error:
Error in els[[type + 1]] : subscript out of bounds
Looking at the Google Docs API changelog, I see the following:
http://code.google.com/apis/spreadsheets/changelog.html
Release 2010-01 (July 14,
2017 Apr 10
1
Excel shared spreadsheets behavior
Hi David
Thanks you for reply, are you sure about this? Windows and Samba SMB byte range locking feature doesn't allow this by locking regions of a single file ?
From: "David Bear" <dwbear75 at gmail.com>
To: "Dante F. B. Colò" <dante.colo at stwbrasil.com>
Cc: "samba" <samba at lists.samba.org>
Sent: Friday, April 7, 2017 1:59:56 PM
2010 Jul 21
2
RGoogleDocs ability to write to spreadsheets broken as of yesterday - CAN PAY FOR FIX
I unfortunately haven't received any responses about this problem. We (the
company I work for) are willing to discuss payment to someone who is willing
to quickly contribute a fix to the RGoogleDocs/RCurl toolchain that will
restore write access. Please contact me directly if you're interested. Thank
you,
-Harlan Harris
On Tue, Jul 20, 2010 at 10:19 AM, Harlan Harris
2017 Apr 07
1
Excel shared spreadsheets on Samba share
Hello everyone
I 'm trying to find what it happens on my Samba AD servers especially
with shared spreadsheets, my personal opinion this feature on Excel is
crap and unreliable but many people use it, how does Samba currently
behave with this ? Is someone experienced any problem with this ?
Frequently happens changes made by other user are lost the spreadsheet
opens as read only , the
2009 Apr 01
0
Reading from Google Spreadsheets with RGoogleDocs
I cannot read google spreadsheets. I get the following error:
assignment of an object of class "NULL" is not valid for slot "access"
in an object of class "GoogleSpreadsheet"; is(value, "character") is
not TRUE
RGoogleDocs is on the cusp of brilliance. How can I troubleshoot this
apparently last remaining problem?
Farrel J. Buchinsky, MD
Director,
2017 Apr 07
0
Excel shared spreadsheets behavior
Even on pure Windows file servers you cannot effectively have simultaneous
read/write for multiple users. I may have had 2 simultaneous users work one
time for a few minutes. But it is not stable. So not even a microsoft
server can do it.
On Thu, Apr 6, 2017 at 8:58 AM, Dante F. B. Colò via samba <
samba at lists.samba.org> wrote:
> Hello everyone
>
> I trying find what it happens
2017 Apr 06
2
Excel shared spreadsheets behavior
Hello everyone
I trying find what it happens on my Samba AD servers especially with shared spreadsheets, my personal opinion this feature on Excel is crap and unreliable but many people use it, how does Samba currently behave with this ? Is someone experienced any problem with this ? Frequently happens changes made by other user are lost the spreadsheet opens as read only , the shares are all
2010 Dec 01
2
Problem in reading Excel spreadsheets
Hi folks,
Win 7 64bit
R 2.12.0 32bit
Problem in reading Excel spreadsheets
(the text file, research_databaseI.xls, was download on Internet)
> data=odbcConnectExcel(file.choose())
> sqlTables(data)
TABLE_CAT TABLE_SCHEM
1 C:\\Users\\satimiswin764\\Documents\\research_databaseI <NA>
2
2008 May 06
4
Is there in R a function equivalent to the mround, as found in most spreadsheets?
Dear R-users,
I have the following problem
In a lab experiment I have to mix three solutions to get different
concentrations of various molecules in a cuvette
I've used R to calculate the necessary ?liters for each of the level of
the experiment and I must confess that it is more useful and easier to
achieve the results than using spreadsheets.
But there's a problem.
Imagine that
2003 Jul 11
2
Problem with opening Excel spreadsheets that client cannot write to
We have some Excel spreadsheets stored on our Samba 2.2.8 fileserver. The
permissions are set such that some users can write to these and some cannot,
but they can all read them (the world-readable bit is set).
When a user with read/write access tries to open the spreadsheet, there is no
problem. The user is happy and productive and outside the sun is shining.
Excellent! Have a biscuit!
When a
2013 Apr 15
0
gnumeric spreadsheets for US taxes
For years I've been doing my (US) taxes, along with the state and local
taxes, using gnumeric. I decided I should share what I've done with
others. So grab the package if you want... from:
<https://github.com/gebser/US-taxes-gnumeric.git>
2008 Sep 15
1
Help... Organizing multiple spreadsheets data into a huge R data structure!
Hello R users,
I am relatively new to the R program, and I hope some of you can offer
me some suggestions on how to organize my data in R using some of the
more advanced data structuring technique. Here's my scenario:
I have date set of 50 participants (each with conditions and
demographic data), each participant performed 2x16 trials, for each
trial, there was specific information about the
2011 Jul 10
3
OpenOffice ods spreadsheets in R?
I would like to open OpenOffice (LibreOffice) .ods files in R. I've
tried the ROpenOffice package from omegahat, but unfortunately, the
read.ods() function attempts to use the values of the first column in a
worksheet as row names, and thus does not allow duplicates in there
(which, even more unfortunately, occur in my files). Also, the function
does not allow to forward any other
2012 Apr 05
4
Help Using Spreadsheets
Hello,
I am a new user of R and I am trying to use the data I am reading from a spreadsheet.
I installed the xlsReadWrite package and I am able to read data from this files, but how can I assign the colums into values?
E.g:
as I read a spreadsheet like this one:
A B
1 2
4 9
I manually assign the values:
A<-c(1,4)
B<-c(2,9)
to plot it on a graph:
plot(A,B)
or make histograms:
hist(A)
But
2013 Apr 16
7
the joy of spreadsheets (off-topic)
Given that we occasionally run into problems with comparing Excel
results to R results, and other spreadsheet-induced errors, I thought
this might be of interest.
http://www.nextnewdeal.net/rortybomb/researchers-finally-replicated-reinhart-rogoff-and-there-are-serious-problems
The punchline:
"If this error turns out to be an actual mistake Reinhart-Rogoff made,
well, all I can hope is that
2008 Aug 27
0
Edit & Email an Excel Spreadsheet in Rails 2.0
Dear Group,
I hope someone out there can help me with this.
I am building a Rails 2.0 application for a customer. The customer
has a number of Excel spreadsheets which he would like his customers
to open and complete online then submit the completed spreadsheet to
him via email.
A typical scenario would be:
(1) The ''empty'' spreadsheets are provided as a list on the web site.
2005 Jan 03
3
spreadsheet addiction
There's a new page on the Burns Statistics website
http://www.burns-stat.com/pages/Tutor/spreadsheet_addiction.html
that looks at spreadsheets from a quality assurance perspective. It
presents R as a suitable alternative to spreadsheets. Also there are
several specific problems with Excel that are highlighted, including
the status of statistical functionality in Excel.
Patrick Burns
Burns
2010 Feb 16
2
reading quattro pro spreadsheet .qpw into R
I have many quattro pro spreadsheets and no quattro pro. Is there a
way to access the data using R, or any other solution that anyone can
think of?
thanks,
--
Stephen Sefick
Let's not spend our time and resources thinking about things that are
so little or so large that all they really do for us is puff us up and
make us feel like gods. We are mammals, and have not exhausted the
annoying