'JS linways/table-to-excel how to add formulas

So I'am building excel files with @linways\table-to-excel (https://www.npmjs.com/package/@linways/table-to-excel)

But when I try to insert a simple formula the file with cell like this:

Wrongly rendered cell

However, when I click formula field and press enter, then it recalculates and shows valid value.

Valid cell

My excel is configured to have automatic calculation.

Is there any way fix it somehow? Or else, is there a way to add some kind of newline symbol to use in this library?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source