Set decimal place for uitable

Hello there,

I have a mat table and I want to present one of the column of such table (the data column) in one decimal place of scientific format in UIFIGURE table (example: 0.00001 should be 1.0e-5). But, my code so far present it as 0.0000. Please find attached the data.

load('data_decimal.mat');
uitable(uifigure,'Data',results{:,:},'ColumnName',results.Properties.VariableNames); % this line gives 0.0000

Thanks!

Answer 1

[Star Strider]

It may be necessary to create a string variablee or character array to get what you want, because MATLAB will use full precision if it has all the numbers available to it.

LD = load('data_decimal.mat');
results = LD.results

results = 6x2 table
      x          data   
    ______    __________

    123.94    3.8848e-09
    123.87    4.8751e-09
    123.79    4.7731e-07
     123.8    8.6742e-09
    123.79    1.6945e-08
    123.79    1.9707e-07

expstr = @(x) [x(:).*10.^ceil(-log10(abs(x(:))))  floor(log10(abs(x(:))))];
results.data1 = compose('%.1fe%d', expstr(results.data))

results = 6x3 table
      x          data         data1   
    ______    __________    __________

    123.94    3.8848e-09    {'3.9e-9'}
    123.87    4.8751e-09    {'4.9e-9'}
    123.79    4.7731e-07    {'4.8e-7'}
     123.8    8.6742e-09    {'8.7e-9'}
    123.79    1.6945e-08    {'1.7e-8'}
    123.79    1.9707e-07    {'2.0e-7'}

datamtx = expstr(results.data);
format shortG                                                       % <— This Is Probably Necessary
results.data2 = round(datamtx(:,1),1) .* 10.^datamtx(:,2)

results = 6x4 table
      x          data         data1        data2 
    ______    __________    __________    _______

    123.94    3.8848e-09    {'3.9e-9'}    3.9e-09
    123.87    4.8751e-09    {'4.9e-9'}    4.9e-09
    123.79    4.7731e-07    {'4.8e-7'}    4.8e-07
     123.8    8.6742e-09    {'8.7e-9'}    8.7e-09
    123.79    1.6945e-08    {'1.7e-8'}    1.7e-08
    123.79    1.9707e-07    {'2.0e-7'}      2e-07

This is the best I can do with your data.

.

[Adi Purwandana]

Aha! Great, thank you @Star Strider!

[Star Strider]

As always, my pleasure!

Answer 2

[Cris LaPierre]

Set the column display format to 'shortE' (you can see other options here)

fig = uifigure;
uit = uitable(fig,"Data",randi(100,10,3));
uit.Data(1,1) = 0.00001
uit.ColumnFormat = {'shortE'}

[Adi Purwandana]

Thank you @Cris LaPierre. Adopting your suggestion gives me the first column of my data is transformed also in scientific way. Any further suggestion if I want to convert the second column only into scientific format and keep the first column in numeric standard format?

load('data_decimal.mat');
uit=uitable(uifigure,'Data',results{:,:},'ColumnName',results.Properties.VariableNames);
uit.ColumnFormat = {'shortE'};

[Cris LaPierre]

Specify a format for each column

uit.ColumnFormat = {[],'shortE'}

[Adi Purwandana]

Merci @Cris LaPierre!

Answer 3

[Mr. Pavl M.]

Select any format your wish:

https://fr.mathworks.com/help/matlab/ref/format.html

%in older Matlab versions format('shortE')
load( 'data_decimal.mat' );
uitable(uifigure, 'Data' ,round(results{:,:},1), 'ColumnName' ,results.Properties.VariableNames); % 

%or
format('shortE')
load( 'data_decimal.mat' );
uitable(uifigure, 'Data' ,fix(results{:,:}*10)/10, 'ColumnName' ,results.Properties.VariableNames); % 

[Adi Purwandana]

This codes round everything. That's not what I want. I need to keep the first column as it is and change the second column in scientific format.

[Mr. Pavl M.]

Right, you are as usual of course right Adi.

1. Have you found how to re-format per column (each column in different format, for example x column in standard numeric, and data column in short scientific?

Because so far they proposed format for whole table, right?:

uit=uitable(uifigure, 'Data' ,results{:,:}, 'ColumnName' ,results.Properties.VariableNames);

uit.ColumnFormat = { 'shortE' };

Whether compose and string pre-printing with C style formating, like '%.1fe%d' and than putting formatted strings to the ui table works better in your specific case than formatting each column by specifiying as per 'shortE'?

Of course in real world and in real time all comes not ideal, while optimality can be achieved with patience and hard work.

Analysis:

How can we add more value to your project and posts, can we make it for CNC, 3D printer machines (also to combine with your previous question on specific distances between 2 tables, like distance for CNC Hybdrid manufacturing, Swiss-type Lathe machining and another distance metric for logistics industries)? For example to find some more simple machining by specially preprocessed tables run instead of complex code?