Problems using csv file in Calc
I'm using LO 3.3 Final on Windows (Vista) and have come across a couple of problems with using/manipulating data loaded as a csv file.
1. I have a number of columns that contain numeric data but when I either select a few cells or the entire column Calc does not display the Sum in the Status area. It says Sum = 0!
If I type in some numbers into unused cells it does display the Sum.
2. In order to try and solve #1 I tried to reformat the cells. When I set a numeric format LO doesn't change the format and also it appends an apostrophe/single quote to the front of the data in each of the cells!
Both these functions work in OO3.2. When I import the file into LO the data is displayed differently - OO converts cells that contain numeric data into numbers - even when they are contained in " " while LO appears to be treating them as strings.
My main use of calc is manipulatiing data in csv files that has either been extracted or is to be processed by a legacy system (Cobol running on Linux). These problems render it pretty useless for that at the moment and I've had to go back to using OO for the time being.