How can I convert an excel formula to javascript

wwilson80 · October 23rd, 2009, 04:51 PM

How can I convert the following excel formula to javascript I can use in a PDF calculation?

If (B4 > B3, B3-B4,"")

Any help would be appreciated.

Old Pedant · October 23rd, 2009, 09:01 PM

How can you use JavaScript to do a PDF calculation??? That's a much bigger question!

And where are you getting the *cells* from in JavaScript to emulate a spreadsheet, in the first place???

Oh, well. The JS equivalent would be:

Code:

     ( B4 > B3 ? B3 - B4 : "" )

wwilson80 · October 23rd, 2009, 09:30 PM

I am sorry, the PDF fields refered to are as follows:

B4 = Field "Deposit"
B3 = Field "GT
The field this calculation is going into is called "REFUND"
I do not know a lot about javascript but I do know you have to define var
Thank you for your post and any other help you can give me on this.

Old Pedant · October 23rd, 2009, 10:03 PM

I *still* don't have the foggiest idea how JavaScript can affect the contents of a PDF file. So far as I know, JavaScript won't even be aware that you are using the browser to display a PDF file.

Can you show an example page that uses JS to affect PDF in any way???

Ahhhh....wait! You are referring to using JavaScript in Acrobat *developer*, not in the reader, is that right???

Okay...then my basic answer is correct:

Code:

REFUND =  ( Deposit > GT ? GT - Deposit : "" );

But presumably you must use Adobe's DOM to specify those fields in the document more clearly.

And that I know *nothing* about.