Make table border setting override cell styles
Currently, if I set a table border via Table Styles, then set a cell style with no borders around the cells, the cell style overrides the table style and the border around the table is removed. The only way around this is to create separate cell styles for the header, footer, left, and right columns and assign those to the table style-- that's a lot of junk styles needed to accomplish one piece of formatting.
My suggestion is to let us choose whether or not the table border overrides cell styles. That way, setting the table border becomes a one click operation rather than a tedious style creation and assignment process.
Another potential way of doing this is to just allow the user to choose only INTERNAL borders when creating the cell style.
T. Carano commented
I originally posted a long message as to why this is needed and upvoted the feature request. Then, I realized this feature already there. Instead of selecting 'None' for cell borders, select '(Ignore)'. The table border styles will be grayed out. When I did this, the table borders showed over the background color. This allows users that do need to override the table borders (I'm sure there are use cases where this is needed) to set borders accordingly. However, if you want the table borders to show (as I'm sure the vast majority do), leave it at the default setting (grayed out) and it will work.
Alvaro Beleza commented
I was googling for a solution about this issue (table border override cell borders) then I came here. After some tries, I realized there is a way to do that and may help you guys.
As you can see by my attached image, the outer border has a different color and weight than the cell borders. I did that by going to the Table Style then editing Row and Column Strokes. Assure the cell border's color and weight are blank (delete the weight and select "(ignore)" for the color).
Hope that helps. :)
Janus Bahs Jacquet commented
This is absolutely vital for using tables. I cannot think of a single case where you would want cell borders to override table borders – if you wanted that, you’d simply just not specify a table border.
Table borders should override cell borders by default; anything else is just madness. The hierarchy should be table borders > header/footer cell borders > body cell borders, which is the exact opposite of what it currently is.
I feel like I was taking crazy pills here trying to figure out why I can't have both a table border and cell style.
Jayaraj B commented
Exactly, same is an issue with tables........