Caution: Places where Jmp does something unexpected

[#1]

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

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

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

b) be safe from data loss

c) 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
	Danger! Besides importing new data from an Excel file, the script resets ALL changes of the data table. (!!!)	Disable "Update Table" script?
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
issues with decimal separator	file import: no setting for decimal separator neither via GUI nor via JSL	txt import - point and comma ?   Make decimal separator an option
Platforms
issue with excluded()	Some of the Platforms of the Tables menu produce their output ignoring the excluded() row state, others take the excluded() row state into account.	Handling Hidden / Excluded rows / columns in Table-handling
Tables/Split possible issue with Keep	Split merges multiple rows into a single row. "Keep" - which entry? the first one - can lead to surprising results:	Bad Stacking?
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)