Formulas not evaluated when converting XLSX to PDF in .NET

GroupDocs.Conversion Product Family
,
1

It seems like there was a change in behavior, when it comes to evaluating Excel formulas on conversion to PDF.
With GroupDocs.Conversion 24.5, basic formulas like correctly evaluated on conversion.
But with version 24.6, this behavior changed and the result always seems to be 0.

Usually Excel evaluates formulas, but we used OpenXML toolkit, to fill values into cells directly, without doing any calculation.
You can use the attached XLSX file, which was already modified.
Excel Calculation stopped working.zip (11.5 KB)

No special conversion options were used, just var options = new ConvOpts.PdfConvertOptions().
Same behavior applies to GroupDocs.Viewer.

Was this an intentional change?

2

@Clemens_Pestuka
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CONVERSIONNET-7186

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

1 Like