Aug 19th, 2011, 5:58 AM
Hello!
One other problem is, that CSV means comma separated values but Excel has difficulties with importing/accepting files with comma as separator. A great idea would be to have a chance to modify this (i.e. to set it to semicolon, which is good for Excel). Alternatively OpenOffice/LibreOffice works really good with the files, but has also problem when finding a separator as field text, because it's not surround by quotes.
To solve my problem for most of the users, I told them to use HTML-Export (which is in fact almost the same as Excel - just look into the files) and import this into Excel or LibreOffice.
With regards,
Peter.
P.S.: When I have a little bit of time (and silence around me) I'll go to 2.1.x and see what's with the export there...
One other problem is, that CSV means comma separated values but Excel has difficulties with importing/accepting files with comma as separator. A great idea would be to have a chance to modify this (i.e. to set it to semicolon, which is good for Excel). Alternatively OpenOffice/LibreOffice works really good with the files, but has also problem when finding a separator as field text, because it's not surround by quotes.
To solve my problem for most of the users, I told them to use HTML-Export (which is in fact almost the same as Excel - just look into the files) and import this into Excel or LibreOffice.
With regards,
Peter.
P.S.: When I have a little bit of time (and silence around me) I'll go to 2.1.x and see what's with the export there...