Interactive pdf?

[Brian_Dawley@adobeforums.com]

Using an Excel spreadsheet, a program has been created to determine the high and low cost of an item. Is there a way to turn this spreadsheet into a pdf without losing the built-in functionality? Will the user still be able to enter the number of items desired and get the cost returned to them?

I am using XP and Distiller 5.0.

[Fr._Watson@adobeforums.com]

Using an Excel spreadsheet, a program has been created to determine the
high and low cost of an item.




How does it do this?

Is there a way to turn this spreadsheet into a pdf without losing the
built-in functionality?




Maybe; it depends partially on the answer to my first question. It likely would not be easy from the sounds of it.

Will the user still be able to enter the number of items desired and get
the cost returned to them?




Once the cost had been determined, I think that this would be possible. (Others with more expertise would have to help you with this.)

[Brian_Dawley@adobeforums.com]

Formulas are included to determine the high and low cost. The user enters the number of items, and then the cost is displayed for that item based on the respective formula. The spreadsheet has 4 columns - item name, number of items, low cost, high cost. Item name is static - the other columns need to be dynamic based on the user entry.

[Gerry_Heinemann@adobeforums.com]

Just going from Excel to PDF does not translate VB or macro code.
You will need to add Javascript code to do this in the PDF file.
Gerry

[Fr._Watson@adobeforums.com]

You will need to add Javascript code to do this in the PDF file.




(Which is where it will likely become difficult & definitely beyond my capability to help with.)