similar to: Creating an Excel file with multiple spreadsheets

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