topic Issue in Export to excel - Truncating Zeros in QlikView https://community.qlik.com/t5/QlikView/Issue-in-Export-to-excel-Truncating-Zeros/m-p/353391#M131108 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I am using a macro to send the values in chart to excel. Reason is using the same macro we have added headers and filters.</P><P></P><P>While doing that leading zeros are getting truncated while sending the data to excel.</P><P></P><P>I have used text function in the script. In qv values are correct. But in macro, copy to clipboard unformats the data.</P><P></P><P>I have attached qvw and source file</P><P></P><P>Pls post your valuable comments.</P></BODY></HTML> Tue, 17 Jul 2012 04:58:36 GMT 2012-07-17T04:58:36Z Issue in Export to excel - Truncating Zeros https://community.qlik.com/t5/QlikView/Issue-in-Export-to-excel-Truncating-Zeros/m-p/353391#M131108 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I am using a macro to send the values in chart to excel. Reason is using the same macro we have added headers and filters.</P><P></P><P>While doing that leading zeros are getting truncated while sending the data to excel.</P><P></P><P>I have used text function in the script. In qv values are correct. But in macro, copy to clipboard unformats the data.</P><P></P><P>I have attached qvw and source file</P><P></P><P>Pls post your valuable comments.</P></BODY></HTML> Tue, 17 Jul 2012 04:58:36 GMT https://community.qlik.com/t5/QlikView/Issue-in-Export-to-excel-Truncating-Zeros/m-p/353391#M131108 2012-07-17T04:58:36Z Re: Issue in Export to excel - Truncating Zeros https://community.qlik.com/t5/QlikView/Issue-in-Export-to-excel-Truncating-Zeros/m-p/353392#M131109 <HTML><HEAD></HEAD><BODY><P> Found a way!!! Instead of using copytabletoclipboard.. Use copytext to clipboard.</P><P></P><P>Copytable to clipboard removes all the formatting applied to the columns.</P><P></P><P>Copy text to clipboard retains the formatting but the column names will be missed. But you can hardcode the column names and push the data to next row.</P></BODY></HTML> Tue, 17 Jul 2012 09:06:57 GMT https://community.qlik.com/t5/QlikView/Issue-in-Export-to-excel-Truncating-Zeros/m-p/353392#M131109 2012-07-17T09:06:57Z