round up Javascript in Adobe Acrobat 1

[csb1021]

Hello - I need help with writing a javascript to round up a field. I've converted an Excel form to a PDF, and in the Excel form, the code used is: =ROUNDUP(H32, -3)

What I have is 2 fields. One field called Subtotal.1 is the actual total dollars, and the other field called RSubtotal.0 is the 'round up' of Subtotal.1.

Does anyone know what the javascript code would be for this?

Thanks
Connie

 

[MarkWalsh]

Math.ceil(1.1)

will round up to 2

 

[csb1021]

I tried this and it didn't work????

 

[MarkWalsh]

What is the exact code you used? Where did you place the code?

Based on the names of your fields, this works for me in the 'Calculate' event of the RSubtotal.0 field

event.value = Math.ceil(this.getField("Subtotal.1").value)

 

[csb1021]

Hello Mark Walsh

This worked pretty good, however, the owners would like the field to round up - for example, if the Subtotal.1 is $9,144, RSubtotal.0 rounds up to $10,000.00, is this possible?

Thanks Much
Connie Bretes

 

[MarkWalsh]

If you're trying to round up to the nearest 1000, then try this:

event.value = Math.ceil(event.value/ 1000) * 1000

 

[csb1021]

Hello Mark and others:

Does anyone know if a good book to purchase that covers Adobe Acrobat and Javascripts like what was covered above?

 

[MarkWalsh]

There aren't too many books that cover Acrobat javascript, other than the Adobe guides:

http://partners.adobe.com/public/developer/en/acrobat/sdk/AcroJSGuide.pdf

http://partners.adobe.com/public/developer/en/acrobat/sdk/AcroJS.pdf

These mostly cover the Acrobat-specific context. For more generic Javascript context, there are many books, I have the O'Reilly book:

http://www.amazon.com/gp/product/05..._m=ATVPDKIKX0DER&pf_rd_r=1KK8E1XBNSMFR5J6WZXQ

Also, often when looking for specific context, I just use google to find what I am looking for instead of pulling out the book.