[Libreoffice-bugs] [Bug 132332] Numerical cells with hyperlinks are sorted non-numerically
https://bugs.documentfoundation.org/show_bug.cgi?id=132332 --- Comment #11 from Nadie Nada Nunca --- ... well, it's been a year, and the bug persists in LO 7.2. Is there any hope for this to be fixed? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 132332] Numerical cells with hyperlinks are sorted non-numerically
https://bugs.documentfoundation.org/show_bug.cgi?id=132332 --- Comment #10 from Andreas Heinisch --- The problem is that LO treats cells with hyperlinks as strings and sorts numbers before strings. Maybe we can check, if the value in the cell can be treated as numeric value and sorted accordingly, but I can't tell if additional problems arise by doing this. Are there some cases where this should not be done? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132332] Numerical cells with hyperlinks are sorted non-numerically
https://bugs.documentfoundation.org/show_bug.cgi?id=132332 Ming Hua changed: What|Removed |Added Version|6.2.8.2 release |5.2.7.2 release Blocks||108386 --- Comment #9 from Ming Hua --- Also reproduced with 5.2.7, the oldest version I have: Version: 5.2.7.2 (x64) Build ID: 2b7f1e640c46ceb28adf43ee075a6e8b8439ed10 CPU Threads: 2; OS Version: Windows 6.19; UI Render: default; Locale: zh-CN (zh_CN); Calc: group Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108386 [Bug 108386] [META] Calc sorting related bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132332] Numerical cells with hyperlinks are sorted non-numerically
https://bugs.documentfoundation.org/show_bug.cgi?id=132332
--- Comment #8 from Ming Hua ---
Created attachment 159881
--> https://bugs.documentfoundation.org/attachment.cgi?id=159881=edit
A simplified sample file
This is another sample file, simplified to 2 columns and 4 rows.
Both cell A3 ("2") and B4 ("cake") contain hyperlinks. Sorting by text (column
B) gives expected result, while sorting by number (column A) puts the row with
"2" after 1, 3, and 4.
--
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132332] Numerical cells with hyperlinks are sorted non-numerically
https://bugs.documentfoundation.org/show_bug.cgi?id=132332 Ming Hua changed: What|Removed |Added Version|6.4.2.2 release |6.2.8.2 release CC||ming.v@qq.com Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #7 from Ming Hua --- I can reproduce with 6.2.8 on Windows 10: Version: 6.2.8.2 (x64) Build ID: f82ddfca21ebc1e222a662a32b25c0c9d20169ee CPU threads: 2; OS: Windows 10.0; UI render: default; VCL: win; Locale: zh-CN (zh_CN); UI-Language: en-US Calc: threaded Steps: 1. Open the attached sample file; 2. Click in cell B1; 3. Data > Sort Descending (Sort Ascending works too, but it doesn't change the current order of the cells); 4. Observe that row 2 to 72 are sorted, but all years with links are considered larger than the ones without links. Row 73 and higher are not sorted probably because B73 is empty and therefore seen as the border of the auto-recognized region for sorting. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132332] Numerical cells with hyperlinks are sorted non-numerically
https://bugs.documentfoundation.org/show_bug.cgi?id=132332 --- Comment #6 from Nadie Nada Nunca --- Just a note: this should be absolutely independent from locale. Whether a number is linked to anything else has no bearing on how it should be sorted. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132332] Numerical cells with hyperlinks are sorted non-numerically
https://bugs.documentfoundation.org/show_bug.cgi?id=132332 --- Comment #5 from m.a.riosv --- Sorting by column B, works for me. Version: 6.4.3.2 (x64) Build ID: 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8 CPU threads: 4; OS: Windows 10.0 Build 19613; UI render: GL; VCL: win; Locale: es-ES (es_ES); UI-Language: en-US Calc: CL -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132332] Numerical cells with hyperlinks are sorted non-numerically
https://bugs.documentfoundation.org/show_bug.cgi?id=132332 QA Administrators changed: What|Removed |Added Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132332] Numerical cells with hyperlinks are sorted non-numerically
https://bugs.documentfoundation.org/show_bug.cgi?id=132332 --- Comment #4 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132332] Numerical cells with hyperlinks are sorted non-numerically
https://bugs.documentfoundation.org/show_bug.cgi?id=132332 --- Comment #3 from Nadie Nada Nunca --- Created attachment 159830 --> https://bugs.documentfoundation.org/attachment.cgi?id=159830=edit Sample file Sort by "Año" (year), or by any other column and then "Año". -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132332] Numerical cells with hyperlinks are sorted non-numerically
https://bugs.documentfoundation.org/show_bug.cgi?id=132332 m.a.riosv changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO CC||miguelangelrv@libreoffice.o ||rg --- Comment #2 from m.a.riosv --- Please attach a sample file. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132332] Numerical cells with hyperlinks are sorted non-numerically
https://bugs.documentfoundation.org/show_bug.cgi?id=132332 --- Comment #1 from Nadie Nada Nunca --- Created attachment 159824 --> https://bugs.documentfoundation.org/attachment.cgi?id=159824=edit Screenshot showing the bug -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
