These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Creating form from Excel Spreadsheet with embedded calculations

Forum Index > Forms: Acrobat > Creating form from Excel Spreadsheet with embedded calculations
2011-02-14 20:04:20
emrinell
Registered: Feb 14 2011
Posts: 2

When I convert a Excel Spreadsheet into a PDF form, it doesn't bring over the calculations that are in the spreadsheet. Am I missing something somewhere?

My Product Information:
Acrobat Pro 9.0, Windows
Top
2011-02-14 23:28:03
#1
George_Johnson
Expert
Registered: Jul 6 2008
Posts: 1876
I suppose it would be nice if there were some way to automatically translate the Excel formulas to JavaScript in Acrobat, but it seems like that would be rather complex. In other words, Acrobat doesn't do that.

Acrobat does support JavaScript, which is a nice general purpose programming language, so you could duplicate the calculations if needed.
Top
2011-02-15 06:04:05
#2
emrinell
Registered: Feb 14 2011
Posts: 2
So I have to manually put it the calculation in javascript in order for it to work? I'm not familiar with javascript programming, is there somewhere I can find the proper syntax. And is there also a way to copy to multiple boxes like Excel does, or do I have to manually do each one?
Top
2011-02-15 07:24:24
#3
George_Johnson
Expert
Registered: Jul 6 2008
Posts: 1876
There are a number of tutorials here that talk about calculations and other aspects of using JavaScript in PDF forms.

The Acrobat JavaScript reference is available here: http://livedocs.adobe.com/acrobat_sdk/9.1/Acrobat9_1_HTMLHelp/wwhelp/wwhimpl/js/html/wwhelp.htm?href=JavaScript_SectionPage.70.1.php&accessible=trueYou can create a an array of fields quickly by manually creating the first one and then right-click it and select: Place Multiple Fields...
Top