Re: [libreoffice-users] Re: sum function in libreoffice calc doesn't seem to work

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 <reikibill2002@aol.com>
To: users@libreoffice.org
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 users+help@libreoffice.org 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 users+help@libreoffice.org 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