General

Re: Spellnumber in InfoPath

Hilary Stoupa — Mon, 14 Sep 2015 14:20:34 GMT

Here's a link to Jimmy's initial C# code from the beginning of the thread - hope this helps: http://www.infopathdev.com/blogs/jimmy/misc/SpellNum.txt

Re: Spellnumber in InfoPath

bnvelarde — Mon, 14 Sep 2015 07:45:52 GMT

Hi miss Hilary, Do still have the 2010 code? Have a nice day! :) Thanks and kind regards, ~Bern

Re: Spellnumber in InfoPath

Gennady Vanin (Геннадий Ванин, Новосибирск) — Wed, 19 Sep 2012 12:38:57 GMT

chajang:
May I ask some question about InfoPath 2010 with code-behind?
I have develop InfoPath form using InfoPath 2010 with SharePoint 2010

I have run successfully this code from Sharepoint Onine (Office 365) site both in browser and filler (Sharepoint Server 2010 + Infopath 2010)
In order to run in browser, it is necessary to comment a line of code with MessageBox, since MessageBox is not supported in browser forms.
I did not read all thread but while Jimmy wrote to use Expression Box for spelledNumber, I've used a text box instead.

There is no need to attribute Full Trust and digitally sign this code (and hence administrator approval) for running published Web Browser Form template.
It is necessary only for being able to run in preview (this Microsoft Infopath quirk which I do not completely understand).

chajang:
I publish this form as Document Information Panel (DIP) content type on SharePoint

Make sure that content type is not set as read-only upon publishing.

Re: Spellnumber in InfoPath

chajang — Fri, 27 Jul 2012 07:54:20 GMT

Hi, all.

May I ask some question about InfoPath 2010 with code-behind?

I have develop InfoPath form using InfoPath 2010 with SharePoint 2010.

I publish this form as Document Information Panel (DIP) content type on SharePoint and attached this SpellNum.cs to form's code-behind.

Everything go fine when I preview this form within InfoPath on local. But when I publish this form to SharePoint with Full Trust/Create certificate, there is no luck.

After Microsoft word has launched, it's seem code-behind does not fired to onchanged event when input number to number field in Document Property pane.

My question is:

Is this InfoPath form has deployed as sandboxed-solution?
Custom code-behind worked on form service, can it worked on DIP too?

Anyway, form formula has work perfectly but not code-behind.

Thank you very much.

Re: Spellnumber in InfoPath

ziriax — Mon, 16 Jul 2012 19:53:36 GMT

I found some code that I was able to make work. Let me know if anyone would like me to post.

Julie :)

Re: Spellnumber in InfoPath

ziriax — Fri, 13 Jul 2012 18:12:34 GMT

Jimmy, I would like to use your C# code in my InfoPath 2010 form but I need help adding code to handle decimals. I am building a form that our accounting department will need to print checks from and need to incorporate the cents, preferably in a XX/100 format. The provided code doesn't handle decimals at all. Your help is much appreciated.

Julie

Re: Spellnumber in InfoPath

Jimmy — Fri, 06 Jan 2012 07:58:11 GMT

Hello Jorge,

That's not much information to go on. Could you try walking the code in the debugger to find at least which is the line where the error is occurring?

Re: Spellnumber in InfoPath

Jorge — Thu, 05 Jan 2012 21:43:06 GMT

Hello I Just did you steps but I have an Error Could be i am using Infopath 2010 I dont know i am new in this.

This is the error

InvalidOperationException

Re: Spellnumber in InfoPath

Hilary Stoupa — Tue, 14 Dec 2010 18:27:48 GMT

Yup, looks like the previous link fell victim to some tidying. I'll update the original post, and here's the new link.

Re: Spellnumber in InfoPath

doddwell — Tue, 14 Dec 2010 18:21:08 GMT

Hello Hilary. Do you still have the 2003 example in your final post? There is a problem when I click the link. Thanks, Simon

Re: Spellnumber in InfoPath

Anonymous — Mon, 09 Nov 2009 15:52:48 GMT

Thanks Jimmy, I figured it was due to some sort of rounding issue but just don't know enough about code to be able to sort it out. This seems to have fixed the problem.

Re: Spellnumber in InfoPath

Jimmy — Mon, 09 Nov 2009 15:37:41 GMT

You're certainly right. This is due to small roundoff errors in floating point arithmetic causing 150.98 * 100 to produce 15097.9999999998 instead of 15098. This should solve the problem:

Change

var hundredths = parseInt((num * 100 - parseInt(num) * 100));

var hundredths = Math.floor(num * 100 + 0.1) - Math.floor(num) * 100;

Re: Spellnumber in InfoPath

Anonymous — Mon, 09 Nov 2009 10:46:52 GMT

HI all, I've just encountered a small bug that's occurring with this code. When a user enters in a value for my:ChequeAmount, the text generated in the my:AmountWords field is sometimes off by a penny. I've gone through and tested all denominations and it appears that the pence (cents) are falling short on occurrences of .14, .17, .20, .23, .39, .42, .45, .48, .64, .67, .70, .73, .89, .92, .95 and .98.

So basically if a user inputs £150.98 into the my:ChequeAmount field, my:AmountWords is spelling out One Hundred Fifty Pounds and Ninety-Seven Pence. The really strange thing is that this doesn't happen every single time but is always happening with my:ChequeAmount has a pence value equal to one of the above.

I've attached the code I'm using so if anyone has any thoughts on what could be causing this I'd be greatful for your input!

Re: Spellnumber in InfoPath

Jimmy — Tue, 16 Jun 2009 10:57:06 GMT

Hey Ben,

Glad it worked out. You can actually find out the namespace URN of any node (typically all the nodes in your main data source will have the same namespace), by opening the node's properties in the Data Source taskpane, and looking at the Details tab.

I couldn't come up with a great response to your other inquiry, but I did come up with a solution of sorts. Please go have a look when you get the chance.

Re: Spellnumber in InfoPath

Anonymous — Tue, 16 Jun 2009 08:37:23 GMT

Thanks Jimmy, that worked like a charm! I'd never have figured out that out but so I know for the future, am I right in thinking you determined the correct namespace by saving as source files and then opening the .xsd file in notepad? It's a great piece of code so it's really helpful to understand how to move it into other forms.

I was also wondering, with you and Hilary being the InfoPath geniuses you are, if you'd mind looking at another issue I've posted on here that has me stumped (it's always the things that seem like they should be so simple that cause the most hassle in InfoPath!)?

http://www.infopathdev.com/forums/p/12086/42365.aspx#42365

Thanks again!