Skip to Main Content
AVEVA™ PI System™ Feedback Portal

Welcome to our feedback site!


We created this site to hear your enhancement ideas, suggestions and feedback about AVEVA products and services. All of the feedback you share here is monitored and reviewed by the AVEVA product managers.

To start, take a look at the ideas in the list below and VOTE for your favorite ideas submitted by other users. POST your own idea if it hasn’t been suggested yet. Include COMMENTS and share relevant business case details that will help our product team get more information on the suggestion. Please note that your ideas and comments are visible to all other users.


This page is for feedback specifically for AVEVA PI System. For links to our other feedback portals, please see the tab RESOURCES below.

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

Eliminate the 2-cell-wide blank border around PI Builder data

When I import data using PI Builder, I usually want to filter the data and create calculated columns, but these prove to be more painful than necessary. If I put filters on the columns containing PI Builder data and then click on the filter dropdown arrow, every column will contain "(Blanks)" as an entry because the 2 blank rows underneath the PI Builder data are included as part of the PI Builder data. This happens because PI Builder modified these rows during the import. Calculated columns are useful to modify the values in an existing column. For the fill-down to work when you double-click on the fill handle (bottom right corner of a selected cell), the calculated column must be directly beside the PI Builder data. However, this doesn't work because the 2 columns to the right of the PI Builder data are formatted as text, so any formula that you write in them will be treated as text. It is a pain to always eliminate the text formatting or delete the columns. In both cases, please ensure that PI Builder does not modify more cells than it needs to.
  • Attach files
  • Kenneth Barber
    Reply
    |
    Aug 20, 2022
    This would hopefully be solved if this were implemented: https://feedback.osisoft.com/forums/555148-pi-server/suggestions/18668149-use-excel-tables-to-contain-pi-builder-data
  • Guest
    Reply
    |
    Aug 20, 2022
    Under the Settings menu item, for the Retrieve tab, there is a setting to control the addition of the two row/column border. If you change the setting to "Clear to Empty Cell boundary, and then also leave the header row blank past the last PI Builder utilized column, this should achieve what you want.
  • Kenneth Barber
    Reply
    |
    Aug 20, 2022
    Actually, that doesn't achieve what I want. I still get a border of blank, modified cells. I understand that the blank border helps to isolate PI Builder data into its own "current region" (that's an Excel term), but I don't understand why the border cells need to be modified by PI Builder, especially when I import data into a new sheet.
  • Guest
    Reply
    |
    Aug 20, 2022
    I can see that the "Clear to Empty Cell Boundary" option is not always being honored in the new import case, only during "Retrieve". We will try to address that in a future release.
  • Guest
    Reply
    |
    Aug 20, 2022
    I can see that the "Clear to Empty Cell Boundary" option is not always being honored in the new import case, only during "Retrieve".  We will try to address that in a future release.
  • Kenneth Barber
    Reply
    |
    Aug 20, 2022
    Hi Chris. Is there a timeline for the fix?