and there are some special values, like #DIV/0! , #REF! , #NAME? , #VALUE! , #N/A
currently luart seems not able to handle them.
simple test.lua:
app = sys.COM('Excel.Application')
app.Visible = true
book=app.Workbooks:add()
cell = app.ActiveCell
print(cell:Address())
cell.value2 = '=1/0'
print(cell.text) -- #DIV/0!
print(cell.value2) -- COM error : unsupported result type 10, crash
print(type(cell.value2)) -- COM error : unsupported result type 10, crash
print(cell:value()) -- COM error : unsupported result type 10, crash
print'ok' -- never
book:close(false)
app:quit()
app=nil
collectgarbage()
in VBA, Debug.Print ActiveCell.Value2
get text like : Error 2007, Error 2042, ...
in luacom, get nil
in powershell or python, get number like -2146826246 ...
maybe this is the same minus number problem?
