Issue in Export to excel - Truncating Zeros

[#1]

Hi All

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.

While doing that leading zeros are getting truncated while sending the data to excel.

I have used text function in the script. In qv values are correct. But in macro, copy to clipboard unformats the data.

I have attached qvw and source file

Pls post your valuable comments.

[#2 · Accepted solution]

Found a way!!! Instead of using copytabletoclipboard.. Use copytext to clipboard.

Copytable to clipboard removes all the formatting applied to the columns.

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.