Hi i'm trying to render a table header for an excel output.
The problem is that i can't merge cells as i prefer.
I tried the tagattr mergeDown and mergeAcross, but i guess i used it in a wrong way.
Anyway below is the code of the proc template to override the style "sansPrinter" for the table, header, data ...
I manage the output with a proc report so i have more options to render the header, but maybe there is another way using the proc print.
Basically, i want the cell with the content "Wohnsitzgemeinde" to mergeDown 2 cells and the cell "Berufsauspendler" to mergeAcross 6 cells.
The cells with contents "zusammen" and "darunter weiblich" should mergeDown 1 cell each and the cell "im Alter von ... bis unter ... Jahren" to mergeAcross 4 cells.
Sorry for german content in cells, but actually the content is not important.
This is what i'm trying to get, when i look in the xml code.
I have only ever used TAGATTR for FORMATS and FORMULAS. I have never used TAGATTR to perform a MERGEDOWN and I am not sure that what you want to do is possible. The ss:Mergedown is a style property instruction that Microsoft Excel knows how to interpret and render. I understand what you're trying to do in the style template, but what you are attempting may not work.
I'd recommend opening a track with Tech Support, they can tell you whether what you want to do is actually possible a style template method.
I was actually afraid to get this kind of answer. For the past 3 days i googled for the TAGATTR MERGEDOWN, but couln't find any papers, where it was explained how to use it.
Since i have to render quite a lot of table header for excel output and i often fail to merge cells, i will follow your suggestion and i will contact the Tech Support.
Thank you very much for your effort and for your quick reply