boozallen / argo

Other
46 stars 19 forks source link

Can't display graphs #15

Closed Chacsam closed 7 years ago

Chacsam commented 7 years ago

When looking at OAT effects, following error:

[Excel 16x86;CLR 4.0.30319.42000] System.Runtime.InteropServices.COMException: Exception de HRESULT : 0x800A03EC

à Microsoft.Office.Interop.Excel._Worksheet.get_Range(Object Cell1, Object Cell2) à ArgoXllDev.OatSensitivityAnalysis.createReport(List`1 outputs, Double basecase) à ArgoXllDev.OatSensitivityAnalysis.RunOFATSensitivitySimulation() à ArgoXllDev.OatForm.btnOK_Click(Object sender, EventArgs e)

todd-skinner commented 7 years ago

Hi, thanks for reporting your issue. I'm unable to replicate this error when generating OAT charts. Do you have a file you can share? Or can you give me a few more details about the steps you took which produced this error?

Chacsam commented 7 years ago

Hi

Thanks for coming back to me. Hereby a very simple example file of the error. Hope it helps

PS: I have tried on 2 different PC's with different office accounts and got same issue PS2: We use comma's as decimal separator

test-argo.xlsx

todd-skinner commented 7 years ago

Thanks for sending your file. However, I still didn't get your error on my computer. I assume from the error message that you are using a non-English version of Excel? Our development team has never tested Argo on a non-English Excel installation. Unfortunately, we don't think Argo is compatible with other languages. I also think that the comma decimal separators are probably responsible for this particular error because they will affect how Argo parses Excel formulas. We may expand Argo's languages compatibility in the future but for now Argo is not compatible with non-English installations of Excel.

Chacsam commented 7 years ago

Thanks for feedback. My Excel is in English, but the locale is European (BE), thereby the comma separator. Unless it adds any value to you, I won't reconfigure my Windows to US to see if that works, we'll assume that's the reason. Thanks for the nice app anyway, take care