MATLAB: Background of editable cells UITABLE

backgroundMATLABuitable

Hi !

I created an uitable with guide and I would like to change the background of editable cells.

I tried to use the HTML code with the method https://www.mathworks.com/matlabcentral/answers/25038-how-to-change-each-cell-color-in-a-uitable , it works for the background, but I can't change the value of my cell anymore.

Any ideas ?

Best Answer

[Continued from comments section under the question]

Summary of the problem

"when the [callback function] is over, the first line is executes once again. I don't understand why."

This is an unfortunate, known problem in GUIDE GUIs. The 2nd invocation of the callback function is the result of changing the object focus which is inevitable.

Solution

To get around this, at the top of your callback function write a conditional that escapes the callback function if the indices are empty.

if isempty(eventdata.Indices)
    return
end

Related Solutions

MATLAB: Error set data of table by using eventdata.Indices inside CellSelectionCallback

hi everyone,

i solved that Problem and here is how i did that.

if someone wants to click on any casket of the table and get its indices and make a changes(somewhere with a Funktion on the the same table) and set that table, he should use CellEditCallBack instead of CellSelectionCallback to avoid that Problem which is:

Index exceeds matrix dimensions.
Error in GUI1>table_CellSelectionCallback (line 3197)
row_s = eventdata.Indices(1,1);

Note: the column, which you wanna click on, should be Editable.

so you should first set the column. set(handles.table.'ColumnEditable', 'On')

MATLAB: How to define each case of the choice list in a uitable (GUI) and put IF function for each one

Hi Omid,

You can try below this code I have written some commands on it.

    classdef myuitable  < handle
          properties
              guiHandles
              table1_data
              table2_data
              selectedRows
              selectedColumns
          end
          methods
              function obj = myuitable
                  colNames   = {'Load1','Load2','Load3'};
                  rowNames   = {'XLC01','XLC02','XLC03','XLC04','XLC05'};
                  colFormat1 = {'Selection1','Selection2','Selection3','Selection4'};
                  colFormat2 = {'1','2','3'};
                  C    = cell(5,1);
                  C(:) = {'NaN'};
                  table1Data = [C,num2cell(nan(5,2))];
                  table2Data = num2cell(zeros(5,3));
                  obj.guiHandles.mainGUI = figure(...
                      'units'      , 'normalized',...
                      'Position'   , [0.2 0.2 0.65 0.5],...
                      'NumberTitle', 'off',...
                      'Name'       , 'My uitable App',...
                      'Toolbar'    , 'none',...
                      'MenuBar'    , 'none' ...
                      );
                  obj.guiHandles.table1 = uitable(...
                      'Parent'                , obj.guiHandles.mainGUI,...
                      'units'                 ,'normalized',...
                      'Position'              , [0,0.7,0.3,0.3],...
                      'ColumnName'            , colNames,...
                      'RowName'               , rowNames,...
                      'Data'                  , table1Data,...
                      'ColumnEditable'        ,[true,true,false],...
                      'ColumnFormat'          ,{colFormat1,colFormat2},...
                      'CellEditCallback'      , @obj.table1CellEdited,...
                      'CellSelectionCallback' , @obj.table1CellSelected...
                      );
                  obj.guiHandles.table2 = uitable(...
                      'Parent'    , obj.guiHandles.mainGUI,...
                      'units'     ,'normalized',...
                      'Position'  , [0.5,0.7,0.3,0.3],...
                      'ColumnName', colNames,...
                      'RowName'   , rowNames,...
                      'Data'      , table2Data...
                      );
                  obj.table1_data = table1Data;
                  obj.table2_data = table2Data;
              end
              function table1CellEdited(handleObj,source,eventdata)  % First three input explained in cell selected callback
                  % you can either use varargin, or three different inputs like
                  % above.
                  %%small check for cell selection works correctly
                  selectedIndicesSavedInObjectProperty = [handleObj.selectedRows, handleObj.selectedColumns];
                  selectedIndicesInEventData = eventdata.Indices;
                  if isequal(selectedIndicesSavedInObjectProperty,selectedIndicesInEventData)
                      disp('Indices are the same');
                  else
                      disp('Indices are not the same');
                  end
                  %%Now we can create some cases for selections
                  if handleObj.selectedColumns == 1 % if your selected column is first column and any data changed here
                      userSelection = eventdata.EditData;
                      currentTable2Data = handleObj.guiHandles.table2.Data;
                      switch userSelection
                          case 'Selection1'
                              currentTable2Data(handleObj.selectedRows,handleObj.selectedColumns) = cellstr(eventdata.NewData);
                          case 'Selection2'
                              currentTable2Data(handleObj.selectedRows,handleObj.selectedColumns) = cellstr(eventdata.NewData);
                          case 'Selection3'
                              currentTable2Data(handleObj.selectedRows,handleObj.selectedColumns) = cellstr(eventdata.NewData);
                          case 'Selection4'
                              currentTable2Data(handleObj.selectedRows,handleObj.selectedColumns) = cellstr(eventdata.NewData);                    
                      end
                      newTable2Data = currentTable2Data;
                      handleObj.guiHandles.table2.Data = newTable2Data;
                  elseif handleObj.selectedColumns == 2 % if your selected column is second column and any data changed here
                      userSelection = eventdata.EditData;
                      currentTable2Data = handleObj.guiHandles.table2.Data;
                      switch userSelection
                          case '1'
                              currentTable2Data(handleObj.selectedRows,3) = cellstr(eventdata.EditData); % You can define any value to any cell here. I have chosen to change 3rd column of second table
                          case '2'
                              currentTable2Data(handleObj.selectedRows,3) = cellstr(eventdata.EditData);
                          case '3'
                              currentTable2Data(handleObj.selectedRows,3) = cellstr(eventdata.EditData);
                      end
                      newTable2Data = currentTable2Data;
                      handleObj.guiHandles.table2.Data = newTable2Data;
                  else
                      % Do nothing
                  end
              end
              function table1CellSelected(varargin)  % you will always get 3 inputs for the callback functions automatically
                  % when mouse clicked to any cell on your uitable this function
                  % automatically called by your main class.
                  handleObj = varargin{1};  % first  input is always an instance of your class object (myuitable)
                  source    = varargin{2};  % second input is always an instance of the GUI item(uicontrol,uiable) object (eg. a table, a button, etc...)
                  eventdata = varargin{3};  % third  input is wlways eventdata object whic represents what happened to which source
                  % eventdata gives you the details about click event(eg.Indices)
                  handleObj.selectedRows    = eventdata.Indices(1); % eventdata.Indices gives you a [x y], first value row number, second is column number.
                  handleObj.selectedColumns = eventdata.Indices(2);
                  % now you saved the selected information in your object
                  % property. We will use this when data changed in your table.
              end       
          end
      end

Best Answer

Related Solutions

MATLAB: Error set data of table by using eventdata.Indices inside CellSelectionCallback

MATLAB: How to define each case of the choice list in a uitable (GUI) and put IF function for each one

Related Question