Excel Formatting

TimSmith

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

Cem_Karaer

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.