Tiny Traps in Jmp and JSL

[#1]

In Jmp and JSL there are some tiny traps which can be annoying.

One remedy is to know where such traps are hidden - so, let's create a map!
- and stay away from the dangerous corners.

this post focuses on tiny issues. Many of them are "higher order" - meaning they only show up when several features are combined.
NB: There is a related community post with the "big" pitfalls:
Caution: Places where Jmp does something unexpected 

[More Topic Containers like this]

Topic:	additional info
Graph Builder and Reports
Graph Builder + multiple response + multiple histograms	TS-00034150 actually, not just an issue with histograms ...
unfortunately, it's not possible to create plots with consistent size of the plot area	Graph builder Frame size JSL TS-00076249
In Jmp it is not "as easy as" in Excel to overlay plots with different X/Y axes /from different data tables	workaround
Data Tables
Optimize Sharepoint Integration
current data table() << subset(1,Private(0)); opens the subset table in Private mode - despite the Private(0)	TS-00127556 Private yes/no?
Find - or not find?  did you know that Ctrl + F doesn't work in almost 50% of the cases?	TS-00078231
to import csv files with point and comma as decimal separator, one has to change the Jmp Preferences (!)	Make decimal separator an option
formula column with contains doesn't get updated Differentiate between entire column and current row	TS-00053745 what's the reason behind this issue?
When a column data type is changed, e.g. from character to numeric, non matching entries get lost	Retain data when column data type is changed
Text to Columns differs from Text to Columns in MS Excel: groups of separators are treated as a single one -> empty data leads to shifted data (!)	Text To Columns: handle missing data correctly [actually, the Jmp version is also very useful!]
One cannot move a column to the top of a column group: 2 (tiny) issues with grouped columns	TS-00035674
JMP jumps... after copy column/ paste column	TS-00127922
bug when importing csv files with DMY date format	CSV import force MDY or DMY date format
Data Filters
A Data Filter gets reset if there is no row in the current data table which matches the filter setting. "show me the outliers" gets "show me all the data points"  Outlier (👽) screening with Jmp Dashboards - how? Can-animation-of-this-difficulty-be-achieved-with-JSL	TS-00046650 Local Data Filter: option: restrict or do not restrict to current data 🙏 Column Property: Inclusive Values
Graph Builder + Local Data filter + Multiple Response:adjust the axes to the filtered data	TS-00044559
Jmp doesn't wait till a data table is fully processed when executing subsequent JSL code. -> add wait() (?) or dt << run formulas()	Why is there an empty table if you don't add wait（）? run table script
Platforms
Some of the Platforms of the Tables menu produce their output by ignoring hidden &  excluded rowstates (!!!) exception: Tables/summary	Handling Hidden / Excluded rows / columns in Table-handling
Tables/Update: speed issue	TS-00053519
JSL
JMP Expr() weirdness, can anyone explain?  inserting an expression into the same kind of expression flattens the expression	TS-00076135
When column names are changed, table scripts get updated automatically (so cool!!!) - but other scri...	catch "missing column" error and provide a selection menu
please note: By default, the first >full<  Week of Year(...)  is #2 - and in 2023, the last one was #54. --> use	Calculating-WEEKOFYEAR-for-weeks-that-start-on-a-day-other-than/m-p/714426/highlight/true#M89773
Informat("day.month.year") assumes Informat("month.day.year") for day ≤ 13 (!)	The Doctor Cures  Your Date and Time Import Problems use Format Pattern option!
Application Builder
Table reference is removed from an application if the data table is closed.	application builder: dangerous if data table is closed
Jmp in general
Do you use the preferences?  ... it can lead to unpredicted results	TS-00043014
MS Teams and Sharepoint prevent interactive HTML pages from executing the scripts.	Interactive HTML - catch problems
PickFile(), Projects and Network Drives  -> slow!	TS-00128387

old traps which got fixed in the meantime:

 JMP - New Features and Release Notes 

Graph Builder	fixed in Jmp
How to show the actual range in the level values in Graph Builder?	v17.2
How to apply changed properties to the Report?	v18
Graph Builder: reverse scale	v18
Local Data filter + Animation - how to specify the range?	v18
Heatmap: color for Missing Values?	v18
Tables
Multi File import: add a fast mode	v18
get rows where: speed issue	v18
reference gets lost even if  data table doesn't get closed TS-00076052	v18
Data Filters
A data filter ignores all changes of the data table if "conditional" is used TS-00049919	v17.2
A data filter doesn't get updated when the column name or data type is changed TS-00053718	v18
Tabulate
Color setting for highlighted text in Tabulate	v17

[#2]

Actually, I think a community post is not the right place to do this, but it's a place to start.
If we keep it slim: just links to other community posts, I will try to add such links to the list on top.

Maybe we need something more professional than a community post with links?

- option to discuss individual topics (for now, please do this in the linked post)

- option to sort and restrict the list (e.g. select just Table issues > Jmp v17.1)
- possibility for more / (all ?) user to edit the list

[#3]

I think it is still good to have someone summarize/recap the discussion (that's how I learn of certain things that may not be an interest now but can be useful for future projects).

So I have to thank your effort here.

[#4]

Great work, Holger @hogi