The SAS Output Delivery System and reporting techniques

excelxp: indent a right aligned column

Reply
Occasional Contributor
Posts: 7

excelxp: indent a right aligned column

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

SAS Super FREQ
Posts: 8,868

excelxp: indent a right aligned column

Posted in reply to staffordst

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

Occasional Contributor
Posts: 7

excelxp: indent a right aligned column

Posted in reply to staffordst

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.

Ask a Question
Discussion stats
  • 2 replies
  • 199 views
  • 0 likes
  • 2 in conversation