I have a row of totals in my grid. I add a custom footer to my grid where I add a grand total for 3 total columns to the last cell. I add a <br /> and to all the other cells as shown below.
on my excel export the blank cell does not show. It seems excel is ignoring the line break and empty cell and just bottom aligning the total for me. See attached.
I even tried the approach in some other threads to replace the <br /> with but that just takes the new line away completely.