I have a 180x180 table of values in excel which I want DPlot to create a surface plot for. I've tried using the excel add-in call for a ZGrid and a ZScatterTable but both kick back the same VBA error. The error is in excel and the DPlot window stays empty.
Run-time error '9':
Subscript out of range
I've gotten the ZGrid call to work by cutting my table down to 100x100, but if I change any of the x or y axis values I get the same Run-time error.
I'm using excel 2007 in XP x64. DPlot version 2.2.7.7
I've tried searching the forum for the run-time error but I couldn't find anything. Any help with this problem would be appreciated.
I tried an example with a 180x180 grid just now, and it worked fine for me. Looking at the ZGrid code I don't see anything that is data-specific that would cause a problem, but I've been wrong before. At your convenience please send me your spreadsheet.
There's a goof in the ZGrid and ZScatterTable functions in the new Add-In that results in an unhelpful "Runtime Error 9" if either X or Y are not evenly-spaced. I'll be making a full update later tonight, but there's no reason for you to wait.
Ryan: By the way mail sent to your reply-to address was rejected. I'm not sure if that's a goofy setup for your mail or a whitelist-thing. In any case, my reply to the second part of your mail was:
On your other problem, it sounds like you're running multiple accounts on
the same system - yes? If so you can get around this problem by copying
%APPDATA%\DPlot\dplot.ini to %ALLUSERSPROFILE%\DPlot
