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, when tell it to use | as field separator. Lets assume the payments imports (-100.25 and -50.25) end up in cells F1 and F2 if I write in a third cell the formula =sum(F1:F2) I get zero, because F1 and F2 are seen as text. OK, so I select those cells and do Format->Cells->Numbers->Number = -1234.12 But I still get zero, because the operation above adds to the content of \both F1 and F2 a single quote prefix: F1 = '-100.25 F2 = '-50.25 which, right now, I have to remove manually to make the formula work. What is happening, and how can I fix it? Even better: how to make LO automatically format and use strings in the format -1234.12 as numbers when it opens the file? Thanks, Marco -- M. Fioretti http://mfioretti.com http://stop.zona-m.net Your own civil rights and the quality of your life heavily depend on how software is used *around* you -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted