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

2014-04-20 Thread M. Fioretti
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 NUMBERS, not text, in the -1234.12 format. > > What Mirosł

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

2014-04-19 Thread Owen Genat
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 NUMBERS, not text, in the -1234.12 format. What Mirosław Zalewski has suggested upthread is essentially correct. The data fo

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

2014-04-19 Thread Luuk
On 19-4-2014 20:05, M. 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: |||2013-02-15|Payment A|-100.25|008|fae| |||2013-03-15|Payment B|-50.25|008|fae|