[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)
Hello, Plino: 

This is a second reply. After I wrote you earlier, I tried re-importing
the .csv file. This time, I clicked on the "Standard" heading on top 
of the column in question, hoping there would be a format for "Currency."
There was none, but after I clicked "Hidden" then clicked back to 
"Standard," the file imported with the currencies properly recognized 
and aligned to the right. 
Now the =SUM(c2:c46) function works just fine. I am sorry for wasting 
so many people's time, but I could not figure this out by myself. I am 
very grateful to everyone involved for their suggestions. 
One final question: Shouldn't the Import function recognize currencies 
automatically rather than making the user jump through these hoops? 

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