| Summary: | FILEOPEN: Custom lists not imported from MSO XLSX files | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Luke <lukebenes> |
| Component: | Calc | Assignee: | Serge Krot (CIB) <serge.krot> |
| Status: | VERIFIED FIXED | ||
| Severity: | enhancement | CC: | ilmari.lauhakangas, miguelangelrv, thb |
| Priority: | medium | Keywords: | filter:xlsx |
| Version: | Inherited From OOo | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | target:7.1.0 target:7.0.2 target:6.4.7 | ||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 108897 | ||
| Attachments: | example spreadsheet with a custom list | ||
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. |
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"