Not working with named ranges #35
Description
I’ve noticed that when using named ranges in formulas, the simplexls does not recognise them.
e.g. if this is in the spreadsheet
=IF(named_range_1="No","Some Value No","Some Value Yes")
It will just show up as an empty string using the class
Is this a known issue and is there any intention of supporting named ranges in formula evaluations in the future?
If there’s a workaround or fix that could be implemented in the meantime, any guidance would be appreciated.
Note: PHP-XLS-Excel-Parser is an example of a small enough project which works with named ranges, however it's old and unsupported so I'm not keen to use it.