https://bugs.documentfoundation.org/show_bug.cgi?id=162832
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #11 from ady <[email protected]> --- (In reply to spohorsky from comment #8) > Dear ady, > I will try to meet you halfway by adding this XLS formatted file. In my > current state, that is about as much as I can contribute to the LibreOffice > project. Actually, I will go further and add SortExample2.xls, which kind > of solves the initial problem. There are several points to clarify here. * It is fine if you don't want to install a newer version of LO (whether in parallel or as an upgrade of your current older version). * Bug reports should be confirmed in current versions, by someone. A potential bug that might be present in an older version but that cannot be replicated with newer versions (and, in particular, in a recent development version) of LO is no longer relevant from the POV of developers. * The Summary field of this report ATM says: "Incorrect sort using 12 hour clock in LibreOffice Calc". According to your own prior comments, you are able to achieve the goal correctly. The inconvenient you seem to have is not about sorting, but about how to import the CSV in order to immediately use the data as you expect (i.e. not as text but as cells formatted as date and time, respectively). * Even with an older version as 6.4, the import dialog allows to parse each column of data as dates (instead of standard text or number). Considering the comments about an apostrophe preceding the content of each cell, I guess that you did not try such possibilities, already provided in the import dialog. Even then, YMMV. * Calc cannot be responsible of how exactly the raw data in the csv is provided. For Calc, there _might_ be some inconveniences (i.e. potential enhancements) when importing time-only values (i.e. columns) of data, but that is not the focus in this bug report. * Based on prior comments, this report seems more related to "how to achieve X" rather than an actual bug in Calc. Since the problem with sorting times in Calc seems solved by itself (in terms of being – or not – a bug in Calc), and based on comment 10, I would suggest going to <https://ask.libreoffice.org> and ask your questions there, leaving this site for actual bug reports and enhancement requests – testing with development versions is essential for the latter. Would you agree that, in terms of being a bug report, this one can be closed? -- You are receiving this mail because: You are the assignee for the bug.
