search

caxlsx / caxlsx_rails

A Rails plugin to provide templates for the axlsx gem
MIT License
744 stars 84 forks source link

Question: Get formula value #157

Closed newfylox closed 2 years ago

newfylox commented 2 years ago

Hi guys, quick question,

is there a way to get formula cell's value? If my cell is =SUM(A1:B1), can I call this cell and get its real value and not the formula string?

Thanks

straydogstudio commented 2 years ago

@newfylox You'll want to post that on the Slack channel (preferably), or put it as an issue on the Caxlsx gem.

See the README here: https://github.com/caxlsx/caxlsx