https://bz.apache.org/ooo/show_bug.cgi?id=103166
orcmid <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Ever confirmed|0 |1 Resolution|FIXED |--- Assignee|[email protected] |[email protected] | |g Status|CLOSED |REOPENED CC| |[email protected] QA Contact|[email protected] | --- Comment #9 from orcmid <[email protected]> --- (In reply to albrecht Faust from comment #8) > Comment on attachment 63256 [details] > Budget Calc file does not sort by date correctly > > Calc sorts according to the string representation of the date - but this > does not help in case of a date format DD.MM.YYYY Ooh, right. It should sort by the DateTime numerical value that is actually in the cell. That will always get it right unless the user does something very strange. This would depend on the cell actually being Numeric but formatted to present as a date or time-span. If any of the cells involved have text value, there's not much to be done, although sorting might help the user recognize what can be an easy mistake. I am reopening until we verify this aspect. -- You are receiving this mail because: You are the assignee for the issue. You are on the CC list for the issue.
