Excel's WorksheetFunction.IsError stopped working when Excel is automated by C#
As of some time this week or last,
Application.WorksheetFunction.IsError no longer works.
All cell errors return false.
e.g. app.WorksheetFunction.IsError(cell.value) is false when the cell formula is =1/0
Also, I am getting: Exception from HRESULT: 0x800A03EC when using get_Range method in non-US locales
Worksheet.get_Range("F7,F8,F9,F10,F11,F12,F13") works fine when using US locale.
When I switch to es-es locale, the 0x800A03EC error is thrown
This stopped working about a month ago.
Neither of these issues happen when using VBA
Microsoft® Excel® for Microsoft 365 MSO (Version 2204 Build 16.0.15128.20278) 64-bit