Read cached, evaluated formula values?

jsonkenl / xlsxir

Xlsx parser for the Elixir language.

MIT License

212 stars 83 forks source link

Closed junjizhi closed 5 years ago

junjizhi commented 5 years ago

Currently xlsxir reads out the formula string directly. Is there a way to read the evaluated value that MS Excel cached in the file?

I know openpyxl has a data_only flag that does that. Is it in your plan to support this feature?

Thanks!

junjizhi commented 5 years ago

Actually I found that's the default behaviour. The formula I saw before could be MS Excel didn't actually cache value.