Excel formula problem.

DanielLitfeldt — Fri, 13 Sep 2019 09:50:00 GMT

Hi,

I have a problem when posting a formula to excel. Getting an 0x800A03EC error in one case (when posting the original format after changing which cells I'm referring to) and #NAME? error when posting with "," instead of ";" that i tried because of divider problems. Even if i just read then post the formula without manipulate it i get the 0x8... error.

The formula in question: =INDEX(B2:B7;TYPVÄRDE(PASSA(B2:B7;B2:B7;0))) and it works if i post it manually to excel.

Running windows 10 with Swedish language and localization and Swedish excel.

I need to find a solution since i can't change anything but the language due to not knowing the impact of changing for instance format setting has for the applications I'm using in the automations.

Anyone has any tips regaring this?

------------------------------
Daniel Litfeldt
------------------------------

RE: Excel formula problem.

PratyushGarikap — Tue, 17 Sep 2019 09:50:00 GMT

Hi Daniel,

Not sure what's the root cause from the information provided, but I am listing a few leads to explore.

https://support.microsoft.com/en-us/help/320369/bug-old-format-or-invalid-type-library-error-when-automating-excel
Is this an Array formula (sorry, can't translate the functions)? If yes, then you will have to enter the formula using Ctrl+Shift+Enter send keys.
Explore if this functionality can be achieved within BP by reading the Excel data into a collection (or submit a support ticket with more details to investigate this)

------------------------------
Pratyush Garikapati
ROM Architect
Blue Prism
Asia/Kolkata
------------------------------

topic RE: Excel formula problem. in Product Forum

Excel formula problem.

RE: Excel formula problem.