https://bugs.freedesktop.org/show_bug.cgi?id=66985
--- Comment #10 from Parameshwara Bhat <[email protected]> --- (In reply to comment #9) > After all I think that everything works as expected. The sheet looks the > same in MS Office and LO. you are missing the important point. You may check it when you have opened the file in MSO. It lets you work with numbers as numbers and dates as dates.It senses the true nature of data. It will keep them left aligned, but will not come in the way of doing any mathematical operation on them. In LO, you cannot do any mathematical operation on them. If you highlight multiple cells, sum of the cells is zero.The numbers with apostrophe behind are shown as numbers in cell format dialog. You change them to specific number format, no error is generated.But there is no change in the status either. You will not be able to convert them. so, to deal with them you either have to manually and tediously remove apostrophes, or resort to ugly hacks like " find '^.' and replace with '&' ". Finding ' and replacing with nothing did not work for me, though some people have reported it to work. LO fails to find apostrophe. Anyway,they are not for common users. As far as common users are concerned, the file from the Bank is not workable. Removing apostrophes manually is way too tedious for large data.Changing the format will not work. Interestingly, calligra sheets will open the file perfectly and let you work with numbers as numbers and date as dates though they are left aligned as they are formatted as text. additionally, when I see the cell format property, it will correctly show the format as text, not as general number.Even then,without changing the format, it will let you work with numbers as numbers and date as dates. If you change the format to number, it will save the cell as number when saved even in OD format and remember it as number when opened again. But this ods file if opened in LO will still be showing the numbers as text and not deal with them as numbers. You open the same ods file again in calligra sheet, the reformatted cells would remain re-formatted. It is not a question of formatting. It is a question of dealing with data. Formatting a numerical data as text with apostrophe is end of story in LO for that number. You cannot have it as number again through any means other than physically removing apostrophe or hacking at it. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
