Copy link to clipboard
Copied
Helo Community, can any body please help me? in How to convert Excel Spreadsheets to PDF keeping the calculations?
Thanks.
7/6/2021
Copy link to clipboard
Copied
Convert the file into PDF and add the calculations in Adobe Acrobat.
Copy link to clipboard
Copied
Calculations done in Microsoft Excel will be lost when converting the spreadsheet file to a PDF file.
The Microsoft Office family use Macro functions , such as some of your formulas in MS Excel.
These macros are developed with Visual Basic for Applications (VBA), a computer programmming language owned and developed by Micrososft, which also has become the standard accross all MS Office programs.
Even though you can implement JavaScript for MS Office using some very complicated frameworks, the same is not true with VBA; it is exclusive to MS Office.
In the same context, Acrobat JavaScript is exclusive to the Adobe Acrobat program; as indicated by Bernd Alheit, you must manually develop the script(s) that would calculate in the same way as the macros used in your spreadsheet but using Acrobat JavaScript.
Copy link to clipboard
Copied
Thank both of you very much.
Its kind of complicated. So, there's nothing that I can do about it!
Thanks a lot, agian for your help.
RAMFTKEY
Copy link to clipboard
Copied
If you're ok posting your formulas we may be able to assist you with the Acrobat JavaScript scripting part, but if this is a complicated spreadsheet I'd suggest you are better off outsourcing a developer that can do that for you for reasonable fee.