I created a Excel list with one header row, and one data row. The data row is
styled to have a specific background color and a border. But when I insert a
new row, the Background color is carrried along in the new row, but the
border is not. Is this an Excel bug? Does Microsoft provide a fix for this.
Actually the same buggy behaviour can be seen during XmlMap.ImportXml. If say
for a list, background color & borders are specified for the first row, and
then an importxml is performed on the list. The only the first row shows the
specified background color and border. All the other rows show the specified
background color but not the border. If the background color is preserved,
why not the border? Is there a way to resolve this issue instead of having
to set the border for each row after performing the importXml on the List
object?
--
Thanks
Geetha.