Perspective Table default number format

Hi all,
I use a Perspective table to show the result of a dynamic query. That resultset may have different data types at the same column index, depending on which query options the user enables - e.g. column X could be a product name as well as a decimal number representing a quantity. My quantities are as small as 0.xxxE-7, but I cannot use the columns prop to format those numbers, because the query is dynamically built. Is there any default number format I can set anywhere in the table props, which is then used for any number, wherever it might show up?

Thanks in advance, regards

Use an expression structure to generate both data and columns props dynamically.

Thanks pturmel, I was thinking to go that way, but I thought it to be too complicated for my use case.