Le jeudi 30 juillet 2015, Simon Slavin <slavins at bigfraud.org> a ?crit :
> > On 30 Jul 2015, at 9:57pm, Sylvain Pointeau <sylvain.pointeau at gmail.com > <javascript:;>> wrote: > > > no it does not work double clicking on the csv to open it in excel, I am > > 100% sure (I just tried again), you have to go through the data->import > and > > set up the columns as text for it to work > > Yes, as I wrote, this bad behaviour (which you could reasonably call a > bug) is documented. That's how Microsoft wrote Excel and that's the way > they want it to work, and that's how it will continue to work. > > Simon. > > There is a workaround for the leading 0, but you cannot have multi-line when doing this. It is one or the other, too bad! I though generating xml for excel instead of csv, but I didn't have time to try yet.
