LibreOffice calc sorts numerical data as text

[Atulkakrana]

Hi All,

I am using LibreOffice calc 3.6.0.2 and having problems in sorting the data. When I try to sort numerical data it is sorted as text rather than values. For ex: this is result of sorting in descending order and you can see 99 comes before 973

996

99

99

973

973

970

If I do that in Office 2010 than data is sorted perfectly.Please tell me how can I sort the columns on basis of value rather than being treated as text.

AK

[Atulkakrana]

Please don’t bother to answer this question as this is a bug in libO 3.6.0.2. I have downgraded to the version that comes with Ubuntu and my life is back to normal.

Not only this I found many bugs in LibO 3.6.0.2 like not being able to save on network location.

Thanks

Atul