Excel Addin Returning #Value on Windows 11 for ARM

[jamesdlow]

I'm trying to use the addin on Windows 11 for ARM. Overall the Addin UI works flawlessly. Unfortunately once a formula has been created though, the addin returns #Value.

If formulas are turned off it does managed to return the formulas are turned off message, but maybe that is returned from the function and not written into the cells when data is actually returned?

[jamesdlow]

Here's the log from my recent requests

2021-11-29T04-00-54Z : Object reference not set to an instance of an object.
2021-11-29T04-00-54Z : [StackTrace, at Quandl.Excel.UDF.Functions.Helpers.Tools.GetBoolValue(Object referenceOrString)
at Quandl.Excel.UDF.Functions.UserDefinedFunctions.Timeseries.QSERIES(Object rawQuandlCodeColumns, Object rawDates, String rawCollapse, String rawOrder, String rawTransformation, Object rawLimit, String rawHeader, String rawDateColumn, String rawTranspose)] 0
2021-11-29T04-01-00Z : Object reference not set to an instance of an object.
2021-11-29T04-01-00Z : [StackTrace, at Quandl.Excel.UDF.Functions.Helpers.Tools.GetBoolValue(Object referenceOrString)
at Quandl.Excel.UDF.Functions.UserDefinedFunctions.Timeseries.QSERIES(Object rawQuandlCodeColumns, Object rawDates, String rawCollapse, String rawOrder, String rawTransformation, Object rawLimit, String rawHeader, String rawDateColumn, String rawTranspose)] 0

[couture-ql]

Hi @jamesdlow, we actually have a fix in the works and will be out in an upcoming release.

Once it's up, we'll appreciate any feedback to know if your use-case was resolved.

The particular issue I'm referring to is the plugin was not appropriately setting the cell's format based on the datatable you're interested in.

However, if you find for some data you're getting #Value can you please share the workbook with connect@data.nasdaq.com -- our support team will pass it along and we'll look into it further.

[jamesdlow]

Is that the 4.0.0 version? I'll try it straight away.

[jamesdlow]

Still experiencing the same issue.

[govert]

@jamesdlow Is this running on a M1 mac?
This discussion might relate: https://groups.google.com/g/exceldna/c/jCee3l0lzjM/m/3MId9svhAQAJ

[jamesdlow]

Yes, running Parallels Windows 11 and Windows Excel. I believe Windows x86 Excel still runs in compatibility mode if you have a Windows ARM device like a Surface, so it would be interesting to test if the behaviour still occurs there, but I don't have a device. Everything else about the plugin (UI) still works flawlessly, and I have other addons that are working on M1.

[govert]

I wonder if, following the linked discussion, you could experiment a bit with the signature of the function - trying a short one with few arguments, for example.

[jamesdlow]

A possible workaround might be to have an option on the Addin to enable returning arrays direct from the formula rather than writing into the cells of the spreadsheet. Office v16 now supports automatic spillover of array functions with both a 365 subscription on 2019 standalone purchase.

[jamesdlow]

It can be an option, so people that want the old behavior can keep it.