cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP Wish List

We want to hear your ideas for improving JMP software.

  1. Search: Please search for an existing idea first before submitting a new idea.
  2. Submit: Post your new idea using the Suggest an Idea button. Please submit one actionable idea per post rather than a single post with multiple ideas.
  3. Kudo & Comment Kudo ideas you like, and comment to add to an idea.
  4. Subscribe: Follow the status of ideas you like. Refer to status definitions to understand where an idea is in its lifecycle. (You are automatically subscribed to ideas you've submitted or commented on.)

We consider several factors when looking for what ideas to add to JMP. This includes what will have the greatest benefit to our customers based on scope, needs and current resources. Product ideas help us decide what features to work on next. Additionally, we often look to ideas for inspiration on how to add value to developments already in our pipeline or enhancements to new or existing features.

Choose Language Hide Translation Bar
0 Kudos

Importing filtered rows from excel

Status: New Submitted by on ‎04-25-2024 02:50 AM
Comment

What inspired this wish list request? 

I am working with multiple import of excel sheets from various users and some are applying filters to have the required informations. However I want to import all data of the files in an automated way.

 

 

What is the improvement you would like to see? 

It happens that hidden and filtered rows are handled differently in excel and JMP 18. It would be good to have a "<<Set Excel Suppress Filtered Rows( 0 )," so all excels don't need to be checked to be sure no filters are applied before running the automation. 

 

 

Why is this idea important? 

This is important in the aim of automatization of data from team or group when not all people have JMP and use filtered specific excel files. If you want to recover all data from these files and not only the prefered ones of each usersto avoid bias in your data analysis