[libreoffice-users] Re: sum function in libreoffice calc doesn't seem to work
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 numbers does the trick. Of -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: sum function in libreoffice calc doesn't seem to work
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 all i have) just to have a look at how the info is presented. Searchreplace is often useful. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/sum-function-in-libreoffice-calc-doesn-t-seem-to-work-tp1839208p3479861.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: sum function in libreoffice calc doesn't seem to work
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 Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: sum function in libreoffice calc doesn't seem to work
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 thing is once you change these settings once they become the default setting. -- View this message in context: http://nabble.documentfoundation.org/sum-function-in-libreoffice-calc-doesn-t-seem-to-work-tp1839208p3478365.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: sum function in libreoffice calc doesn't seem to work
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 numbers imported from CSV. -- View this message in context: http://nabble.documentfoundation.org/sum-function-in-libreoffice-calc-doesn-t-seem-to-work-tp1839208p3477876.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[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+h...@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
[libreoffice-users] Re: sum function in libreoffice calc doesn't seem to work
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 in context: http://nabble.documentfoundation.org/sum-function-in-libreoffice-calc-doesn-t-seem-to-work-tp1839208p1847724.html Sent from the Users mailing list archive at Nabble.com. -- E-mail to users+h...@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
[libreoffice-users] Re: sum function in libreoffice calc doesn't seem to work
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 disable the box Same as locale setting it will type the point and as soon as I press enter it will convert it to a date. This is a clear mistake since a point is not a separator in Portugal... i.e. typing 2.3 is converted to 02-03-2010 which is value 40239 -- View this message in context: http://nabble.documentfoundation.org/sum-function-in-libreoffice-calc-doesn-t-seem-to-work-tp1839208p1843520.html Sent from the Users mailing list archive at Nabble.com. -- E-mail to users+h...@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
[libreoffice-users] Re: sum function in libreoffice calc doesn't seem to work
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 available at http://www.libreoffice.org/lists/users/ All messages you send to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: sum function in libreoffice calc doesn't seem to work
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 directly from the spreadsheet. However, it still returns a result of 0 (zero). I've been working with spreadsheets (mostly Excel) since the days of Lotus Symphony. I had high hopes for LibreOffice and have had good results with the document package so far. But this spreadsheet behavior is driving me nuts. I would appreciate any suggestions. Would you like me to e-mail you a copy of the spreadsheet? Sincerely/Bill Woodruff -- E-mail to users+h...@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
