Exporting Budget to a Dutch Excel

Erik_E

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

kine

Look into Table 370, into global Text Constants... Text017 - in english ="SUMIF" .... is this the right string? If not, enter translation...
8)

Erik_E

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