topic excelxp: indent a right aligned column in ODS and Base Reporting

excelxp: indent a right aligned column

staffordst — Wed, 04 Jan 2012 17:58:15 GMT

Using tagsets.excelp, we have a right-aligned column. Is there a way to indent it a few spaces from the right border?

If there is a tagattr for this, I don't know what it is.

Thanks

excelxp: indent a right aligned column

Cynthia_sas — Wed, 04 Jan 2012 18:02:36 GMT

Hi:

Other destinations, like RTF, PDF and HTML have style attributes like LEFTMARGIN and INDENT that can be used to perform indenting, such as you describe. You could try to pad the value with non-breaking space characters, but in a numeric field, I think Excel ignores leading spaces in a numeric field.

So, you might want to work with Tech Support on this because it may be more than a simple TAGATTR solution.

cynthia

excelxp: indent a right aligned column

staffordst — Wed, 04 Jan 2012 18:13:26 GMT

The "More Like This" box on the right column of this site suggested this:

//http://communities.sas.com/message/42621#42621

which looks like it will probably work.

Many thanks to all the folks who make this site possible.