0 Replies Latest reply: Mar 14, 2018 10:59 AM by Johan Kruize RSS

    Nprinting adds link to temp file in excel formula

    Johan Kruize

      I created an Excel report containing a page for every dimension.

      The last sheet contains the data retrieved form a qlik app

       

      In the excel template I use a formula like :

      =sumif(data!D:D;C9;E:E)

       

      When previewing the results, or when I run this report in a task, the formula's in the report are changed to :

      =SUMIF('C:\Users\myname\AppData\Local\Temp\f1cea6a6c8044804b3fbc2233270d175\[20180314030001.xlsx]Data'!B:B;C8;'C:\Users\myname\AppData\Local\Temp\f1cea6a6c8044804b3fbc2233270d175\[20180314030001.xlsx]Data'!D:D)

       

      When I use the same formula without the "page-level-indicator" formulas are calculated correctly

       

      How to solve this ?

       

      We are using Nprinting 17.6.0000.0