AVEVA™ PI System™ Feedback Portal

Welcome to our new 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.

Add a new idea Subscribe
Status Completed
Product AVEVA™ PI DataLink™
Categories Functions
Created by Kenneth Barber
Created on Aug 16, 2022

RELATED IDEAS

Use dynamic arrays for array functions on versions of Excel that support dynamic arrays

Currently, if you use the GUI to return an array of values, the array formula will always use a static array, even on versions of Excel that support dynamic arrays. Also, if you manually enter a PI DataLink array formula as a dynamic array (i.e. you are using Enter and not Ctrl + Shift + Enter) in a version of Excel that supports them, the top cell will contain the message "Resize to show all values", even when there is enough room to show all values. Please make PI DataLink adapt its behaviour according to the version of Excel. If the Excel version supports dynamic arrays, then array formulas generated by the GUI should use dynamic arrays, and the message "Resize to show all values" should never be used, since Excel will just generate a #SPILL! error. If the Excel version does not support dynamic arrays, then PI DataLink should continue with its current behaviour. After extended support ends for Office 2016 and Office 2019 in 2025, all supported versions of Excel will support dynamic arrays, and all support for static arrays could then be dropped from PI DataLink.
  • ADMIN RESPONSE
    Aug 16, 2022
    This feature is implemented in PI DataLink 2022. You can download the setup kit from the customer portal product page ( https://customers.osisoft.com/s/products ). Please refer to the release announcement ( https://pisquare.osisoft.com/s/article/000039177 ) for more details.
  • Attach files
  • Kenneth Barber
    Reply
    |     Aug 16, 2022
    Sorry, I made a few mistakes with that last sentence. It should read: "After 2025, all supported versions of Excel will support dynamic arrays, and all support for static arrays can then be dropped from PI DataLink." I didn't mean to say that support for CSE arrays would be dropped. I also looked up the end of life of Office 2016 and Office 2019 (rather than estimate), and they are both essentially the end of 2025.
  • Kenneth Barber
    Reply
    |     Aug 16, 2022
    Jeremy, can you do me a favour and edit my suggestion to contain the correction that I mentioned, and then delete our comments? That should reduce the clutter in this suggestion.
  • lilu
    Reply
    |     Aug 16, 2022
    @Victor Zhang When is the planned release for PI DataLink 2021?