Description: I have a spreadsheet with a column with numerical data (years). Some of the cells have the number hyperlinked to a webpage. When I sort by that column, hyperlinked years are sorted below all non-hyperlinked years. The natural thing to do would be to ignore the fact that there's a hyperlink there and sort the cell by its visible contents (the number). Steps to Reproduce: 1. Create a cell with a "years" column and fill it with years. 2. Select some of the years and insert hyperlinks to various webpages. 3. Sort the spreadsheet by the "years" column. Actual Results: Rows with hyperlinks are put below the rows without hyperlinks. Expected Results: The column should be sorted by year. Reproducible: Always User Profile Reset: No Additional Info: Screenshot attached.
Created attachment 159824 [details] Screenshot showing the bug
Please attach a sample file.
Created attachment 159830 [details] Sample file Sort by "Año" (year), or by any other column and then "Año".
[Automated Action] NeedInfo-To-Unconfirmed
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
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.
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.
Created attachment 159881 [details] 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.
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
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?
... well, it's been a year, and the bug persists in LO 7.2. Is there any hope for this to be fixed?
Dear Nadie Nada Nunca, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Still present. Version: 24.2.1.2 (X86_64) / LibreOffice Community Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: es-AR (es_AR); UI: en-US Calc: CL threaded