How to make correct Underline with Excel Buffer

selece28

Hi NAV Masters,
I'm using Excel Buffer to do function to Export to Excel.
When using the Addcolumn function when i set the property of Underline = TRUE. It seems that on the excel the result is NOT Underline but Draw a bottom line like when creating a table on Excel.

My Question is, how can we fix this? How to make the right underline just for the text.

Thanks in advance

kine

You need to modify the excel buffer to not set the border but font property. Just record the macro for that in Excel, look into it, find the point in Excel buffer where the Underline field is used and change the code to smething similar what you can see in the macro in VB.

selece28

Ow OK Thanks Kine. Its solved