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
Please can you attach a sample file to test.
Created attachment 178359 [details] Demo File requested by LibreOffice DEMO file attached to help rerpoduce the unexpected behavior. SORT is not saved after File Save & Close : Data > Validity > Sort by Ascending Order. Resets every single time. Need to enable Sort again under Data > Validity. State of Sorting must be Saved in document, if enabled.
It is excel file format, I can't see with excel in Data Validation an option for that. Looks like if that option doesn't exist in excel. https://www.excelcampus.com/tips/sort-drop-down-lists-automatically/ Works find ODF file format.