To ensure that the selections made using the CellSelectionCallback are based on the sorted data in the table, you can modify your code as follows:
- Store the original row indices of the selected cells before sorting the table.
- Apply the same sorting operation to the row indices.
- Use the sorted row indices to retrieve the selected cells from the sorted table.
Here's an updated version of your code:
% --- Executes when selected cell(s) is changed in file_table.
function file_table_CellSelectionCallback(hObject, eventdata, handles)
% hObject handle to file_table (see GCBO)
% eventdata structure with the following fields (see MATLAB.UI.CONTROL.TABLE)
% Indices: row and column indices of the cell(s) currently selected
% handles structure with handles and user data (see GUIDATA)
indices = eventdata.Indices;
r = unique(indices(:,1),'rows');
% Check if the table is sorted
if handles.table_sorted
% Get the sorted row indices
sorted_indices = handles.sorted_indices(r);
selections = sorted_indices;
else
selections = r;
end
handles.selections = selections;
guidata(hObject,handles);
end
% --- Executes on button press in sort_events_button.
function sort_events_button_Callback(hObject, ~, handles)
% hObject handle to sort_events_button (see GCBO)
% eventdata reserved - to be defined in a future version of MATLAB
% handles structure with handles and user data (see GUIDATA)
table_data = handles.table_data;
prompt = {'Primary Sort (- = Down)','Secondary Sort','Tertiary Sort'};
dlgtitle = 'Column ("-" = Descend)';
dims = [1,60];
definput = {'0','0','0'};
sorter = inputdlg(prompt,dlgtitle,dims,definput);
for n = 1:3
sorter{n} = str2double(sorter{n});
end
sorter = nonzeros((cell2mat(sorter))');
% Sort the table data
table_data_sorted = sortrows(table_data,sorter);
% Get the sorted row indices
[~, sorted_indices] = ismember(table_data_sorted, table_data, 'rows');
set(handles.file_table,'Data',table_data_sorted);
handles.table_data = table_data_sorted;
handles.table_sorted = true;
handles.sorted_indices = sorted_indices;
guidata(hObject,handles);
end
In the file_table_CellSelectionCallback function, the modified code checks if the table is sorted (handles.table_sorted). If it is, it uses the sorted_indices to retrieve the selected cells from the sorted table. Otherwise, it uses the original row indices (r) as before.
By storing and using the sorted row indices, the selections will be consistent with the sorted data in the table.
