https://bugs.freedesktop.org/show_bug.cgi?id=67673
--- Comment #11 from Marcel Samek <[email protected]> --- I have experimented a bit more with mixed data in the columns and now I understand what is happening: When you select a column and mark it as "Text", Calc goes through and identifies all the cells that have numberic data in them and changes the format to "Text", but it leaves all the cells that have non-numeric data alone and leaves them as "Number". The result is that the spreadsheet now has a column with mixed data in it. The reason that this behavior is annoying and why I consider it a bug is this: When I imported the text column, in the import column I marked it as text and thought I was done. It was only later than I realized that sorts on that column were not sorting that column properly. They were in a bizzare order and I started digging into the problem. The way the current functionality is set up means that the "column type" setting in the import dialog is essentially useless because you are not guaranteed that it will actually set the column type. After the data has been imported, you have to go an set the format of the cells again. If you mistakenly believe that the column type setting in the import panel actually sets the column type, then none of your data sorting will work properly for text data. Best regards, Marcel -- 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
