Created attachment 133724 [details] CSV File 1. Import CSV File 2. Change first column to date "DD/MM/YYYY" 3. Order column by date Dates are ordered as a string, because an ' is appended to the beginning. If ' is removed, calc orders the column correctly.
Hi Eduardo, I didn't reproduce with LO 5.3.3.2 Build ID: 3d9a8b4b4e538a85e0782bd6c2d430bafe583448 Threads CPU : 2; Version de l'OS :Windows 6.1; UI Render : par défaut; Moteur de mise en page : nouveau; Locale : fr-FR (fr_FR); Calc: CL "Detect special numbers" was it ticked when you imported the datas?
Created attachment 133731 [details] Import dialog (default)
Created attachment 133732 [details] appearance after import (everything ok)
Created attachment 133733 [details] Change column type dialog (default)
Created attachment 133734 [details] After column type change (error, see red square)
Hi Jacques, thanks for taking time to verify this. I've added 4 attachments. 1. CSV file you need to open 2. Import dialog (in spanish) 3. Calc after importing the file ( appearance after import ) 4. Change column type dialog 5. Appearance after changing the column type You will see the dates correctly in the cell, but if you see the formula you will see that the dates are appended with '. Ex: DD/MM/YYYY => 'DD/MM/YYYY Hope you can reproduce this error. Answering your question: I've tried with those options checked and unchecked it doesn't change anything, imported file results in the same output.
Thanks. Just Untick "Quoted field as text" -> "Campo entrecomillado como texto" in the import dialog. That's why I didn't reproduce. Jacques
Hi Jacques, first of all thanks! can i buy you a beer? I would like to know if it's an expected behaviour? If a quote is added in the field when importing the CSV, it should appear clearly in the cell, like '12/05/2017 and not once the user has changed the cell type? Thanks!
Forgot to change status
Created attachment 133785 [details] a way to reproduce. This is the usual behaviour. Most of the time, those apostrophes (simple quote marks) are added when we import table from web or a database. They are texts and, with or without apostrophe, they are aligned to left. This behaviour can be reproduce. I joined a document to show how it works. Column A was first text formated and filled next with numbers. Column B is a copie of column A, but an apostrophe was automaticly added at the copie time. Column D is get from column C by a formula, and give also a quoted column E by copie. Column B as column E can be transform to values by selecting them and Data > Text to columns… Another way to do that is to multiply by 1 or use a formula like =VALUE() Ok for the beer the next time we meet. Jacques