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