Hello,
My application fills an xlsx file with data and must sometimes separate rows by setting bottom border.
Here is the code used to set the bottom border:
private void SetRowBottomBorder(XlsFile p_xfData, int p_nRow, TFlxBorderStyle p_bsStyle)
{
var l_tffBottomBorder = p_xfData.GetDefaultFormat;
l_tffBottomBorder.Borders.Bottom = new TFlxOneBorder(p_bsStyle, TExcelColor.Automatic);
var l_tafApply = new TFlxApplyFormat();
l_tafApply.SetAllMembers(false);
l_tafApply.Borders.Bottom = true;
p_xfData.SetCellFormat(p_nRow, 1, p_nRow, (int)ExcelColumns.Count -1, l_tffBottomBorder, l_tafApply);
}
Here is the empty Excel document my software fills with data:
And here is the filled document, with problem regarding to vertical borders only on EMPTY CELLS:
Can you please help me solve the format problem?
Thank you in advance
Greetings
J-D Gasser