At 16:03 11/05/2016 +0000, 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 +0000, Shirish Agarwal 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'?
The example spreadsheet you sent me privately betrays the problem.
You are entering numbers using the style of the Indian numbering
system - where digits are grouped in twos except for the rightmost
three - instead of the system used in most regions of the world -
where digits are grouped in threes throughout. In that system, large
numbers are entered as, say, 1,23,45,678 instead of 12,345,678. If
you don't have your language or locale set appropriately, LibreOffice
will not recognise your entry as being a number and will instead
preserve your exact input as a text string.
It is very easy to solve this problem: you simply need to tell
LibreOffice that you are entering numbers in the Indian fashion. You
can do this most easily by setting your locale correctly in
LibreOffice (or perhaps even in your operating system before you
install LibreOffice). Go to Tools | Options... | Language Settings |
Languages | Language of | Locale setting, and choose an appropriate
value there. If you have that set to English (India), Gujarati,
Hindi, etc., you should find that Calc will accept numbers entered
with comma separation in the Indian style.
Alternatively, if you don't wish to set your locale to an Indian one,
you can set Indian style for number acceptance by formatting cells
appropriately before entering values. On the Numbers tab of the
Format Cells dialogue, there is a language selection drop-down menu
at the top right. If you select an Indian language there, you can
enter your values with comma separation in the Indian style.
Note that changing your locale will not automatically convert any
existing values. You can convert them using the VALUE() function,
providing that you have first set your locale or the cell format to
an appropriate Indian option. Alternatively, you can simply retype any values.
I trust this helps.
Brian Barker
--
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