Version: 2.1.0 (using KDE 4.3.3) OS: Linux Installed from: Ubuntu Packages When the system date format is set to dd.mm.yyyy and a file with dates entered as m/d/yy is opened they are not recognized as date fields. Manually changing the cell type to the correct format does not help. One would have to reenter the dates in the system format, afterwards they would be displayed in the custom format. Since they aren't recognized as dates they are not sorted for example as: 11/20/09 11/19/09 11/2/09 but rather: 11/20/09 11/2/09 11/19/09 Attached is a test case that was originally a CSV file and then saved as ODS with Kspread. Opening it in Calc, the date fields are set to literal strings, such as: '11/9/09 Thus, one first needs to remove the ' to be able to use date sorting in Calc.
Created attachment 38686 [details] Example of dates saved as strings
Dear Bug Submitter, This bug has been stagnant for a long time. Could you help us out and re-test if the bug is valid in the latest version? I am setting the status to NEEDSINFO pending your response, please change the Status back to REPORTED when you respond. Thank you for helping us make KDE software even better for everyone!
Dear Bug Submitter, This is a reminder that this bug has been stagnant for a long time. Could you help us out and re-test if the bug is valid in the latest version? This bug will be moved back to REPORTED Status for manual review later, which may take a while. If you are able to, please lend us a hand. Thank you for helping us make KDE software even better for everyone!
Thank you for reporting this issue in KDE software. As it has been a while since this issue was reported, can we please ask you to see if you can reproduce the issue with a recent software version? If you can reproduce the issue, please change the status to "REPORTED" when replying. Thank you!
Dear Bug Submitter, This bug has been in NEEDSINFO status with no change for at least 15 days. Please provide the requested information as soon as possible and set the bug status as REPORTED. Due to regular bug tracker maintenance, if the bug is still in NEEDSINFO status with no change in 30 days the bug will be closed as RESOLVED > WORKSFORME due to lack of needed information. For more information about our bug triaging procedures please read the wiki located here: https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging If you have already provided the requested information, please mark the bug as REPORTED so that the KDE team knows that the bug is ready to be confirmed. Thank you for helping us make KDE software even better for everyone!