10 Replies Latest reply on Oct 23, 2008 1:40 PM by George_Johnson

    Scripting help

      I am trying to import an excel spreadsheet and need the scripting for calculations. Adobe will not take the formulas from excel and import them.

      Does anyone know how to do this?

      Thank you,
      Connie Dougherty
        • 1. Re: Scripting help
          Patrick Leckey Level 3
          Acrobat does not use the same scripting / calculation language as Excel. You would need to re-write your calculations in Acrobat using JavaScript or FormCalc (depending on how you're importing the form). There is no automated process for this.
          • 2. Re: Scripting help
            Level 1
            so is there any information on how to do this? or is there someone that can do this for me?

            Thank you,
            Connie
            • 3. Re: Scripting help
              Patrick Leckey Level 3
              If you want someone to do it for you, this probably isn't the best place to ask. You'd want to look at hiring a consultant, say from Adobe Consulting.

              If you're looking to do this yourself, let's start with a few questions:

              1) Are you using Acrobat or Adobe LiveCycle Designer to design the form?
              2) Do you have any experience with JavaScript or FormCalc?

              One thing you will want to understand is that Acrobat is not Excel. It has not been designed as a spreadsheet application and may not have all the functionality you require, depending on what you need to do with your form.
              • 4. Re: Scripting help
                Level 1
                I am using Acrobat Pro 9
                no i have never used either javascript or form calc.
                • 5. Re: Scripting help
                  Patrick Leckey Level 3
                  What do you require your form to do? What is the complexity? Do you have a sample anywhere?
                  • 6. Re: Scripting help
                    Level 1
                    I designed a expense report so employee can enter their names, department, and then i have 4 columns they would enter $$ in and at the bottom it would add it up. i also have 2 boxes for travel expenses, like airfare, car rental, gas ect. that would total everything in each box and then enter it in the columns where it says box A and box B. then at the bottom i have grand totals for each column.
                    • 7. Re: Scripting help
                      Patrick Leckey Level 3
                      In this case I would suggest you use Adobe LiveCycle Designer (it gets installed with Acrobat 9 Pro, so you already have it).

                      Go to this page and have a look at the samples:
                      http://www.adobe.com/devnet/livecycle/designer_scripting_samples.html#formfield

                      Specifically the "Processing all fields on a form" example. It will be a good start for what you need to do.

                      You should also read this article:
                      http://www.adobe.com/devnet/livecycle/articles/lc_designer_scripting_basics.html
                      • 8. Re: Scripting help
                        Level 1
                        is this easier to use? i am not a programmer.
                        • 9. Re: Scripting help
                          Patrick Leckey Level 3
                          > is this easier to use?

                          Depends on your point of view. Your biggest learning curve is going to be getting comfortable with JavaScript. Which application you do that in is really six of one, half a dozen of the other.
                          • 10. Re: Scripting help
                            George_Johnson MVP & Adobe Community Professional
                            Since you have not done this before, I'd suggest not using Designer and using Acrobat instead to create the form fields. Designer is far more complicated and has a significantly steeper learning curve. There are options in Acrobat for summing fields that do not require custom scripts.

                            George