Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5

At 18:33 12/05/2016 +0200, Cley Faye wrote: 2016-05-12 17:04 GMT+02:00 Brian Barker: Such numbers are interpreted correctly (and can be displayed similarly) if the cells are formatted according to an appropriate language, that language either inherited from the locale or set explicitly in the

Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5

2016-05-12 17:04 GMT+02:00 Brian Barker : > > Such numbers are interpreted correctly (and can be displayed similarly) if > the cells are formatted according to an appropriate language, that language > either inherited from the locale or set explicitly in the Format

Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5

At 15:26 12/05/2016 +0200, Cley Faye wrote: ... having seen the file from a direct message, the problem is way simpler than a formatting/data type problem :) No, it *is* a problem of data format and interpretation. The problem is that you have something in your cell that is not *a* number

Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5.

Ok; having seen the file from a direct message, the problem is way simpler than a formatting/data type problem :) The SUM() function works to add values from cells. The problem is that you have something in your cell that is not *a* number (things like "3,94,700"). There is no way (that I know

Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5.

Hi, Piet van Oostrum wrote on 12-05-16 00:40: >> Now non-plussed how to tell libreoffice to tell it to treat them >> as 'real numbers' ? > > One way you can get numbers as text is when you import a CSV file, > This is another option:

Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5

At 16:03 11/05/2016 +, Shirish Agarwal wrote: I was trying a simple addition in column =SUM(B2:B8) but that didn't work. I am getting the output as zero. Could somebody look at it and share what is/was wrong? At 19:43 11/05/2016 +, Shirish Agarwal wrote: Dear Piet, Yours and a

Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5.

Also, format the column as numbers. That way when you enter a number it is recorded as such. If the column is formatted as text, and you input a number it is interpreted as a character. On 05/11/2016 03:40 PM, Piet van Oostrum wrote: shirish शिरीष wrote: > Dear Piet, > > Yours and a

Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5.

shirish शिरीष wrote: > Dear Piet, > > Yours and a private mail are bang on target. Libreoffice thinks that > those 'numbers' are text. This I was able to find via View > Value > highlighting . > > Now non-plussed how to tell libreoffice to tell it to treat them as > 'real numbers' ?

Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5.

2016-05-11 21:43 GMT+02:00 shirish शिरीष : > Now non-plussed how to tell libreoffice to tell it to treat them as > 'real numbers' ? > ​Short answer: it should work :) If a cell is somehow stuck in the "text" type, you could try clearing all formatting on this cell

Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5.

at bottom :- On 11/05/2016, Piet van Oostrum wrote: > The mailing list doesn't accept attachments. You could use Nabble for that > (http://www.libreoffice.org/get-help/nabble/) > > The simplest explanation would be that your "numbers" are entered as text. > Check

Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5.

Check cell formats and contents in B2:B8. SUM() will not add numbers within cells formatted as text or numbers preceded by a half quote. Per below the sum() result is 4 as such items are not summed. 4 '=SUM(B2:B8) 2 Cell number format with '2 (note the half quote) 3 Cell number format with '3

Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5.

shirish शिरीष wrote: > Hi all, > > I was trying a simple addition in column =SUM(B2:B8) > > but that didn't work . I am getting the output as zero. > > Could somebody look at it and share what is/was wrong ? > > Sharing an example worksheet for the same. > -- The mailing list

[libreoffice-users] Simple sum in column getting zero in libreoffice calc 5.

Hi all, I was trying a simple addition in column =SUM(B2:B8) but that didn't work . I am getting the output as zero. Could somebody look at it and share what is/was wrong ? Sharing an example worksheet for the same. -- Regards, Shirish Agarwal शिरीष अग्रवाल My quotes in