Evil spaces in csv files

[GoogleCodeExporter]

This is not a big issue. It's just a small enhancement.

In generated comma separated files there is a space just before each value:
"""
s,C,C
FDS Time,"NE_broke","NW_broke"
 0.0000000E+000, 2.0000000E+001, 2.0000000E+001
"""

Before importing to Openoffice.org Calc, I always have to hand
search-and-replace the " " with "null" in a text editor to obtain:
"""
s,C,C
FDS Time,"NE_broke","NW_broke"
0.0000000E+000,2.0000000E+001,2.0000000E+001
"""

I must admit that MS Excel does not have this "problem".

If it's really easy to fix, please remove those small evil spaces.
Thank you in advance.
Emanuele Gissi

Original issue reported on code.google.com by emanuele.gissi on 26 May 2009 at 7:29

[GoogleCodeExporter]

where would the minus sign go?

Original comment by mcgra...@gmail.com on 26 May 2009 at 11:12

• Changed state: MoreInfo

[GoogleCodeExporter]

Is it possible to add the place for the minus sign only if needed?
That is:
0.0000000E+000,2.0000000E+001,2.0000000E+001 when positive, and
-0.0000000E+000,-2.0000000E+001,-2.0000000E+001 when negative?

I tried:
+0.0000000E+000,+2.0000000E+001,+2.0000000E+001 but Openoffice does not 
recognize it.

Emanuele

Original comment by emanuele.gissi on 26 May 2009 at 3:01

[GoogleCodeExporter]

No, I am just using standard Fortran I/O. Sorry.

Original comment by mcgra...@gmail.com on 26 May 2009 at 3:53

• Changed state: WontFix

[GoogleCodeExporter]

Ok. I understand. I am going to Openoffice issue page now.
Thank you for your time.
Emanuele

Original comment by emanuele.gissi on 26 May 2009 at 4:43