Report value change after export to excel

yvonne
yvonne Member Posts: 31
edited 2006-09-27 in NAV/Navision Classic Client
Report value change after export to excel at my client PC only (NAV3.7) & this problem not happen to my pc. Both of us use same OS, Client Excel version is 2000 & im using 2003

Actual value should as "24-12", but it change to either date value "24DEC" or 12 (24-12=12) after export to excel.

Code written:
EnterCell(RowNo,4,Format("Sales Invoice Line"."No.", FALSE, FALSE, FALSE))

EnterCell(RowNo: Integer; ColumnNo:Integer; CellValue:Text[250]; Bold:Boolean; Italic:Boolean; Underline:Boolean)
TempExcelBuffer.INIT;
TempExcelBuffer.Validate("Row No.", RowNo);
TempExcelBuffer.Validate("Column No.", ColumnNo);
TempExcelBuffer."Cell Value as Text" := CellValue;
TempExcelBuffer.Formula := '';
TempExcelBuffer.Bold := Bold;
TempExcelBuffer.Italic := Italic;
TempExcelBuffer.Underline := Underline;
TempExcelBuffer.Insert;

Besides this, how to format Excel Column to TExt Column in Navision?

:? Beginner

Comments

  • lakshmivalluru
    lakshmivalluru Member Posts: 168
    try this:

    EnterCell(RowNo,4,Format("Sales Invoice Line"."No.", FALSE, FALSE, '@'))
    LR
  • lakshmivalluru
    lakshmivalluru Member Posts: 168
    sorry try this:

    x := format("Sales Invoice Line"."No.");
    EnterCell(RowNo,4,X, FALSE, FALSE, '@') ;

    or

    EnterCell(RowNo,4,format("Sales Invoice Line"."No"), FALSE, FALSE, '@') ;
    LR
  • yvonne
    yvonne Member Posts: 31
    Lakshmivalluru tks for opinion, i follow your coding, but the problem stil remain.

    :|

Categories