How do you align numbers within a column in UItable?

29 次查看(过去 30 天)
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!!!

采纳的回答

Walter Roberson
Walter Roberson 2011-3-10
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 个评论
Walter Roberson
Walter Roberson 2011-3-10
Ah yes, you are right, the outer cellfun should have 'un',0

请先登录,再进行评论。

更多回答(2 个)

Oleg Komarov
Oleg Komarov 2011-3-10
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 个评论
Peter
Peter 2011-3-10
Unfortunately because it's not a fixed width font the blank padding still doesn't get you to right alignment. Each number takes up a different amount of space - unless I'm missing something.

请先登录,再进行评论。


Walter Roberson
Walter Roberson 2011-3-10
Does setting the ColumnFormat to 'bank' work ?
  2 个评论
Oleg Komarov
Oleg Komarov 2011-3-10
It will work with numeric datatypes...not with strings.
Peter
Peter 2011-3-10
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

请先登录,再进行评论。

Community Treasure Hunt

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

Start Hunting!

Translated by