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 (things like "3,94,700").
But those *are* numbers - just expressed according to the Indian numbering system; see
https://en.wikipedia.org/wiki/Indian_numbering_system .
There is no way (that I know of...) to interpret that as a number, so it is seen as a string.
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 Cells dialogue. LibreOffice is cleverer than you think!
Brian Barker
-- To unsubscribe e-mail to: users+unsubscribe@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