How do you align numbers within a column in UItable?

124 views (last 30 days)
Peter
Peter on 10 Mar 2011
We're using GUIDE to build financial applications for investment bankers. They expect to see a column of dollar figures right aligned but there seems to be no obvious way to right align characters in a column in UItable. Any help would be GREATLY appreciated!!!

Accepted Answer

Walter Roberson
Walter Roberson on 10 Mar 2011
Golf'ing Oleg's solution:
dat = {'23234.43 $'; '234.43 $'; '0.23 $'};
dat = cellfun(@(s) sprintf('%*s',max(cellfun(@length,dat)),s),dat);
and then pick up at "Create table".
  3 Comments

Sign in to comment.

More Answers (2)

Oleg Komarov
Oleg Komarov on 10 Mar 2011
I came up with this solution:
dat = {'23234.43 $'; '234.43 $'; '0.23 $'};
Pad string amounts with blanks
l = cellfun(@length,dat);
dat = num2cell([arrayfun(@blanks,max(l)-l,'un',0) dat],1);
dat = strcat(dat{:});
Create table with courier font
f = figure('Position',[200 200 400 150]);
cnames = 'Amounts';
rnames = {'First','Second','Third'};
t = uitable('Parent',f,'Data',dat,'ColumnName',cnames,...
'RowName',rnames,'Position',[20 20 360 100],...
'fontname','courier');
Oleg
  2 Comments
Oleg Komarov
Oleg Komarov on 10 Mar 2011
You had to change fontname to a monospaced set

Sign in to comment.


Walter Roberson
Walter Roberson on 10 Mar 2011
Does setting the ColumnFormat to 'bank' work ?
  2 Comments
Peter
Peter on 10 Mar 2011
We'd like to have commas and no 0s (dealing with large numbers in the hundreds of millions). 'Bank' format goes out to the penny and has no commas

Sign in to comment.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!