This content has been marked as final. Show 5 replies
The concept code below is a bit torturous, but will probably get you what you're after. The idea is to place the right parenthesis in an adjoining column. You will need to place NumberFormat ( ) into the mix somewhere.
Use a negative sign instead of brackets to indicate negative numbers.
Thank you very much for responding to my question.
Unfortunately CELLPADDING and/or CELLSPACING can not be 0 since it is a very complex reporting format.
If I set them to 0 then I have to add bunch of extra blank columns to compensate for that.
Any other suggestions?
I believe MS Word and Adobe writer have a tab or a formatting style specifically for this purpose.
Has anyone explored writing a custom tag or a script maybe to call adobe pdf API to utilize pdf writer's formatting capability?
I can't believe I am the first person requiring to do this.
Hopefully when we come up with an answer everyone can benefit.
Looking forward to more respond, please!!!
dear lord this isn't by any means pretty or elegant... but just to toss it out there as an option...
Use an empty image tag to position positive numbers instead of a space - play around with the exact width until it lines up correctly.
The example below places a 5 pixel blank image after positive numbers:
#NumberFormat(anyNumber,"(9,999)" )#<cfif anyNumber ge 0><img width="5" height="0"></cfif>