Excel Formatting

TimSmith
TimSmith Member Posts: 36
edited 2006-07-25 in NAV/Navision Classic Client
I wish to do the following two things on my spreadsheet, as an output from Nav.

1. Put some text as bold.

2. Put the total lines around my sums.....
e.g

Advice as always is much appreciated.

Tim

Comments

  • Cem_Karaer
    Cem_Karaer Member Posts: 281
    I think you use ExcelBuffer table. ExcelBuffer's Bold property can be used for writing bold texts;

    ExlBuff as Record subtype ExcelBuffer

    ExlBuff.Bold := TRUE;

    And you can use the Formula property of the same table;

    ExlBuff.Formula := '=SUM(A1:A40)';

    will create a formula that sums up cells from A1 to A40 on the working cell.
    Cem Karaer @ Pargesoft
    Dynamics NAV Developer since 2005

Categories