Description: in a range of rows & columns, and sorting by a column, only the cells containing constants are sorted. Steps to Reproduce: 1.table A contains data 2.lower down, reference the cells into a new table B 3.select table B 4.sort according to any column 5.add a column that has constants 6.sort again 7.change some cells in column to constants 8.sort Actual Results: only the cells containing constants are sorted Expected Results: all cells in a row should be sorted maintain the integrity of the row Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Linux (All) OS is 64bit: yes Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 6a54d08e6e52623f9769d17d7ea7390052cb275b CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-US Calc: threaded same behaviour observed in v6.4.7.2 v7.3.7.2
Created attachment 195207 [details] sorting when one tries to do something which is not possible, there should be a warning
What happens with your procedure if you first change the following setting? * Calc menu Tools > Options > Calc > General > (Input Settings) "Update references when sorting range of cells" Then try the procedure from start.