[srrietveld bug] export to excel file

[dif...@diffpy.org]

reporter: monica....@unimi.it

summary: export to excel file

description: hi it's me again
when I export to an excel-like file (CVS export), it correctly creates a file with what I asked for (in my case it was just the cell parameter), but with "line nr, cell parameter" in the same column. It would be nice if the CVS file were a file directly readable by excel (I normally use TAB as a separator, as commas tend to be more messy)...
thanks
Monica

component: srrietveld

version: 1.0beta-r6746-20110902

traceback:
N/A

[xiaohao yang]

It seems the problem is caused by importing the CVS file into Excel. I
haven't encountered this problem in my Excel 2010 (windows 7). If your
excel does have this problem, you can try to import the CVS file
manually. Here is an instruction,

1. click 'Get External Data From Text' in 'Data' section (the button
name may different according to your office version)
2. choose the export CVS file
3. choose 'delimited' in step 1
4. choose 'comma' ONLY in step 2
5. hit finish in step 3

Best,

Xiaohao

> --
> You received this message because you are subscribed to the Google Groups "srrietveld-dev" group.
> To post to this group, send email to srrietv...@googlegroups.com.
> To unsubscribe from this group, send email to srrietveld-de...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/srrietveld-dev?hl=en.
>
>

--
Xiaohao Yang

Applied Physics & Applied Mathematics
Columbia University
500 West 120th Street
Room 200 Mudd, MC 4701
New York, NY 10027

Email: xy2...@columbia.edu

[Pavol Juhas]

Hi Monica,

Another thing to try is to just use the File-->Open menu and select
the "text, CSV, ..." format. It should load correctly right away -
at least that is what happens in my Excel 2003. Make sure the
file has extension .csv (comma separated values [NOT CVS]).

If there are still problems, please send us the offending CSV file.

Cheers,

Pavol

--
        Dr. Pavol Juhas

        Applied Physics & Applied Mathematics
        Columbia University

        Room 200 Mudd Building, MC 4701
        500 West 120th Street
        New York, NY  10027

[Simon Billinge]

Hi Monica, did these solutions work....is it an excel problem or a
SrRietveld problem? Just wanted to close this ticket with an
affirmation from you that the problem is solved.

S

> --
> You received this message because you are subscribed to the Google Groups "srrietveld-dev" group.
> To post to this group, send email to srrietv...@googlegroups.com.
> To unsubscribe from this group, send email to srrietveld-de...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/srrietveld-dev?hl=en.
>
>

--
Prof. Simon Billinge

Address for AY 2011-2012
ESRF
6 rue Jules Horowitz
BP 220
38143 Grenoble Cedex
FRANCE
+33438881936

Permanent addresses:

Applied Physics & Applied Mathematics
Columbia University

500 West 120th Street
Room 200 Mudd, MC 4701
New York, NY 10027

Tel: (212)-854-2918 (o) 851-7428 (lab)

Condensed Matter Physics and Materials Science Dept.
Brookhaven National Laboratory
P.O. Box 5000
Upton, NY 11973-5000
(631)-344-5661

email: sb2896 at columbia dot edu
home: http://bgsite.apam.columbia.edu