How do you align numbers within a column in UItable?

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!!!

Answer 1

[Walter Roberson]

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".

[Oleg Komarov]

The second I submitted the version with the strcat I thought sprintf would be more suited in this case...doh.

BTW, you're missing a 'un',0 in the last cellfun.

[Walter Roberson]

Ah yes, you are right, the outer cellfun should have 'un',0

[Zoe Zhang]

so smart!

Answer 2

[Oleg Komarov]

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

[Peter]

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.

[Oleg Komarov]

You had to change fontname to a monospaced set

Answer 3

[Walter Roberson]

Does setting the ColumnFormat to 'bank' work ?

[Oleg Komarov]

It will work with numeric datatypes...not with strings.

[Peter]

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