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,
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