Spire.DataExport for .NET is a 100% pure data .NET library suit for exporting data into MS Word, Excel, RTF, Access, PDF, XPS, HTML, XML, Text, CSV, DBF, SYLK, SQL Script, DIF, Clipboard, etc.

Fri Jun 08, 2012 9:20 pm

I have successfully formatted my Excel columns as dates or currency using the GetDataParams event, but I can't figure out how to format a column as a percent (i.e., multiply by 100 and add % symbol). I don't want to format the column as text since I want to retain the underlying number for calculations.

Is there any FormatText string I can use to achieve this?

rdevivo
 
Posts: 1
Joined: Tue Feb 21, 2012 6:48 pm

Mon Jul 02, 2012 9:00 am

Hi rdevivo,

About your problem, I have writed a demo in the attachment. You can refer to it. Thank you for your cooperation and understanding.
Attachments
SALESSUPPORT-559.7z
demo
(44.14 KiB) Downloaded 768 times
Nancy
e-iceblue support team
contact: nancy.wang@e-iceblue.com
User avatar

nancy
 
Posts: 51
Joined: Wed May 30, 2012 2:02 am

Return to Spire.DataExport