You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Traceback (most recent call last):
File "C:\Users\sinea\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\LocalCache\local-packages\Python310\site-packages\pycel\excelcompiler.py", line 851, in _evaluate_non_iterative
address = AddressRange.create(address)
File "C:\Users\sinea\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\LocalCache\local-packages\Python310\site-packages\pycel\excelutil.py", line 343, in create
addr_tuple, sheetname = range_boundaries(
File "C:\Users\sinea\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\LocalCache\local-packages\Python310\site-packages\pycel\excelutil.py", line 752, in range_boundaries
raise ValueError(f"{address} is not a valid coordinate or range")
ValueError: together is not a valid coordinate or range
It would be nice if this could be supported natively.
Possible workaround below, unless I have completely missed the point.
Also, the documentation for AddressCell and AddressRange is a bit weird in requiring to pass in a _Cell when it appears that what needs to be passed in is an ExcelCompiler, since _Cell has no attribute .excel.defined_names
As far as I can tell it is not possible to use "defined names" in the
set_value
andevaluate
methods.It would be nice if this could be supported natively.
Possible workaround below, unless I have completely missed the point.
Also, the documentation for AddressCell and AddressRange is a bit weird in requiring to pass in a
_Cell
when it appears that what needs to be passed in is an ExcelCompiler, since_Cell
has no attribute.excel.defined_names
The text was updated successfully, but these errors were encountered: