Created attachment 120330 [details] example spreadsheet with a custom list We currently support Custom lists(Tools->Options->Calc->Sort List), but we don't import them from MSO docs. Steps to reproduce: 1. Open the attached file in Calc 2. Open the attached file in Excel Note in Excel, you have the option to Sort by "Low, Medium, High"
If this feature was implemented, when you go to Data->Sort->Options->Custom Sort Order You'd find: "Low, Medium, High" as an option
Hi @Luke, thanks for reporting. They are not saved neither in odf format, I don't find it in odf specification, maybe would be better change to request for enhancement.
Let's try enhancement to get this off unconfirmed status.
Data->Sort->Options->Custom Sort Order You still do not have: "Low, Medium, High" as an option in Version: 6.1.0.0.alpha1+ (x64) Build ID: a3783c0af4bd21eb9c001aadc60c660c06a47779
Serge Krot committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/a9f8f0a484965338221cad4f97d98f418b5ccff1 tdf#95640 XLSX: import/export of custom sort lists It will be available in 7.1.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Serge Krot committed a patch related to this issue. It has been pushed to "libreoffice-7-0": https://git.libreoffice.org/core/commit/e6bdfaaf572b592f7e8b510cb38f82a4aca41593 tdf#95640 XLSX: import/export of custom sort lists It will be available in 7.0.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Serge Krot committed a patch related to this issue. It has been pushed to "libreoffice-6-4": https://git.libreoffice.org/core/commit/a86ddd7fc0413f65ee7851eb09b15a24e5d457ba tdf#95640 XLSX: import/export of custom sort lists It will be available in 6.4.7. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.