locked
Problem of Format for export to Excel RRS feed

  • Question

  •  

    Proclarity Desktop Professional 6.3.2214.168

     

    After Export of Grid to Excel the format is disabled  :

    1. Symbol percentage is removed  35,31 %  (Procla) ->  0,3531 (Excel) ?

    2. Number of decimals has changed  : 1400,49 (Procla) -> 1400,4955576 (Excel) ?

    3. Color format is removed

     

    Any solutions about theses ?

    Thank You in Advance,

    Friday, April 11, 2008 1:21 PM

Answers

  • Hello Jean Pierre,

     

    From ProClarity's Help files:

     

    The values are exported in decimal precision format with the necessary number of digits after the decimal point to correctly display the full value. In Excel, you can apply decimal formatting to decrease the number of digits after the decimal point, or you can change the number formatting to a percentage, currency, accounting, or scientific.

     

    You can try exporting the values from Web Standard, that process should allow the percentages to persist, as it is merely snapshotting the view from IE. 

     

    HTH!

     

    Regards,

    Amanda

    Friday, April 11, 2008 4:56 PM