 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / December 2004decimal and percentage issue
I noticed a weird behavior using decimal numbers. (I'm using italian regional settings) If a textbox is supposed to contain a percentage (or even a number) the result is displayed multiplied by 100: for an actual value of "12" what I see is "1200,00" (even if in the managed code I got the correct value). If I insert "12" that's ok, I get the correct value both in the xml and in the textbox. If I insert "12,00", "12,00" is displayed, but the value become "1200" and my percentage is meaningless! If I insert "12.00" I get "1200,00" both in the xml and in the textbox, screwing up again. The same behavior with currency, set to euro. Is infopath able to deal with percentages and to sum decimals? What is the actual data type of the field you are binding to. Does it come from XML, SQL, Access, or a Web Service? Also what is the actual field formatting that is being used? Thanx.  SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com I noticed a weird behavior using decimal numbers. (I'm using italian regional settings) If a textbox is supposed to contain a percentage (or even a number) the result is displayed multiplied by 100: for an actual value of "12" what I see is "1200,00" (even if in the managed code I got the correct value). If I insert "12" that's ok, I get the correct value both in the xml and in the textbox. If I insert "12,00", "12,00" is displayed, but the value become "1200" and my percentage is meaningless! If I insert "12.00" I get "1200,00" both in the xml and in the textbox, screwing up again. The same behavior with currency, set to euro. Is infopath able to deal with percentages and to sum decimals? I solved, it was a CultureInfo issue. Btw a percentage is stored as (value you type) / 100, that's all. > What is the actual data type of the field you are binding to. Does it come from XML, SQL, Access, or a Web Service? > Also what is the actual field formatting that is being used? > > Thanx. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.