| Summary: | Calc's date format fails | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Robert <rwg26> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | REOPENED --- | ||
| Severity: | normal | CC: | buzea.bogdan |
| Priority: | medium | ||
| Version: | 24.2.4.2 release | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Windows (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 108252 | ||
|
Description
Robert
2024-06-13 14:21:01 UTC
The "dates" weren't imported as numeric dates but text strings that look like dates (hence the leading ' apostrophe when viewing the cell to indicate it could be a date if it wasn't text). In the CSV import dialog either choose a proper import locale that matches the data, e.g. English-US, or set individual column types to Date MDY in this case. See also this FAQ https://wiki.documentfoundation.org/Faq/Calc/How_to_convert_number_text_to_numeric_data Not a bug. Libra Calc added the comment quote when I set the format to date. THAT is the bug. This is east to test. Save these three lines as test.csv 05/20/2024, first line 20/05/2024, Eur date 06/13/2024, US date Open test.csv with Calc Format the first column as date Look at how Libra Calc change the data from a date to a comment, Except the Eur date style (In reply to Robert from comment #2) > Open test.csv with Calc > > Format the first column as date That will not work. As part of the *Import dialog* (not after importing the data), you have to select the column and change the header, from Standard (or General) to one of the available Date formats (DMY, MDY, YMD) in the same Import dialog. You might also want to modify the Locale field in the upper area of the same Import dialog, if necessary. But even then, assuming that for some reason the available Date formats in the Import dialog are not enough or fail in some way, you can still convert the "text" to numbers, and then format the result as Date in whichever customized format you would want. I agree with comment 1 that this is not a bug. Since you reopened the report, I'll leave it without change. I hear what you are saying BUT Open that same CSV file with Excel, and you get dates Open that sane CSV file with Google Sheets. and you get a date Open that same CSV file with Spread32 and you get a date So, if this is not considered a bug, then it should be considered a new feature. You can close this, because it's a show stopper for my needs. I'll check back in a couple of years and see if LiberOffice can address my needs (In reply to Robert from comment #2) > Libra Calc added the comment quote when I set the format to date. THAT is > the bug. > > This is east to test. > Save these three lines as test.csv > > 05/20/2024, first line > 20/05/2024, Eur date > 06/13/2024, US date > > Open test.csv with Calc > > Format the first column as date > > Look at how Libra Calc change the data from a date to a comment, Except the > Eur date style I reported this months ago. It was deemed "not a bug"...Every other software I have come across handled this matter the way you have described. What I could not understand is why LO would add the `'' at the beginning. I didn't see it till I pasted the cell contents into notepad and enlarged the font. I am sure I am not alone. |