Jetformat

Recalculate cached Excel formula values

Use jetformat excel recalc to recalculate cached Excel formula values.

By Jetformat

Workbooks written by libraries may lack formula caches, leaving formula cells blank during conversion. Recalculate before exporting to PDF.

Steps

  1. Start with a local XLSX. Replace the sample paths and identifiers with your own.
  2. Run the command below. Save to a new output path so the source remains available for comparison.
  3. Check the result as described below before using it in another job.
jetformat excel recalc finance.xlsx -o finance-updated.xlsx

Options for this task

Option Meaning
--output Output XLSX path (required)

Check the result

Read key formula cells with excel get and compare important totals with known expected values; unsupported formulas need separate review.

Notes and limits

Writing an Office document uses one credit per command. See the billing guide for the current rules.

The examples keep the original file. Add --force only when you intend to overwrite an existing output. Run jetformat excel recalc --help to compare options with your installed version.

See the excel command reference for the surrounding workflow.

Last updated