Skip to content
This repository has been archived by the owner on Nov 8, 2022. It is now read-only.

RTA Sim "Unexpected behavior encountered" #32

Open
MrPichiquitab opened this issue Dec 11, 2019 · 0 comments
Open

RTA Sim "Unexpected behavior encountered" #32

MrPichiquitab opened this issue Dec 11, 2019 · 0 comments

Comments

@MrPichiquitab
Copy link

With Spreadsheet Interpreter set to RealTime Analytics, hitting Simulate produces an "Unexpected behavior encountered" error. Details below. I performed the work-around of changing Spreadsheet Interpreter to Native Excel, and the simulation will run. Now after saving the model and reopening, all the embedded Charts and Tables have VALUE errors. Not sure if the two are related. Going to check #4 Mysterious VALUE next. Also, while not (yet) running Office 365, I'm running into a similar issue to #30 where I have to reload Argo every time I open Excel. Ironically, the VALUE errors only seem to appear after I load Argo.

at Microsoft.Office.Interop.Excel._Application.get_Range(Object Cell1, Object Cell2)
at ArgoXllDev.ExcelAddressUtil.ParsePositionInfo(String arg, IntPtr defaultsheetid, Int32& r1, Int32& r2, Int32& c1, Int32& c2, String& workbook, String& worksheet)
at ArgoXllDev.PrecedentMiner.BuildPrecedentChain()
at ArgoXllDev.RegisterUDFLib.Argo_BuildPrecedents()

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant