Normal Topic Decimals in WordMerge (Read 611 times)
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Decimals in WordMerge
Oct 2nd, 2010 at 11:01am
Print Post Print Post  
Hello!
I use  the Version "WordMerge 3 Advanced Subform Support"  from Carl Underwoord  in June edition 2010 Insidesesame.
It works well with the supplied documents. But with my Database printing in Word the Number - Fields have no decimals !.
The numerical fields in my Subform are formatted as follows:
Price field Display Format : 1.590 ,00[1,2%16.2f ]
Total field Display Format : 1.590 ,00[1,2%16.2f ]

Is the Problem in formatting of Subform - fields?

Thank you for the help!
  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1350
Location: New Hampshire
Joined: Mar 11th, 2003
Re: Decimals in WordMerge
Reply #1 - Oct 3rd, 2010 at 1:59am
Print Post Print Post  
I'm not sure what you mean. Do you mean the document has just the integer portion of the number, without the fraction; or do you mean the Word document doesn't show any numbers?

If the document doesn't show any numbers, then make sure that you have assigned the vNumberSample and vMoneySample variables correctly. These variables must be set to the names (in quotes) of Layout Elements on the parent form which represent the formats that you want to appear in the Word document. (If you don't already have elements on the parent form that have the format you want to use, you can add unbound, hidden, elements just for this purpose.)

If the variables are not customized for your form, you will end up with blanks in the Word document.

  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged
 
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re: Decimals in WordMerge
Reply #2 - Oct 3rd, 2010 at 11:41am
Print Post Print Post  
Hello Carl!

Yes i mean the document has just the integer portion of the number, without the fraction.

Thanks.

Dr. Belhareth
  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1350
Location: New Hampshire
Joined: Mar 11th, 2003
Re: Decimals in WordMerge
Reply #3 - Oct 3rd, 2010 at 10:39pm
Print Post Print Post  
I changed my OS to use European display settings to test it here, and I don't see that problem.

You can check to see if it's being exported from Sesame correctly by opening the MergeData.txt file, and looking to see if the numbers are correct there. If they are okay there, then the problem lies with Word.
  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged