When I use datalink, it will not overwrite my cell formatting like background color. When I use PI Builder to retrieve data, it overwrites all cell formatting. Can you please edit your PI Builder code to behave more like Datalink in regard to preserving cell formatting?
Commenting again that this bug makes PI Builder nearly unusable for our organization and puts our data integrity at high risk of corruption. This should be a higher priority to address.
From one of our Customers at WAPA - Some of our PI Tag Names have a leading zero "01234567". When this key is entered into Excel, you have to set the number format to 'Text' so that Excel does not automatically remove the leading zero. When you use the "Retrieve" option in PI Builder, the add-in resets the column type to 'General' and the leading zero is removed, making the key invalid "1234567".
This would be helpful.