https://bugs.documentfoundation.org/show_bug.cgi?id=171096
--- Comment #1 from ady <[email protected]> --- This is a common misunderstanding of what the import text dialog is supposed to do. When importing data, you are telling Calc in which way the data should be interpreted. This is not the same as the way the destination cell is (nor should be) formatted. Moreover, imposing the choices made during the import procedure over the format of the destination cells will cause all sorts of problems. A typical example is when importing data that should be interpreted/parsed as dates, in the DMY format. Calc takes the literal data in the Import Text dialog column as "DMY" (whether it is DD/MM/YY, or D/M/YYYY or whichever similar data). The destination cells could be formatted as YYYY-MM-DD, which is completely different than the way the original literal data was initially imported. So, if you want the cells to be considered as Text, simply format the cells as Text ("@"), and so whichever edition you perform, the new value will still be interpreted as Text. That is precisely the reason for the Text cell format to exist in the first place. IMNSHO, -1. -- You are receiving this mail because: You are the assignee for the bug.
