Formula with "equal" and "if" in Excel

[enoranowak-beep]

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

[admin]

Handlebars doesn't have an eq helper, but you may easily add it.

[enoranowak-beep]

Thank you for your reply,

But I still get the same error:

[admin]

I see. Would you please share a minimal playground demo replicating the issue?
https://playground.jsreport.net/

[bjrmatos]

hi @enoranowak-beep

using the {{#if }} in this way does not work in xlsx, in Docx it works because the definition of the content there is different from how cells definitions are done. you can use the {{#if }} in xlsx only if the start end end of the block calls are in the same cell.

however this would be nice to support, i have opened new issue to support it, you can subscribe there for updates