https://bugs.documentfoundation.org/show_bug.cgi?id=153760
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|NOTABUG |--- Ever confirmed|0 |1 Status|CLOSED |REOPENED --- Comment #5 from ady <[email protected]> --- This doesn't seem to be a problem in sorting, but rather a problem with alignment and the type of content. All cells with data in column A are aligned as "default" and the number format is "text" (@), but the first 2 cells seem to be not treated as text by ISTEXT(), which explains the resulting sorting. This is a problem!!! When clearing the format (CTRL+A, CTRL+M), it is clear that not all the values are formatted in the same way, but the format cell dialog didn't show it at first. Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: c3bd52f81bf733a0b9b0560794a54b2ac1e0f444 CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (es_AR); UI: en-US Calc: CL threaded -- You are receiving this mail because: You are the assignee for the bug.
