I am using a vba script to import a matrix from Matlab into Exel. The Matrix has NaN values in it, which previously (in Matlab2016b) have been imported as NaN into Excel. Now I switched to Matlab2019a and that same VBA code gives me a matrix in Excel where Matlab NaN values are replaced with a specific number 65535.
I've tried different spreadsheets, variables, rewrote the VBA code, etc. NaN is now always replaced with 65535 when using MLGetMatrix. How can I get it back to being imported into Excel as NaN?
Here is my sample VBA script:
Dim Err As String
Err = MLEvalString("some_code")
Application.Calculation = xlManual
MLGetMatrix "A", "some_existing_rangel"
Application.Calculation = xlAutomatic