simplexls icon indicating copy to clipboard operation
simplexls copied to clipboard

Not working with named ranges

Open amd-123 opened this issue 1 year ago • 0 comments

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.

amd-123 avatar Sep 12 '24 15:09 amd-123