[Libreoffice-bugs] [Bug 132332] New: Numerical cells with hyperlinks are sorted non-numerically

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=132332

            Bug ID: 132332
           Summary: Numerical cells with hyperlinks are sorted
                    non-numerically
           Product: LibreOffice
           Version: 6.4.2.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: nadie.nada.nunca at mail.com

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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200422/dd0a0f20/attachment.htm>