mibuso.com
Home› Navision Attain
Options

Exporting Budget to a Dutch Excel

Erik_EErik_E Member Posts: 17
edited 2004-03-30 in Navision Attain
I am having a problem exporting a Budget into a Dutch Excel with totalling. It seems that navision uses the function sum instead of SOM, which gives an error in Excel ( #NAME) , Does anyone know how to fix this in Excel or Navision?? TIA

Comments

  • kinekine Member Posts: 12,562
    Look into Table 370, into global Text Constants... Text017 - in english ="SUMIF" .... is this the right string? If not, enter translation...
    8)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Erik_EErik_E Member Posts: 17
    With help from Navison I finally got it. It was in table 370 , but it was in a diff area, namelijk




    ThisCellHasFormulaError := //Changed: AddToFormula('sum(' + xlColID + FORMAT(FirstRow) + ':' + xlColID + FORMAT(LastRow) + ')');


    Into AddToFormula(Text023+'(' + xlColID + FORMAT(FirstRow) + ':' + xlColID + FORMAT(LastRow) + ')'); //FCE

    And made textglobal text023 ENU=SUM;NLD=SOM
Sign In or Register to comment.