Hi,
I am using the latest version of Heidi (9.5.0.5196). I exported a database selection as excel csv. Excel (MS Office 365) does not recognised it correctly and does not display the data in columns but instead the full line in one cell. The export is comma-separated where Excel expected semikolon-separated data. Adding "sep=," manually in a text editor to the csv file makes Excel show the file like expected. With a previous version of Heidi it worked fine (9.3.something)!
Two questions arise for me:
-
Why has the default separator for Excel export changed.
-
Why is the dropdown selection disabled where I can choose the separator in case of Excel export?
To 2) I have to add, that I also tried to export as "Delimited text" but then I get problems with return characters that are available in some data base entries. This I come around when using " as encloser (default blank). But I think the Excel export should work right away and I should not need to try different setting until it works.
Thanks anet