Excel formula problem.

[DanielLitfeldt]

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
------------------------------

[PratyushGarikap]

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
------------------------------