Formulas do not work in xlsx reports

[NikitaShchienko]

Environment

• Platform version: 7.0.6

Description of the bug or enhancement

In the xlsx format report, not all formulas from the template are displayed and are not calculated.
Link to the forum: https://www.cuba-platform.ru/discuss/t/itogovye-summy-v-otchetah-excel/3149

Minimal reproducible example

1. Import sample report (test.zip)
2. Run report
3. Open report

Expected behavior: In the formula cells, the result must be calculated.

Actual behavior: The report does not display formulas.
Template file:

Final report:

[gladyshev-dv]

Hello!
Doesn't fixed yet?

[gorbunkov]

Probably this issue in YARG is linked to the current one

[Desire456]

That occurs because the template is created using Microsoft Office. There is a shared formula that was created in MS Office and not supported by LibreOffice. You can create a template using LibreOffice or don't use shared formulas in MS Office. When you create the template using LibreOffice all works correctly. The correct workflow for this case is creating templates in LibreOffice and reading reports from everywhere or creating templates in Microsoft Office and not using shared formulas.

[Gavrilov-Ivan]

Added new property to force formulas evaluation - reporting.formulasPostProcessingEvaluationEnabled.
True by default.

[Gavrilov-Ivan]

Updated: default value is 'false'.