Date: 04/19/05 (Web Development)    Keywords: java

I have a PDF form that I converted from a MS_Word document. In this document is a table that calculates GPA based on the number of course units and the converted number grade that the user inputs. It multiplies those two columns and produces a number. I figured that it was pretty simple to do in Excel so I redid the form in Excel utilizing the formula feature, but when I converted that to a PDF, the formulae weren't accessible when I tried to make it into a fillable form in Designer.

I think my issue is that Designer makes a copy of my original document so that I end up with a new PDF form that's fillable and looks like my Excel spreadsheet, but it is NOT my original form, you know, the one that can actually calculate the GPA based on what numbers are entered.

I am aware of the FormCalc/ JavaScript feature in Designer. I still don't know how to use it very well after two days of going through the help menu. I thought would be similar to Excel formulae function. Instead it's super-time consuming, but I hope that is only because I am a n00b at it.

So far in FormCalc I can enter the formula in a cell in the total column to calculate ONE row of data but when I enter a formula into the row beneath I keep getting TextField7[] validation errors (because there are more than two columns that use TextField7[]).

Is there any way that I select a bunch of cells at once and have it autocopy the original formula into the cell below in an intelligent way (like Excel does) so I don't have to sit there and type in
multiply column A1 by B1
multiply column A2 by B2
.
.
.
multiple times in the FormCalc window (once for each cell in the total column)?

I just want the form to automatically calculate the data entered into two different columns to display the caculation in a third totals column. I then want to use a different formula to calculate the GPA from this total columns. Any help would be appreciated.

Source: http://www.livejournal.com/community/webdev/190419.html