spout icon indicating copy to clipboard operation
spout copied to clipboard

Write formulas to XLSX files.

Open stevesweets opened this issue 7 years ago • 6 comments

Ref this issue: https://github.com/box/spout/issues/424

I utterly understand that reading formulas is a pain. It should be noted that writing formulas to ODS is rather a pain, too, but the nature of xlsx actually makes it rather easy to write them.

This way, we can use the super-performant spout when we want to generate an xlsx file that needs to contain some excel formulas, and I don't think this lands outside of the goals of Spout.

I await your judgement!

stevesweets avatar May 25 '17 10:05 stevesweets

Verified that @stevesweets has signed the CLA. Thanks for the pull request!

boxcla avatar May 25 '17 10:05 boxcla

This works for this, too:

https://github.com/box/spout/pull/352

stevesweets avatar May 25 '17 10:05 stevesweets

Thanks @stevesweets ! Most likely, this won't be merged until v3 is released. v3 should make it easier to work with formulas. But I'll keep the PR open, as a reference for future implementation.

adrilo avatar May 29 '17 20:05 adrilo

CLA assistant check
Thank you for your submission! We really appreciate it. Like many open source projects, we ask that you sign our Contributor License Agreement before we can accept your contribution.
You have signed the CLA already but the status is still pending? Let us recheck it.

CLAassistant avatar Mar 03 '20 19:03 CLAassistant

Will this PR ever get merged?

StefanoGroenland avatar Jun 17 '21 06:06 StefanoGroenland

Merged a variation in https://github.com/openspout/openspout/pull/5

Slamdunk avatar Mar 02 '22 09:03 Slamdunk