Bill My experience with importing csv files has shown me that the data is formatted by the exporting source program more than by the importing target program. So I guess I am trying to defend LibreOffice in some small way. When you export the data to a csv from the other program make sure it does not format everything as text. I work with a program on my smart phone that exports data to a csv file that I can then manipulate with LibreOffice Calc. That program is the one that formats the data as text or numbers. There is one field that is a number field on my smartphone but when I open it in Calc it is formatted as text. I don't know if there is a way to do a Find/Replace with Regular Expressions to convert selected cells or not. I hope this helps. John McAtee
From: bill woodruff <[email protected]> To: [email protected] Cc: Sent: Saturday, November 6, 2010 8:47:51 PM Subject: [libreoffice-users] Re: sum function in libreoffice calc doesn't seem to work plino <pedlino <at> gmail.com> writes: > > > Bill, do the cells in the range contain only natural numbers? > > I suspect that you are having a problem with the decimal separator. > > Your cells are probably identified as text because of that (are the values > aligned to the left?) > > Paste this in cell D2 to check > =VALUE(C2) > PLino: Thank you very much for your reply. Yes, the figures are aligned left. They were imported from a .csv file. However, attempts to re-format the column as currency fail to to anything except to add an apostrophe ('), which I believe denotes "text", to the front of each entry. If I manually access each cell, I can delete the apostrophe ... but this is way too much work. I have tried to re-import the .csv file, but there are no options (which I can see) to designate a specific column as currency (or some other format). I would appreciate further suggestions. I was a big fan of OpenOffice and I have high hopes for LibreOffice ... but these spreadsheet difficulties are not helping me. Sincerely/Bill Woodruff -- E-mail to [email protected] for instructions on how to unsubscribe List archives are available at http://www.libreoffice.org/lists/users/ All messages you send to this list will be publicly archived and cannot be deleted -- E-mail to [email protected] for instructions on how to unsubscribe List archives are available at http://www.libreoffice.org/lists/users/ All messages you send to this list will be publicly archived and cannot be deleted
