Custom Calculation Script
I have a PDF converted from Excel using this Simple Calculation =B12+B14+B15+B17+(B18*0.485)+B19
When I use the same calculation in Javascript it causes $3.00 to become $30.00
event.value = this.getField("M
My format is correct and if I remove *0.485 calculation it works right.
Please don't tell me you can't use addition WITH multiplication. That would almost render Acrobat useless for fom calcs.
The form is here to check
[link=http://www.rockndj.com/TravelAuthorization.pdf]http://www.rockndj.com/TravelAuthorization.pdf[/link]
Custom Calculation Script
2007-04-03 09:22:49
My Product Information:
Acrobat Pro 8, Windows
Acrobat Pro 8, Windows
2007-04-03 13:56:45
#2
try this link
[url=http://www.rockndj.com/TravelAuthorization.pdf]http://www.rockndj.com/TravelAuthorization.pdf[/url]
[url=http://www.rockndj.com/TravelAuthorization.pdf]http://www.rockndj.com/TravelAuthorization.pdf[/url]
2007-04-03 14:06:47
#3
Ok I checked it works now.
So on Day 1 calculating DOWN starting at M&IE Per Diem + Lodging + transportaiton + Rental Car + Personal Auto Miles (this is the tricky one) + Other* = Total Expenses
So on Day 1 calculating DOWN starting at M&IE Per Diem + Lodging + transportaiton + Rental Car + Personal Auto Miles (this is the tricky one) + Other* = Total Expenses
2007-04-03 17:48:26
#4
Hi dj,
I checked Column 1 and the only problem I saw was the Total column format was set to "Special" so it was throwing an exception "The value entered does not match the format of the field "TotalExpenses.1"
I changed it to "number" format and it all worked for me. The miles entered in "Personal Auto miles" are the actual miles, but the amount in the total field adds it as a multiple of 0.485.
You should avoid using characters like "&" in naming fields, and using the dot notation for fields can also cause problems (.1, .2 etc).I did not see the original error you wrote about ( 3 becomes a 30) here on my system.
Hope that helps,
Dimitri
WindJack Solutions
[url=http://www.windjack.com]www.windjack.com[/url]
I checked Column 1 and the only problem I saw was the Total column format was set to "Special" so it was throwing an exception "The value entered does not match the format of the field "TotalExpenses.1"
I changed it to "number" format and it all worked for me. The miles entered in "Personal Auto miles" are the actual miles, but the amount in the total field adds it as a multiple of 0.485.
You should avoid using characters like "&" in naming fields, and using the dot notation for fields can also cause problems (.1, .2 etc).I did not see the original error you wrote about ( 3 becomes a 30) here on my system.
Hope that helps,
Dimitri
WindJack Solutions
[url=http://www.windjack.com]www.windjack.com[/url]
2007-04-04 06:30:34
#5
Thanks I'll check it again.
I'm sorry but your calculation got cut off so we can't see where the problem may be. Also you do not say if you are trying to do this in Acrobat or LiveCycle Designer. And, the link to your PDF is not working so no luck there either.
I'm not sure if writing the code again will help because there is a persistant problem with code getting cut off here- hopefully a fix is in the works, but you could try again to provide a working link to your PDF.
What you want to do is possible- you can have addition and mulitplication in your script- hard to say what the problem is though, due to the above issues.
Dimitri
WindJack Solutions
[url=http://www.windjack.com]www.windjack.com[/url]
Dimitri Munkirs
WindJack Solutions
pdfscripting.com