I have header text that varies in size (1 to 4 lines) and right now the text box is sized according to the number of text lines in it and then the bottoms are aligned. However, when I try to export the text to excel, the headers do not match up with the text. The header that is 4 lines long is the 1st column header that appears, I'm assuming because this is the 1st text that is encountered. Is there a way to make the text boxes all the same height, and align text to the bottoms so that the headers match up with the correct columns. If I try to align to bottoms or baseline, just the text boxes are aligned and not the text inside. I have also tried to put in hard returns so that the text is at the bottom of the box, but then those returns are present in the excel file as boxes before the text.
Any way to align the text at the botton of the box so that it exports correctly? The only thing I have come up with is to make the boxes the same height and the tops will be aligned, but for a header I think it looks bad.
Any way to align the text at the botton of the box so that it exports correctly? The only thing I have come up with is to make the boxes the same height and the tops will be aligned, but for a header I think it looks bad.