tracker issue : CF-3491238

select a category, or use search below
(searches all categories and all time range)
Title:

NumberFormat returns different results with optional placeholders

| View in Tracker

Status/Resolution/Reason: Closed/Deferred/HighRisk

Reporter/Name(from Bugbase): Dan Wilson / Dan Wilson (Dan Wilson)

Created: 01/28/2013

Components: Language

Versions: 10.0

Failure Type:

Found In Build/Fixed In Build: Final /

Priority/Frequency: Major / All users will encounter

Locale/System: English / Windows 7 64-bit

Vote Count: 0

Problem Description:
The documentation for CF states either an underscore or a 9 can be used as an optional placeholder. However, these do not return the same results when used along with a $ sign.


Steps to Reproduce:

<cfoutput>
#NumberFormat("200", "_$_,___.__")#
#NumberFormat("200", "_$9,999.99")#
</cfoutput>

Actual Result:
$200.00 $ 200.00

Expected Result:
$200.00 $200.00

Any Workarounds:

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3491238

External Customer Info:
External Company:  
External Customer Name: DanWilson_
External Customer Email:  
External Test Config: Win7/CF10

Attachments:

Comments:

The documentation states: _ (underscore) Optional. Digit placeholder. 9 Optional. Digit placeholder. (Shows decimal places more clearly than _.) This should mean the placement of the dollar sign should be the same.
Comment by External U.
16490 | January 28, 2013 01:59:57 PM GMT
This is an easy workaround by not mixing 9 and _ . #NumberFormat("200", "9$9,999.99")# will work fine.
Comment by Awdhesh K.
16491 | September 24, 2013 04:33:01 AM GMT