[R] spreadsheet addiction

[Henrik Andersson]

I am moving to using R more and more as a computational platform and
I use Microsoft Excel at the moment in exactly the way you describe in 
WRITING ASCII FILES as a staging area for data, to gather data and make 
simple calculations. I've have experienced problems with saving to .csv 
files, and not only using scientific notation. The problem occurs also 
in normal notation if you choose to show only some decimals.

That is a serious problem, what is the remedy?

To always avoid showing only some decimals and avoid scientific notation 
or does someone have a  better solution, like a global option, Save with 
full represention to .csv.

I'm open for all sorts of suggestions, including ditching Excel...and 
use ???

Cheers, Henrik

Patrick Burns wrote:
> 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 Statistics
> patrick at burns-stat.com
> +44 (0)20 8525 0696
> http://www.burns-stat.com
> (home of S Poetry and "A Guide for the Unwilling S User")
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! 
> http://www.R-project.org/posting-guide.html
>