Skip to Main Content
AVEVA Product Feedback


Status No status
Categories PI Builder
Created by Guest
Created on Aug 20, 2022

Retain cell formatting after PI Builder "Retrieve" actions

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?
  • Attach files
  • Guest
    May 14, 2025
    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".
  • Guest
    May 14, 2025

    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".

  • Elijah Thomas
    May 14, 2025

    This would be helpful.

  • Guest
    Aug 20, 2022
    This would really be helpful. I can't stand reformatting my sheets after using PI Builder.