11 Replies Latest reply: Jan 6, 2012 12:24 PM by tylerwaterfall RSS

Number format setting 'Expression Default' and Excel export

Sander Goudsblom

Hello all, in a function in a QV application is use the number format 'expression default' in the expression is set the different formats on base of the dimension elements and the num function. This looks like this.

 

 

If          ( DimX='1',
          Num(
          $(vFunc1),
          '#.##0,0%')
          ,
If          ( DimX='2',
          Num(
          $(vFunc2)
          ,
          '#.##0,0%')
          ,
If      (DimX='3',
          Num(
          $(vFunc3)
          )
          , 
          '#.##0')
)))

When I use the excel export, it gives the figures as a text field and it rounds the figures. When u use the other formats, other than 'expression default' it exports good. It is also going wrong when exporting from the web front-end (IE-Plugin, ajax not tested), then it's exporting the figure without any format

 

Excel export from desktop application:

2011-06-28 16.2401.gif

the first two as text and the last one is good

 

Excel export from web front-end:

2011-06-28 16.2802.gif

the first two without any format and the last one good.

 

Has anyone seen and solved this before? Can you help me please, thanx in advance!