Export report to excel

[chan]

Hi
   I get a problem when i export report to excel. I have some records whose format is {0:p1},and them display correctly in report,but when i export it to excel, it displays in a wrong format. For example,in the report it shows as following:
    name        percentage
     lily              15%

But when i export to excel,it shows
    name        percentage
     lily              0.15

  How can i resolve this problem,thanks.
 

[Steve]

Hello chan,

As explained in the Design Considerations for Excel Rendering, only a subset of the .NET string formats is supported by the rendering extension. Those include the Standard Numeric Format Strings:

• • C or c (Currency)
  • N or n (Number)
  • G or g (General)

and currently percentage is not supported. However per your inquiry, we would research what needs to be done to have this functionality available.

Sorry for the temporary inconvenience. Your Telerik points have been updated for bringing this to our attention.

Best wishes,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Shaiful Islam]

Hi Steve
Can you tell me percentage is supported  now or not?

Thanks
Shaiful

[Steve]

Hello Shaiful Islam,

Yes, if you open the link from my previous reply, you would notice that percentages are now supported.

Greetings,
Steve
the Telerik team