Excel Buffer, no value in RangeEndXlRow

qwo
qwo Member Posts: 4
edited 2010-04-30 in NAV/Navision Classic Client
Hi! I've a problem exporting budget data to Excel. Being in CreateValidationRule(Range) function (in Table 370 Excel Bufer) there are values in RangeStartXlCol, RangeStartXlRow and RangeEndXlCol, but there's no value in RangeEndXlRow which is needed to run code 
XLValidation.Add(3,1,1,
  '=' + GetExcelReference(4) + RangeStartXlCol + GetExcelReference(4) + RangeStartXlRow +
  ':' + GetExcelReference(4) + RangeEndXlCol + GetExcelReference(4) + RangeEndXlRow);
in that function. The effect is, that I've a break on this code above.

Have you got any idea about a reason of that?

Categories