[libreoffice-users] Re: sum function in libreoffice calc doesn't seem to work
Mark 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
[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
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
Re: [libreoffice-users] sum function in libreoffice calc doesn't seem to work
On Thu Nov 04 2010 10:42:56 GMT-0700 (PDT) Andy Brown wrote: On Thu Nov 04 2010 09:54:26 GMT-0700 (PDT) Mark wrote: Semicolon? No, it should be a colon. On Thu, Nov 4, 2010 at 2:48 AM, Stefano Fraccaro wrote: In my installation all works correctly... don't use comma but semicolon between parameters. Your both right, based on OS. Actually just ran a quick test on Ubuntu and WinXP. The ':' is used for a range (a1:a4) a ';' is changed to a ',' for two cells (a1,a4). Andy -- 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
Re: [libreoffice-users] sum function in libreoffice calc doesn't seem to work
On Thu Nov 04 2010 09:54:26 GMT-0700 (PDT) Mark wrote: Semicolon? No, it should be a colon. On Thu, Nov 4, 2010 at 2:48 AM, Stefano Fraccaro wrote: In my installation all works correctly... don't use comma but semicolon between parameters. Your both right, based on OS. -- 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
Re: [libreoffice-users] sum function in libreoffice calc doesn't seem to work
Hi, Am 04.11.2010 17:54, schrieb Mark: > Semicolon? No, it should be a colon. Well this depends on what you aim for. =SUM(A1:B10) sum up all from A1 to B10 =SUM(A1;B10) sum A1 and B10 Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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
Re: [libreoffice-users] sum function in libreoffice calc doesn't seem to work
Semicolon? No, it should be a colon. On Thu, Nov 4, 2010 at 2:48 AM, Stefano Fraccaro wrote: > In my installation all works correctly... don't use comma but semicolon > between parameters. > -- 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: MS Office -> LibreOffice (compatibility problem)
Le 2010-11-03 07:07, william drescher a écrit : On 11/3/2010 4:11 AM, Arda Tunccekic wrote: Hi people. Is this the place to get support for LibreOffice? I work in a company that have more than 200 computers and I am trying to migrate from MS Office to LibreOffice + Thunderbird. Uninstalling MS Office and installing LibreOffice is fun but sometimes there are problems that I can't find a solution (yet). I have a document (.docx) that cannot be displayed properly with LibreOffice and because of this MS Office fans in my company say that we need MS Office, we cannot do business without MS Office.. I've installed odf-converter-integrator-0.2.3, but still I can't see the graphic inside. Where can I get support for this? Thank you I am going through the same process in a much smaller office. Once my users find LibreOffice they prefer to not go back to MS. bill Nice to hear Bill. How many desktops have migrated? It sounds like they still have MSO installed as well? Marc -- 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: MS Office -> LibreOffice (compatibility problem)
On 11/3/2010 4:11 AM, Arda Tunccekic wrote: Hi people. Is this the place to get support for LibreOffice? I work in a company that have more than 200 computers and I am trying to migrate from MS Office to LibreOffice + Thunderbird. Uninstalling MS Office and installing LibreOffice is fun but sometimes there are problems that I can't find a solution (yet). I have a document (.docx) that cannot be displayed properly with LibreOffice and because of this MS Office fans in my company say that we need MS Office, we cannot do business without MS Office.. I've installed odf-converter-integrator-0.2.3, but still I can't see the graphic inside. Where can I get support for this? Thank you I am going through the same process in a much smaller office. Once my users find LibreOffice they prefer to not go back to MS. bill -- 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
Re: [libreoffice-users] Re: MS Office -> LibreOffice (compatibility problem)
Same result I put 3 blank line, 1st line of text, 1 image below the 1st line of text, 2nd line of text, other blank lines... When you open with Lib0 there are only blank and text lines... image anchor is correctly on line 5 but there is no visible content. Il 03/11/2010 22.06, Michel-André Robillard ha scritto: LO all: I always had problem with an image on the first line of a page when the anchor is on the left of the first line. Try to make a three lines document and put the image on the second line to see what will happen... Michel-André ** -- 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
Re: [libreoffice-users] sum function in libreoffice calc doesn't seem to work
In my installation all works correctly... don't use comma but semicolon between parameters. Il 03/11/2010 23.12, bill woodruff ha scritto: To Whom It May Concern: I don't want to sound nuts or something, but I just in stalled LibreOffice 3.3.0 (build 3.2.99.2)and when I attempt to do a =SUM function on a column in a spreadsheet, it doesn't work. It won't recognize the range of cells defined by the mouse. And when I manually insert the range (i.e., =SUM(C2,C46)) it returns a result of 0 (zero). Shouldn't a working =SUM function be one of the basic elements of a spreadsheet? I'm sure it's my fault. Could someone please explain what I'm doing wrong? 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
