We do have a requirement where-in we apply all types of borders on rows and columns.
While verifying the same, i did notice that when applying borders for a cell that sits below a merged cell the behavior is different.
In the attached spreadsheet documents [SpreadsheetML format] please note:
In Row 3 columns are merged from A to J and we are applying borders from Row 4 to Row 29.
Now, if i do apply border [Top Bottom] on I4 cell, it works fine.
If i do apply border on J4, i do get a Top Border from A4 to J4 and a bottom border only on J4. Typically, i would have expected it only on J4.
(Please do ignore the hidden rows and columns, they are a part of our business logic)
Please do verify the attached spread sheets and let me know if you are looking for any information.
Thanks & Regards,