How do you align numbers within a column in UItable?

40 次查看（过去 30 天）
Peter
Peter 2011-3-10
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 个评论
显示 1更早的评论
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

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Common Operations 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by