Caution: Places where Jmp does something unexpected

[#1]

Definitely, JMP is Not a Spreadsheet . And that's great!!

Besides this difference, there are more places where Jmp doesn't do/behave/produce what a newbie / innocent Jmp user expects.

If a user knows these topics and the remedies and workarounds -  he/she
a) can save a lot of time

b) is safe against loss of data

c) can be sure that the results are as expected.

[More Topic Containers like this]

Topic	description	Links
Data Tables
Formula column + excluded rows	Unlike plots and reports, column formulas  don't use the information about  excluded rows. Workaround:  col mean(:height, excluded())	Formula Editor: meaningful results with excluded rows Compute Column Mean ...Col Max() ... excluded row Col Functions and Row States  Exclude data in formula
Source Scripts + Tables/Update	Tables/Update overwrites an existing Source script same issue for Concatenate + Append to first table	Update & Concatenate:source script collision workaround, @internal: use our bug-fixed Update platform it archives the source script before overwriting it
international: issues with dates	JMP prefers M.D.Y  this can lead to issues with D.M.Y	CSV import force MDY or DMY date format
international: issues with decimal separator	to import csv files with point and comma as decimal separator, one has to change the Jmp Preferences (!)	Make decimal separator an option
Platforms
issue with excluded()	Some of the Platforms of the Tables menu produce their output ignoring the excluded() rowstate, others take the excluded() rowstate into account.	Handling Hidden / Excluded rows / columns in Table-handling
JSL
Jmp doesn't wait till a data table is fully processed when executing subsequent JSL code.	add wait() or dt << run formulas()	When to use Wait(0)?  Why is there an empty table if you don't add wait（）? run table script
Graph Builder
Platforms in JMP accept fractional values as Freq : )	... Graph Builder doesn't	Freq and Weight: better documentation
Graph Builder + Heatmaps	there should be an option to disable the automatic adjustment of the axis increment	Heatmap - option: fixed Tick spacing (aggregation area)
Graph Builder + manually changed axis labels	Manual axis labels are mixed up when columns are added, removed or dragged to a different position	Manual axis labels are 'mixed up' when plotting multiple columns Bugfix is in preparation (JMP19)