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


  • 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. 






    Friday, April 11, 2008 4:56 PM