Hi: Yes, this is the same behavior I get when I run sample07 for ExcelXP. I believe this is because your ODS style is only meant to control the grid lines INSIDE the table created by ODS. The reason the interior grid lines are light peach and that the rest of the spreadsheet is that same peachy color is because that sample inherits the colors from styles.Statistical -- which defines those colors. If you want to change the color scheme used in sample07, then change the parent= statement to inherit from a different style template (perhaps one like sasweb or printer) in this statement: [pre] parent = styles.sasweb; [/pre] in the proc template code and the parent template colors will be used. If you're asking whether you can use a style template to restore ALL the interior gridlines in the Excel spreadsheet, I think that the answer is NO. I tried the gridlines option for tagsets.ExcelXP and, as expected, it did not have an effect on what you see in the spreadsheet because it only has an effect on printing (according to the doc). cynthia ... View more

I just found myself the answer...:-) I should use Option (embedded_titles='yes'), so the ods statement would be: ods &_ODSDEST file=_webout style=&_ODSSTYLE options(default_column_width="7.5, 7.5, 5, 7.5, 7.5" embedded_titles='yes' ); Regards to all the forum members! ... View more

Thank you, excellent explanation! I tried to find out too how the tab character gets converted by Acrobat Distiller, but so far I haven't found a precise answer... Best regards. Michela ... View more

Thank you very much, it works perfectly now! Kind regards. Michela ... View more