simplexls
simplexls copied to clipboard
Not working with named ranges
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.