Re: [libreoffice-users] cannot convert text to number in spreadsheet from csv file

2014-04-20 Thread Heikki Jussila
On Sunday, 20 April 2014, M. Fioretti wrote: > On Sat, Apr 19, 2014 23:44:20 PM -0700, Owen Genat wrote: > > M. Fioretti wrote > > > Summarizing, it seems I need some efficient way to tell Calc, when it > > > opens that file, that all the cells of a certain column, except the > > > header, are NU

Re: [libreoffice-users] cannot convert text to number in spreadsheet from csv file

2014-04-19 Thread M. Fioretti
On Sat, Apr 19, 2014 20:05:40 PM +0200, Marco Fioretti wrote: > Greetings, > > I have the problem below with LO 3.5.7.2 on a Fedora box. > > I have a shell script that generates and save to a text file called > synthesis.csv many lines like this: thanks to all who quickly answered yesterday. He

Re: [libreoffice-users] cannot convert text to number in spreadsheet from csv file

2014-04-19 Thread Mirosław Zalewski
Dnia 2014-04-19, o godz. 20:05:40 "M. Fioretti" napisał(a): > What is happening, Judging by your name, I suppose you are Italian. I assume that you are using LibreOffice in your native language, and in Italy, as in most of Europe, you are using coma as decimal number separator. And here is answ

Re: [libreoffice-users] cannot convert text to number in spreadsheet from csv file

2014-04-19 Thread Brian Barker
At 20:05 19/04/2014 +0200, Marco Fioretti wrote: I have the problem below with LO 3.5.7.2 on a Fedora box. I have a shell script that generates and save to a text file called synthesis.csv many lines like this: |||2013-02-15|Payment A|-100.25|008|fae| |||2013-03-15|Payment B|-50.25|008|fae| C

[libreoffice-users] cannot convert text to number in spreadsheet from csv file

2014-04-19 Thread M. Fioretti
Greetings, I have the problem below with LO 3.5.7.2 on a Fedora box. I have a shell script that generates and save to a text file called synthesis.csv many lines like this: |||2013-02-15|Payment A|-100.25|008|fae| |||2013-03-15|Payment B|-50.25|008|fae| Calc loads that file without problems, w