How can I prevent cells becoming NAN cells after an event?

I am trying to work a simple arithmetic problem inside a cell array. I want to add all the rows from one column with all the rows from other column. I am doing this task with a push button with this code under it`s callback function:

function addCol_Callback(hObject, eventdata, handles)

data = str2double(get(handles.uitable1,'data'));
data(:,5) = data(:,3) + data(:,4);
set(handles.uitable1,'data',data);

I am able to get the arithmethic, but all the cells show the NaN message, even those where I had previously entered a number, or chosen a value from a choice list. Is there a way to get rid of the effects that the NaN cause in all the cells?

Here I present an Image before pressing the event button and an image after the button pressed.

%

[Alfonso Rodriguez]

The mess is like this after pressing the button.

I just don´t want the NaN to show and mess my cells. I really just need to get the sum from the two columns and that`s it. I also need the choice list to stay the same as before the button was pressed. And also any other column to not be affected by the NaN.

Answer 1

[Walter Roberson]

Why are you using

data = str2double(get(handles.uitable1,'data'));

The 'data' property should be a cell array, not all of which will be strings.

The choice arrays will be numeric indices into the cell array of strings entry in ColumnFormat entry for the column.

The entries for which the ColumnFormat is one of the numeric formats will be returned as numeric.

It is only the entries which are 'char' in ColumnFormat for which the column would be returned as string that need converting by str2double()

[Alfonso Rodriguez]

Hi! I use str2double, because arithmethic can´t be done on cells. Then by converting them to doubles I can do a substraction between two cells and show the result on other cell. This works but, fills other cells with NaN messages.

[Walter Roberson]

cell2mat() the columns that you need, and num2cell the result and write it into the data cell array.

[Alfonso Rodriguez]

Thanks Walter, This gives me a new insight.