NumberFormat on specific/few columns - Report Generator

6 visualizaciones (últimos 30 días)
Ali razi
Ali razi el 26 de En. de 2022
Comentada: Rahul Singhal el 27 de En. de 2022
I am formating a table using this line:
tableData = FormalTable(tableData);
tableData.Border = 'Solid';
tableData.RowSep = 'Solid';
tableData.ColSep = 'Solid';
tableData.Style = [tableData.Style {NumberFormat("%.4f")}];
Is it possible to run the NumberFormat on specific/few columns and not on all the table?

Respuestas (1)

Rahul Singhal
Rahul Singhal el 26 de En. de 2022
Hi Ali,
You can apply NumberFormat to any specific entry, row, or column in a table. Below are some examples:
%% Apply NumberFormat to a specific entry in the table
entry22 = tableData.entry(2,2);
entry22.Style = [entry22.Style {NumberFormat("%.4f")}];
%% Apply NumberFormat to specific row in the table
row3 = tableData.row(3);
row3.Style = [row3.Style {NumberFormat("%.4f")}];
%% Apply NumberFormat to specific column in the table
colNumber = 1;
for iRow = 1:tableData.NRows
tableEntry = tableData.entry(iRow,colNumber);
tableEntry.Style = [tableEntry.Style {NumberFormat("%.4f")}];
  4 comentarios
Ali razi
Ali razi el 27 de En. de 2022
Editada: Ali razi el 27 de En. de 2022
Thanks a lot it worked.
I also tried to convert the numbers to decimal by replacing to this line:
tableEntry.Style = [tableEntry.Style {NumberFormat("%d")}];
But I go this error:
Error using mlreportgen.dom.NumberFormat
Invalid sprintf value for NumberFormat: %d.

Iniciar sesión para comentar.




Community Treasure Hunt

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

Start Hunting!

Translated by