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

Editing a Form

nmara
Registered: Feb 4 2007
Posts: 102

When I create a form by importing an existing excel workbook, it only converts the open worksheet. Additionally, I have to edit in livecycle designer vs. Acrobat. Conversely, if I convert from Excel 2007, it brings back a multi-page PDf which I can run form fields recognition and use Acrobat to edit. I prefer editing in Acrobat, but is there a rule of thumb for what files can be edited in Acrobat vs. LiveCycle?
 
Secondly, if an Excel spreadsheet has an absolute reference in it, how do I replicate that functionality in a PDF? For example, the spreadsheet has data which is typed in a cell on the 3rd sheet, which populates cells on other sheets. Can this be done in PDF?
 
Thanks in advance,

My Product Information:
Acrobat Pro 8, Windows
thomp
Expert
Registered: Feb 15 2006
Posts: 4411
You best conversion, for office documents, is to always convert from the office tool where you can control the settings.

If you want to create an AcroForm then use the Acrobat Form tools on the Advanced Toolbar, don't use LiveCycle.

All form fields with the same name will have the same value. For LiveCycle forms the field's binding has to be set to "Global"

Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script

nmara
Registered: Feb 4 2007
Posts: 102
Thanks that helps a lot. I guess if you convert and open in
adobe then run field recognition it is an acro-form, however if you create the form through livecycle, it must be edited in livecycle.

thanks again