Bravo! This was just the solution/explanation I needed!
joshsimpson josh.simpson at gmail.com writes:
So after some experimentation I've hit upon an easy fix for importing CSV
files with numbers ... changing the text delimiter to ' and selecting
Quoted field as text and Detect special
Hi :)
Different devices or programs might decide to use different ways of defining
what a column contains and might also vary as to whether it treats a
particular column as a number or as text.
Typically i would open a Csv file with a text-editor such as Scite, Gedit or
even Notepad (if that's
Get the Extension CT2N, which is convert text2 Numbers.
You only jump through one loop then.
Tink.
--
View this message in context:
http://nabble.documentfoundation.org/sum-function-in-libreoffice-calc-doesn-t-seem-to-work-tp1839208p3481046.html
Sent from the Users mailing list archive at
So after some experimentation I've hit upon an easy fix for importing CSV
files with numbers ... changing the text delimiter to ' and selecting
Quoted field as text and Detect special numbers does the trick. Of
course you have to save the file before you can SUM or do anything else.
The nice
I'm having this same problem and I must admit, this is a deal breaker for
LibreCalc for me and possibly for Linux since I can't use VMWare on kernel
3.0.o.1.
Going to try Google Docs but I am stunned that LibreOffice makes you jump
through so many hoops to using the SUM function on a column of
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
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)
--
View this message
Actually it depends on your Language Settings.
And LibreOffice inherited the problems from OpenOffice...
E.g. for Portuguese (European) the decimal separator is a comma(,) but if I
prefer to use a point (because most international publications are formatted
according to US notation) when I
Am 03.11.2010 23:12, bill woodruff wrote:
mouse. And when I manually insert the range (i.e., =SUM(C2,C46))
it returns a
result of 0 (zero).
You try to sum numeric text (a sequence of digits).
--
E-mail to users+h...@libreoffice.org for instructions on how to unsubscribe
List archives are
Mark mhullrich at gmail.com writes:
A sum range is =SUM(C2:C46) - could that be (part of) it?
Mark
Hello, Mark:
Thank you for your prompt reply. I apologize, but I mis-punctuated
my original message. The formula, as you correctly observe, is =SUM(C2:C46)
--and that's pasted
10 matches
Mail list logo