search

quandl / quandl-excel-windows

Quandl Excel Addin for Windows
https://www.quandl.com/tools/excel
13 stars 11 forks source link

Excel Addin Returning #Value on Windows 11 for ARM #40

Open jamesdlow opened 2 years ago

jamesdlow commented 2 years ago

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 commented 2 years ago

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 commented 2 years ago

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 commented 2 years ago

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

jamesdlow commented 2 years ago

Still experiencing the same issue.

govert commented 2 years ago

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

jamesdlow commented 2 years ago

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 commented 2 years ago

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 commented 2 years ago

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 commented 2 years ago

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