Re: HSSFCGI - Format numbers

[Bdietz400 <bdietz400@xxxxxxxxx>]

You might want to try the google groups site that easy400.net has setup.   See below...

Should you have any problems with our stuff,
- you may directly contact me, or
- post a message to the Easy400Group,
http://tech.groups.yahoo.com/group/Easy400Group/ .

Bryan

On Jul 18, 2011, at 4:21 PM, vforbes@xxxxxxxxx wrote:

> I am using Easy400's HSSFCGI to create Excel spreadsheets.  A request came in to format the numbers to exclude commas.
>
> I tried using the CGIDEV2 examples with the UpdHtmlVar & WrtSection.
>
> ie.
> wrtsection('startcell');
>  updhtmlvar('datatype':'number');
>  updhtmlvar('format':'###0.00;[Red]\-###0.00\ ');
>    wrtsection('startdata');
>    data = íitC(Col03c:'3');
>    updhtmlvar('data':data);
>    wrtsection('data');
>  wrtsection('enddata');
> wrtsection('endcell');
>
> Any suggestions?
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.