Excel Addin Returning #Value on Windows 11 for ARM about quandl-excel-windows HOT 9 OPEN

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

from quandl-excel-windows.

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 [email protected] -- our support team will pass it along and we'll look into it further.

from quandl-excel-windows.

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

from quandl-excel-windows.

Still experiencing the same issue.

from quandl-excel-windows.

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

from quandl-excel-windows.

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.

from quandl-excel-windows.

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.

from quandl-excel-windows.

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.

from quandl-excel-windows.

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

from quandl-excel-windows.