Formula in Cell with f is not working

[Yugam18]

Hi,
Formula are not working in this package it seems.

How do i apply that?

There is a fix present in the pull request
FIX cell formulas not working for writing Workbookby Ahmed--Mohsen
I updated the code in my local and it worked.
Can you please merge the code into the main branch.

Your response would be appreciated.

[djm418]

Any information on this? I can't do styling with js-xlsx and i can't do formula's with xlsx-style... kind of stuck between a rock and a hard place.

[pietersv]

@djm418 I think the commercial branch has both styles and formulas. Alternatively, as the library is open source it may be possible to

• fork the repo
• look at Fix formula support in Xlsx style #76
• make the equivalent changes to the /bits/*.js directory
• ideally add a unit test to the suite; verify it fails before making the change and succeeds after

From there you can deploy from your GitHub repo, npm install github:dgj418/js-xlsx.git.

[JonathanDn]

@pietersv Is it possible to add the small fix to support formulas in this package? (So people using this lib can enjoy styling + exporting a formula which is currently not supported)