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 mfiore...@nexaima.net 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

[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,

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|

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 mfiore...@nexaima.net 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

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. Here