https://bugs.documentfoundation.org/show_bug.cgi?id=147477
Bug ID: 147477 Summary: CALC unable to retain Sort under Data > Validity after save, close, and reopening document Product: LibreOffice Version: 7.2.5.2 release Hardware: x86-64 (AMD64) OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: digitalab...@gmail.com Description: See Steps to Reproduce the bug. CALC unable to retain Sort under Data > Validity after save, close, and reopening document. Steps to Reproduce: 1. New Document > enter data in few rows in one column. 2. Select Column > menu Insert > Define Name > this becomes list of values. 3. Another column > menu Data > Validity > Cell Range > List Name (defined earlier). 4. Enable Sort checkbox option for List to appear in Ascending order. 5. Check and verify data (values from List) is appearing in Asc. Sort order. 6. Save and Close Document. 7. Reopen Document. 8. Check and verify data (values from List) - once again. 9. --- BUG --- Data Validity Sort Order is LOST. (Need to enable again) Actual Results: Calc application RESETS Sorting after reopening. Every time I have to Redo the Steps getting Validation Data in needed order. Expected Results: One Sorting is enabled on Data > Validity, the application must be able to retain STATE (enabled / disabled) of Sort this after close and reopen of document. Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no >>>> info from Help > Version: Version: 7.2.5.2 (x64) / LibreOffice Community Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5 CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL -- You are receiving this mail because: You are the assignee for the bug.