topic Re: Retain leading zeroes in ExcelXP in ODS and Base Reporting

Retain leading zeroes in ExcelXP

deleted_user — Wed, 31 May 2006 22:00:37 GMT

Hi,

I've retained leading zeroes for Excel output via ODS HTML using

... htmlstyle='vnd.ms-excel.numberformat:@' ...

Is there a similar TAGATTR attribute for ExcelXP?

Re: Retain leading zeroes in ExcelXP

Eric_SAS — Thu, 01 Jun 2006 15:24:36 GMT

you can use

tagattr="format: @"

When you do that, the type will also be changed from number, to string.

This only works in the latest versions of the tagset. The newest version will be available later today. it's worth waiting for because it fixes a couple of bugs reported by Jack earlier this week.

Re: Retain leading zeroes in ExcelXP

deleted_user — Thu, 01 Jun 2006 19:01:39 GMT

Thanks, Eric. I'll look for that update.

Re: Retain leading zeroes in ExcelXP

Eric_SAS — Thu, 01 Jun 2006 21:39:52 GMT

The new tagset is now on the web...

http://support.sas.com/rnd/base/topics/odsmarkup/excltags.tpl

Re: Retain leading zeroes in ExcelXP

deleted_user — Thu, 20 Jul 2006 15:00:40 GMT

> The new tagset is now on the web...
>
> http://support.sas.com/rnd/base/topics/odsmarkup/exclt
> gs.tpl

This URL doesn't work - it goes to a 404 page( SAS page that says "We're sorry. We couldn't find your document"). You need to add a final l to the link to get there (the Forum software is truncating it - I tried to post a corrected link and Preview showed that mine was truncated, too).

Steve Raimi