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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
