Hi team,

I am trying to insert an Excel formula within an each loop in JSReport.

For example, in cell A2, I have the formula:

=B2 + C2

After rendering the report, I expect the following:

Cell A3 should contain =B3 + C3

Cell A4 should contain =B4 + C4

And so on…

However, this is not what I’m seeing. Instead, all cells contain the same formula referencing the last item in the list. For example, if my list contains 100 elements, all cells show:

=B100 + C100

Could you help me understand why the formula does not increment automatically in the each loop and suggest a solution?

I am using JsReport v4.10.1

Thank you!!

[1_1762265512054_template.xlsx](Uploading 100%)
[0_1762265512052_result.xlsx](Uploading 100%)

Thank you for your reply,

But I still get the same error:

Hi, I'm trying to create a simple formula in an Excel spreadsheet, which is: {{#each Liquidity}}
{{#if (eq TypeCode ‘AC’)}}
OK
{{/if}}
{{/each}}
It works in a Word document, but Excel does not support ‘equal’. Does anyone have a solution?

Thanks in advance.

Version : 4.7.0