Formular not evaluated on certain XLSM when converting to PDF in .NET

GroupDocs.Conversion Product Family
,
1

When converting the attached XLSM file to PDF, two formulas are not evaluated:
image.png (39.7 KB)

Formula not evaluated.zip (61.2 KB)

I tried to convert the same document with GroupDocs Viewer and there everything works fine.
I tested with version 22.9 (and additionally 22.10 for Conversion)
No special conversion options are needed to reproduce the issue.

1 Like
2

@Clemens

This issue is under investigation. Your investigation ticket ID is CONVERSIONNET-5602 .

1 Like
3

@Clemens

You have to update to v23.9 or v23.10 (which will be released by the end of October 2023).
Also, you need to set a CultureInfo either application-wide or only for the executing conversion (see the snippets).
The reason is that the currency symbol “RM” is available only for locale “ms-MY”. If the region is not ms-MY, even in Microsoft Excel, when you re-calculate the cell it also gives “#VALUE!”.

Application-wide culture set during application initialization:

CultureInfo.CurrentCulture = new CultureInfo("ms-MY");

Executing conversion only

const string source = "Formula not evaluated.xlsm";

using (var converter = new Converter(source, () => new SpreadsheetLoadOptions
       {
           CultureInfo = new CultureInfo("ms-MY")
       }))
{
    var options = new PdfConvertOptions();
    converter.Convert("converted.pdf", options);
}
1 Like
4

The issues you have found earlier (filed as CONVERSIONNET-5602) have been fixed in this update. This message was posted using Bugs notification tool by nikola.yankov