1 Reply Latest reply on Mar 7, 2018 7:22 AM by LalBabuShaik

    Error on execution of PI Datalink filling, Error "Unable to set NumberFormatLocal property of Range Class"

    Mogens_Petersen1

      When i execute a function in PI Datalink 2016 v. 5.3.0

      Running Excel 2016

      See more details below

       

      I get an PI Datalink Error box "Unable to set NumberFormatLocal property of Range Class"

       

      The date formatting in wrong a looks strange

       

      - Does somebody know what is the problem and how to fix it

       

      // Mogens

       

      Data:

      PI DataLink

      Version

      mscorlib 4.0.0.0 4.7.2115.0 built by: NET47REL1LAST

      Microsoft.VisualStudio.Tools.Office.Runtime 10.0.0.0 10.0.60301.0

      System.Core 4.0.0.0 4.7.2117.0 built by: NET47REL1LAST

      System 4.0.0.0 4.7.2110.0 built by: NET47REL1LAST

      System.Configuration 4.0.0.0 4.7.2046.0 built by: NET47REL1

      System.Xml 4.0.0.0 4.7.2612.0 built by: NET471REL1LAST_B

      System.Security 4.0.0.0 4.7.2046.0 built by: NET47REL1

      Microsoft.VisualStudio.Tools.Applications.Hosting 10.0.0.0 10.0.60301.0

      Microsoft.VisualStudio.Tools.Applications.Runtime 10.0.0.0 10.0.60301.0

      System.Deployment 4.0.0.0 4.7.2046.0 built by: NET47REL1

      Microsoft.VisualStudio.Tools.Applications.ServerDocument 10.0.0.0 10.0.60301.0

      System.Windows.Forms 4.0.0.0 4.7.2110.0 built by: NET47REL1LAST

      System.Drawing 4.0.0.0 4.7.2046.0 built by: NET47REL1

      System.Xml.Linq 4.0.0.0 4.7.2046.0 built by: NET47REL1

      Microsoft.Office.Tools 10.0.0.0 10.0.60301.0

      Microsoft.Office.Tools.Excel.Implementation 10.0.0.0 10.0.60301.0

      Microsoft.Office.Tools.Common.Implementation 10.0.0.0 10.0.60301.0

      Microsoft.Office.Tools.Common 10.0.0.0 10.0.60301.0

      Microsoft.Office.Tools.Excel 10.0.0.0 10.0.60301.0

      OSIsoft.PIDataLink.UI 5.3.5976.30302 5.3.5976.30302

      Microsoft.Office.Tools.Common.v4.0.Utilities 10.0.0.0 10.0.30319.1

      OSIsoft.PIDataLink.Resources 4.2.0.0 5.3.0.0

      Microsoft.GeneratedCode 1.0.0.0

      OSIsoft.PIDataLink.AFData 5.1.0.0 5.3.0.0

      OSIsoft.AFSDK 4.0.0.0 2.8.0.7444

      WindowsBase 4.0.0.0 4.7.2117.0 built by: NET47REL1LAST

      Microsoft.GeneratedCode 1.0.0.0

      OSIsoft.PI.Net 1.5.4.0 1.5.4.21

      OSIsoft.PI.Net.Core 1.5.4.0 1.5.4.21

      Microsoft.GeneratedCode 1.0.0.0

      CustomMarshalers 4.0.0.0 4.7.2046.0 built by: NET47REL1

      OSIsoft.PI.Configuration 1.5.4.0 1.5.4.21

      OSIsoft.PI.Configuration.PISDKRegDirectoryProvider 1.5.4.0 1.5.4.21

      OSIsoft.PI.Resources 1.5.4.0 1.5.4.21

      Microsoft.CSharp 4.0.0.0 4.7.2046.0

      MDBTree.ocx 1.06.0365

      PIDAEXTTREND.dll

      PIDAXL.dll

      PIDO.dll

      PIDAArc.dll

      PIPC32.xll 5.3.0.0

      PISDK.dll 1.4.6.494

      PISDKCommon.dll 1.4.6.494

      PISDKCtl.ocx 1.06.0400

      PISDKDlg.dll 1.08.0420

      PITimeServer.dll

      PITrend.dll

      PIXLTWIZ.dll

      OSIsoft.PIDataLink.Notifications.Common.dll 5.3.0.0 5.3.0.0

      OSIsoft.PIDataLink.Notifications2007.UDF.dll 5.3.0.0 5.3.0.0

      OSIsoft.PIDataLink.Notifications2007.UI.dll 5.3.0.0 5.3.0.0

      Copyright (c) {0}, OSIsoft, LLC

       

      Microsoft Excel Version 2016 MSO (16.0.4549.1000) 32 bit