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.
Excel_to_JMP_error_example.xlsx