• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

HOW TO CONVERT EXCEL SHEETS TO PDF KEEPING THE CALCULATIONS?

Community Beginner ,
Jul 06, 2021 Jul 06, 2021

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

TOPICS
PDF forms

Views

504

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jul 06, 2021 Jul 06, 2021

Copy link to clipboard

Copied

Convert the file into PDF and add the calculations in Adobe Acrobat.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jul 06, 2021 Jul 06, 2021

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Jul 06, 2021 Jul 06, 2021

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jul 06, 2021 Jul 06, 2021

Copy link to clipboard

Copied

LATEST

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.

 

 

 

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines