Formula in Cell with f is not working

protobi / js-xlsx

XLSX / XLSM / XLSB (Excel 2007+ Spreadsheet) / ODS parser and writer

http://oss.sheetjs.com/js-xlsx

Other

817 stars 417 forks source link

Formula in Cell with f is not working #75

Open Yugam18 opened 7 years ago

Yugam18 commented 7 years ago

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 commented 6 years ago

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 commented 6 years ago

@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 https://github.com/protobi/js-xlsx/pull/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 commented 11 months ago

@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)