cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
Choose Language Hide Translation Bar
0 Kudos

Fix the Data Table Excel Add-in button to work properly when there are spilled ranges.

What inspired this wish list request? 

Spilled ranges are used extensively by any serious Excel user.  Numerous times when I've wanted to pull in data from Excel to JMP (which is something JMP should want to encourage as much as possible) for a quick analysis I find that the import did not work because JMP isn't recognizing the true used range and stops importing after the last column and last row that is NOT a spilled result.

 

What is the improvement you would like to see? 

I would like this to work as intended.

 

Why is this idea important? 

This error in JMP requires a small but non-zero workaround that discourages me using JMP at a single click.

Example file created to demonstrate both the problem and the workaround.