Modifying uitable using GUIDE

I would like to create a Table with default only 1 row and the user can add or delete a row using push buttons. The add and delete part is ok but the table created always stuck at 4 rows. No matter how I change the settings in the Inspector. Besides that I would also do some calculations in the last column cells. How can I customize that?

Answer 1

[Geoff Hayes]

In the OpeningFcn of your GUI, just set the Data property of the uitable to be a 1x2 (or whatever number of columns) cell array. Something like the following should work

 % --- Executes just before untitled is made visible.

function myGUI_OpeningFcn(hObject, eventdata, handles, varargin)

% Choose default command line output for untitled
handles.output = hObject;

% Update handles structure
guidata(hObject, handles);

% set the table size to be 1x2
set(handles.uitable1,'Data',cell(1,2));

The above was tested with R2014a.

As for customization for calculations in the last column, please be more specific.

[Kah Joon Yong]

Oh thx mate! That's really what I asked for. The calculation should be the multiplication of the previous 2 columns and then the last row I would like them to sum up. Something like a receipt that you get from the supermarket. Amount is 2 Unit price is 2$ then Subtotal is 4$.

[Image Analyst]

You have to get the data

yourData = get(handles.uitable1,'Data');

Then sum up the first few columns and put them in the last column

theSums = sum(yourData(:, end-1), 2);
yourData(:,end) = theSums;
% Send the new data back into the uitable.
set(handles.uitable1,'Data', yourData);

[Kah Joon Yong]

Thank you Image Analyst. I will try it out. It seems like easy enough. Though I have tried this out and it works.

data = get(handles.Items_Detail, 'data');
sub = cell2mat(data(:,2))*cell2mat(data(:,3));
[row,~]=size(sub);
data(:,4)=mat2cell(sub,row);
set(handles.Items_Detail,'data',data);

It seems like the data in my table is in 'cell array' format and I could not add those values together using the normal 'plus' sign.