<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Caution: Places where Jmp does something unexpected in Discussions</title>
    <link>https://community.jmp.com/t5/Discussions/Caution-Places-where-Jmp-does-something-unexpected/m-p/699820#M88462</link>
    <description>&lt;P&gt;Definitely, &lt;LI-MESSAGE title="JMP is Not a Spreadsheet" uid="214307" url="https://community.jmp.com/t5/Discussions/JMP-is-Not-a-Spreadsheet/m-p/214307#U214307" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;. And that's great!!&lt;/P&gt;
&lt;P&gt;Besides this difference, there are other places where Jmp doesn't do/behave/produce what a newbie / innocent Jmp user expects.&lt;/P&gt;
&lt;P&gt;&lt;BR /&gt;If a user knows these issues and the remedies and workarounds -&amp;nbsp; he/she can&lt;BR /&gt;a) save a lot of time&lt;/P&gt;
&lt;P&gt;b) be safe from data loss&lt;/P&gt;
&lt;P&gt;c) be sure that the results are as expected.&lt;BR /&gt;&lt;BR /&gt;[More&amp;nbsp;&lt;LI-MESSAGE title="Topic Containers" uid="699825" url="https://community.jmp.com/t5/Discussions/Topic-Containers/m-p/699825#U699825" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;like this]&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;TABLE border="1"&gt;
&lt;TBODY&gt;
&lt;TR&gt;
&lt;TD width="404px" height="31px"&gt;&lt;FONT face="arial black,avant garde"&gt;Topic&lt;/FONT&gt;&lt;/TD&gt;
&lt;TD width="251px" height="31px"&gt;&lt;FONT face="arial black,avant garde"&gt;description&lt;/FONT&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="31px"&gt;&lt;FONT face="arial black,avant garde"&gt;Links&lt;/FONT&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="39px"&gt;There are several steps where CTRL-Z (Undo) doesn't work&lt;/TD&gt;
&lt;TD width="251px" height="39px"&gt;
&lt;P&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="310.953px" height="39px"&gt;
&lt;P&gt;&lt;LI-MESSAGE title="Where Ctrl+Z / Undo will help" uid="690049" url="https://community.jmp.com/t5/Discussions/Where-Ctrl-Z-Undo-will-help/m-p/690049#U690049" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="39px"&gt;&amp;nbsp;&lt;/TD&gt;
&lt;TD width="251px" height="39px"&gt;
&lt;P&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="310.953px" height="39px"&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="39px"&gt;&lt;FONT face="arial black,avant garde"&gt;Data Tables&lt;/FONT&gt;&lt;/TD&gt;
&lt;TD width="251px" height="39px"&gt;
&lt;P&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="310.953px" height="39px"&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="151px"&gt;Formula column + &lt;STRONG&gt;excluded rows&lt;/STRONG&gt;&lt;/TD&gt;
&lt;TD width="251px" height="151px"&gt;
&lt;P&gt;&lt;SPAN&gt;Unlike plots and reports,&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;column formulas&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp; don't use the information about&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;excluded rows.&amp;nbsp;&lt;/STRONG&gt;&lt;STRONG&gt;Workaround:&amp;nbsp;&lt;/STRONG&gt;&lt;BR /&gt;&lt;FONT face="courier new,courier"&gt;col mean(:height, excluded())&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="310.953px" height="151px"&gt;
&lt;P&gt;&lt;LI-MESSAGE title="Formula Editor: meaningful results with excluded rows" uid="589701" url="https://community.jmp.com/t5/JMP-Wish-List/Formula-Editor-meaningful-results-with-excluded-rows/m-p/589701#U589701" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-idea-thread lia-fa-icon lia-fa-idea lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&lt;/P&gt;
&lt;P&gt;&lt;LI-MESSAGE title="Compute Column Mean ..." uid="10377" url="https://community.jmp.com/t5/Discussions/Compute-Column-Mean-while-restricting-observations-used/m-p/10377#U10377" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&lt;LI-MESSAGE title="Col Max() ... excluded row" uid="10555" url="https://community.jmp.com/t5/Discussions/JMP10-Col-Max-and-Col-Min-functions-returned-the-data-from/m-p/10555#U10555" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&lt;BR /&gt;&lt;LI-MESSAGE title="Col Functions and Row States" uid="351705" url="https://community.jmp.com/t5/Discussions/Col-Functions-and-Row-States/m-p/351705#U351705" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;&lt;BR /&gt;&lt;LI-MESSAGE title="Exclude data in formula" uid="512366" url="https://community.jmp.com/t5/Discussions/Exclude-data-in-formula/m-p/512366#U512366" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="151px"&gt;&lt;STRONG&gt;Source&lt;/STRONG&gt; Scripts + Tables/&lt;STRONG&gt;Update&lt;/STRONG&gt;&lt;/TD&gt;
&lt;TD width="251px" height="151px"&gt;&lt;SPAN&gt;Tables/Update overwrites an existing Source script&lt;BR /&gt;&lt;BR /&gt;same issue for Concatenate +&amp;nbsp;&lt;FONT face="courier new,courier"&gt;Append to first table&lt;BR /&gt;&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="151px"&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;LI-MESSAGE title="Update &amp;amp; Concatenate:source script collision" uid="590519" url="https://community.jmp.com/t5/JMP-Wish-List/Update-amp-Concatenate-source-script-collision/m-p/590519#U590519" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-idea-thread lia-fa-icon lia-fa-idea lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&lt;BR /&gt;workaround,&amp;nbsp;&lt;/STRONG&gt;@internal:&lt;BR /&gt;use our bug-fixed Update platform&lt;BR /&gt;it archives the source script before overwriting it&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="478px"&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="hogi_0-1752874060251.png" style="width: 400px;"&gt;&lt;img src="https://community.jmp.com/t5/image/serverpage/image-id/78563i5BB123FBF24CFC61/image-size/medium?v=v2&amp;amp;px=400" role="button" title="hogi_0-1752874060251.png" alt="hogi_0-1752874060251.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="251px" height="478px"&gt;&lt;SPAN&gt;&lt;STRONG&gt;Danger!&lt;/STRONG&gt;&lt;BR /&gt;Besides importing new data from an Excel file,&lt;BR /&gt;the script resets ALL changes of the data table. (!!!)&lt;/SPAN&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="478px"&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;LI-MESSAGE title="Disable &amp;amp;quot;Update Table&amp;amp;quot; script?" uid="887849" url="https://community.jmp.com/t5/Discussions/Disable-quot-Update-Table-quot-script/m-p/887849#U887849" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="96px"&gt;issues with &lt;STRONG&gt;dates&lt;/STRONG&gt;&lt;/TD&gt;
&lt;TD width="251px" height="96px"&gt;&lt;SPAN&gt;JMP prefers M.D.Y&amp;nbsp;&lt;BR /&gt;this can lead to issues with D.M.Y&lt;/SPAN&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="96px"&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&lt;LI-MESSAGE title="CSV import force MDY or DMY date format" uid="746985" url="https://community.jmp.com/t5/JMP-Wish-List/CSV-import-force-MDY-or-DMY-date-format/m-p/746985#U746985" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-idea-thread lia-fa-icon lia-fa-idea lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="64px"&gt;issues with &lt;STRONG&gt;decimal separator&lt;/STRONG&gt;&lt;/TD&gt;
&lt;TD width="251px" height="64px"&gt;&lt;SPAN&gt;file import: no setting for decimal separator&lt;BR /&gt;neither via GUI nor via JSL&lt;/SPAN&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="64px"&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;LI-MESSAGE title="txt import - point and comma ?" uid="825586" url="https://community.jmp.com/t5/Discussions/txt-import-point-and-comma/m-p/825586#U825586" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&lt;LI-MESSAGE title="Make decimal separator an option" uid="251768" url="https://community.jmp.com/t5/JMP-Wish-List/Make-decimal-separator-an-option/m-p/251768#U251768" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-idea-thread lia-fa-icon lia-fa-idea lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="92px"&gt;Score unique &amp;amp; count unique&lt;/TD&gt;
&lt;TD width="251px" height="92px"&gt;
&lt;P&gt;&lt;SPAN&gt;&amp;nbsp;excluded rows are excluded from the calculation.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;values don't get updated after changing the row states&lt;/SPAN&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="310.953px" height="92px"&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&lt;LI-MESSAGE title="score Unique &amp;amp;amp; count unique" uid="905815" url="https://community.jmp.com/t5/Discussions/score-Unique-amp-count-unique/m-p/905815#U905815" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="39px"&gt;&amp;nbsp;&lt;/TD&gt;
&lt;TD width="251px" height="39px"&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="39px"&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="39px"&gt;&lt;FONT face="arial black,avant garde"&gt;Platforms&lt;/FONT&gt;&lt;/TD&gt;
&lt;TD width="251px" height="39px"&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="39px"&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="55px"&gt;Query Builder + Formula Columns&lt;/TD&gt;
&lt;TD width="251px" height="55px"&gt;Formula Columns get transferred to the result table, where they get evaluated again. Issues with&lt;FONT face="courier new,courier"&gt; dif()&lt;/FONT&gt;, L&lt;FONT face="courier new,courier"&gt;ag()&lt;/FONT&gt;, &lt;FONT face="courier new,courier"&gt;Col.. ()&lt;/FONT&gt; aggregations ... !&lt;/TD&gt;
&lt;TD width="310.953px" height="55px"&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;LI-MESSAGE title="Why is there such unexpected re-calculation of columns without formulas?" uid="906901" url="https://community.jmp.com/t5/Discussions/Why-is-there-such-unexpected-re-calculation-of-columns-without/m-p/906901#U906901" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="89px"&gt;issue with &lt;FONT face="courier new,courier"&gt;excluded()&lt;/FONT&gt;&lt;/TD&gt;
&lt;TD width="251px" height="89px"&gt;Some of the Platforms of the Tables menu&lt;BR /&gt;produce their output&amp;nbsp;&lt;STRONG&gt;ignoring&amp;nbsp;&lt;FONT face="courier new, courier"&gt;&lt;FONT face="courier new,courier"&gt;the&lt;/FONT&gt;&lt;/FONT&gt;&lt;/STRONG&gt;&amp;nbsp;&lt;FONT face="courier new,courier"&gt;excluded()&lt;/FONT&gt;&amp;nbsp;row state, others take the&amp;nbsp;&lt;FONT face="courier new,courier"&gt;excluded()&lt;/FONT&gt;&amp;nbsp;row state into account.&lt;/TD&gt;
&lt;TD width="310.953px" height="89px"&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;LI-MESSAGE title="Handling Hidden / Excluded rows / columns in Table-handling" uid="611402" url="https://community.jmp.com/t5/JMP-Wish-List/Handling-Hidden-Excluded-rows-columns-in-Table-handling/m-p/611402#U611402" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-idea-thread lia-fa-icon lia-fa-idea lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="140px"&gt;&lt;FONT face="courier new,courier"&gt;Tables/Split&lt;/FONT&gt;&lt;BR /&gt;possible issue with &lt;STRONG&gt;Keep&lt;/STRONG&gt;&lt;/TD&gt;
&lt;TD width="251px" height="140px"&gt;Split merges multiple rows into a single row. "Keep" - which entry?&amp;nbsp;the &lt;STRONG&gt;first&lt;/STRONG&gt; one - can lead to surprising results:&lt;/TD&gt;
&lt;TD width="310.953px" height="140px"&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;LI-MESSAGE title="Bad Stacking?" uid="869509" url="https://community.jmp.com/t5/Discussions/Bad-Stacking/m-p/869509#U869509" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="39px"&gt;Scoring in Graph Builder&lt;/TD&gt;
&lt;TD width="251px" height="39px"&gt;The graph doesn't get updated when row states are changed in the data table&lt;/TD&gt;
&lt;TD width="310.953px" height="39px"&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;LI-MESSAGE title="score Unique &amp;amp;amp; count unique" uid="905815" url="https://community.jmp.com/t5/Discussions/score-Unique-amp-count-unique/m-p/905815#U905815" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="39px"&gt;&amp;nbsp;&lt;/TD&gt;
&lt;TD width="251px" height="39px"&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="39px"&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="39px"&gt;&lt;FONT face="arial black,avant garde"&gt;&lt;STRONG&gt;JSL&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/TD&gt;
&lt;TD width="251px" height="39px"&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="39px"&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="96px"&gt;Jmp doesn't wait till a data table is fully processed when executing subsequent JSL code.&lt;/TD&gt;
&lt;TD width="251px" height="96px"&gt;add &lt;FONT face="courier new,courier"&gt;wait()&lt;BR /&gt;&lt;/FONT&gt;or &lt;FONT face="courier new,courier"&gt;dt &amp;lt;&amp;lt; run formulas()&lt;/FONT&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="96px"&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&lt;LI-MESSAGE title="When to use Wait(0)?" uid="14069" url="https://community.jmp.com/t5/Discussions/When-to-use-Wait-0/m-p/14069#U14069" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;&lt;BR /&gt;&lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;&lt;LI-MESSAGE title="Why is there an empty table if you don't add wait（）?" uid="664414" url="https://community.jmp.com/t5/Discussions/Why-is-there-an-empty-table-if-you-don-t-add-wait/m-p/664414#U664414" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&lt;/P&gt;
&lt;P&gt;&lt;LI-MESSAGE title="run table script" uid="754736" url="https://community.jmp.com/t5/Discussions/run-table-script/m-p/754736#U754736" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="39px"&gt;&amp;nbsp;&lt;/TD&gt;
&lt;TD width="251px" height="39px"&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="39px"&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="39px"&gt;&lt;FONT face="arial black,avant garde"&gt;&lt;STRONG&gt;Python&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/TD&gt;
&lt;TD width="251px" height="39px"&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="39px"&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="10px"&gt;&amp;nbsp;&lt;/TD&gt;
&lt;TD width="251px" height="10px"&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="10px"&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="39px"&gt;&lt;FONT face="arial black,avant garde"&gt;&lt;STRONG&gt;Graph Builder&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/TD&gt;
&lt;TD width="251px" height="39px"&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="39px"&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="57px"&gt;Platforms in JMP accept fractional values as Freq : )&lt;/TD&gt;
&lt;TD width="251px" height="57px"&gt;&lt;A href="https://community.jmp.com/t5/Discussions/Not-sure-how-to-use-amp-quot-Weight-amp-quot-in-amp-quot-Analyze/m-p/805175/highlight/true#M98325" target="_blank" rel="noopener"&gt;... Graph Builder doesn't&lt;/A&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="57px"&gt;&lt;LI-MESSAGE title="Freq and Weight: better documentation" uid="684843" url="https://community.jmp.com/t5/JMP-Wish-List/Freq-and-Weight-better-documentation/m-p/684843#U684843" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-idea-thread lia-fa-icon lia-fa-idea lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="57px"&gt;Graph Builder&lt;BR /&gt;+ &lt;STRONG&gt;Heatmaps&lt;/STRONG&gt;&lt;/TD&gt;
&lt;TD width="251px" height="57px"&gt;there should be an option to disable the&lt;BR /&gt;automatic adjustment of the axis increment&lt;/TD&gt;
&lt;TD width="310.953px" height="57px"&gt;&lt;LI-MESSAGE title="Heatmap - option: fixed Tick spacing (aggregation area)" uid="571486" url="https://community.jmp.com/t5/JMP-Wish-List/Heatmap-option-fixed-Tick-spacing-aggregation-area/m-p/571486#U571486" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-idea-thread lia-fa-icon lia-fa-idea lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="68px"&gt;&lt;STRIKE&gt;Graph Builder&lt;/STRIKE&gt;&lt;BR /&gt;&lt;STRIKE&gt;+ &lt;STRONG&gt;manually changed axis labels&lt;/STRONG&gt;&lt;/STRIKE&gt;&lt;/TD&gt;
&lt;TD width="251px" height="68px"&gt;&lt;STRIKE&gt;Manual axis labels are mixed up when columns are added, removed or dragged to a different position&lt;/STRIKE&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="68px"&gt;&lt;LI-MESSAGE title="Manual axis labels are 'mixed up' when plotting multiple columns" uid="602543" url="https://community.jmp.com/t5/JMP-Wish-List/Manual-axis-labels-are-mixed-up-when-plotting-multiple-columns/m-p/602543#U602543" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-idea-thread lia-fa-icon lia-fa-idea lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&lt;BR /&gt;Bug fixed&amp;nbsp; in JMP19&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="41px"&gt;Type Properties&lt;/TD&gt;
&lt;TD width="251px" height="41px"&gt;Type properties collide with Data Filters&lt;BR /&gt;-&amp;gt; significant harm for exploratory data analysis&lt;/TD&gt;
&lt;TD width="310.953px" height="41px"&gt;&lt;A href="https://community.jmp.com/t5/Discussions/consistent-marker-and-style-control-type-properties/m-p/917699/highlight/true#M107731" target="_blank" rel="noopener"&gt;https://community.jmp.com/t5/Discussions/consistent-marker-and-style-control-type-properties/m-p/917699/highlight/true#M107731&lt;/A&gt;&amp;nbsp;&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="16px"&gt;Several Inconsistencies of Color/Style settings in Graph Builder&lt;/TD&gt;
&lt;TD width="251px" height="16px"&gt;&amp;nbsp;&lt;/TD&gt;
&lt;TD width="310.953px" height="16px"&gt;&lt;LI-MESSAGE title="Why is this DropZone called &amp;amp;quot;Color&amp;amp;quot;" uid="783786" url="https://community.jmp.com/t5/Discussions/Why-is-this-DropZone-called-quot-Color-quot/m-p/783786#U783786" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;&lt;/TD&gt;
&lt;/TR&gt;
&lt;/TBODY&gt;
&lt;/TABLE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Thu, 25 Dec 2025 21:39:52 GMT</pubDate>
    <dc:creator>hogi</dc:creator>
    <dc:date>2025-12-25T21:39:52Z</dc:date>
    <item>
      <title>Caution: Places where Jmp does something unexpected</title>
      <link>https://community.jmp.com/t5/Discussions/Caution-Places-where-Jmp-does-something-unexpected/m-p/699820#M88462</link>
      <description>&lt;P&gt;Definitely, &lt;LI-MESSAGE title="JMP is Not a Spreadsheet" uid="214307" url="https://community.jmp.com/t5/Discussions/JMP-is-Not-a-Spreadsheet/m-p/214307#U214307" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;. And that's great!!&lt;/P&gt;
&lt;P&gt;Besides this difference, there are other places where Jmp doesn't do/behave/produce what a newbie / innocent Jmp user expects.&lt;/P&gt;
&lt;P&gt;&lt;BR /&gt;If a user knows these issues and the remedies and workarounds -&amp;nbsp; he/she can&lt;BR /&gt;a) save a lot of time&lt;/P&gt;
&lt;P&gt;b) be safe from data loss&lt;/P&gt;
&lt;P&gt;c) be sure that the results are as expected.&lt;BR /&gt;&lt;BR /&gt;[More&amp;nbsp;&lt;LI-MESSAGE title="Topic Containers" uid="699825" url="https://community.jmp.com/t5/Discussions/Topic-Containers/m-p/699825#U699825" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;like this]&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;TABLE border="1"&gt;
&lt;TBODY&gt;
&lt;TR&gt;
&lt;TD width="404px" height="31px"&gt;&lt;FONT face="arial black,avant garde"&gt;Topic&lt;/FONT&gt;&lt;/TD&gt;
&lt;TD width="251px" height="31px"&gt;&lt;FONT face="arial black,avant garde"&gt;description&lt;/FONT&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="31px"&gt;&lt;FONT face="arial black,avant garde"&gt;Links&lt;/FONT&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="39px"&gt;There are several steps where CTRL-Z (Undo) doesn't work&lt;/TD&gt;
&lt;TD width="251px" height="39px"&gt;
&lt;P&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="310.953px" height="39px"&gt;
&lt;P&gt;&lt;LI-MESSAGE title="Where Ctrl+Z / Undo will help" uid="690049" url="https://community.jmp.com/t5/Discussions/Where-Ctrl-Z-Undo-will-help/m-p/690049#U690049" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="39px"&gt;&amp;nbsp;&lt;/TD&gt;
&lt;TD width="251px" height="39px"&gt;
&lt;P&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="310.953px" height="39px"&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="39px"&gt;&lt;FONT face="arial black,avant garde"&gt;Data Tables&lt;/FONT&gt;&lt;/TD&gt;
&lt;TD width="251px" height="39px"&gt;
&lt;P&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="310.953px" height="39px"&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="151px"&gt;Formula column + &lt;STRONG&gt;excluded rows&lt;/STRONG&gt;&lt;/TD&gt;
&lt;TD width="251px" height="151px"&gt;
&lt;P&gt;&lt;SPAN&gt;Unlike plots and reports,&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;column formulas&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp; don't use the information about&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;&lt;STRONG&gt;excluded rows.&amp;nbsp;&lt;/STRONG&gt;&lt;STRONG&gt;Workaround:&amp;nbsp;&lt;/STRONG&gt;&lt;BR /&gt;&lt;FONT face="courier new,courier"&gt;col mean(:height, excluded())&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="310.953px" height="151px"&gt;
&lt;P&gt;&lt;LI-MESSAGE title="Formula Editor: meaningful results with excluded rows" uid="589701" url="https://community.jmp.com/t5/JMP-Wish-List/Formula-Editor-meaningful-results-with-excluded-rows/m-p/589701#U589701" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-idea-thread lia-fa-icon lia-fa-idea lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&lt;/P&gt;
&lt;P&gt;&lt;LI-MESSAGE title="Compute Column Mean ..." uid="10377" url="https://community.jmp.com/t5/Discussions/Compute-Column-Mean-while-restricting-observations-used/m-p/10377#U10377" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&lt;LI-MESSAGE title="Col Max() ... excluded row" uid="10555" url="https://community.jmp.com/t5/Discussions/JMP10-Col-Max-and-Col-Min-functions-returned-the-data-from/m-p/10555#U10555" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&lt;BR /&gt;&lt;LI-MESSAGE title="Col Functions and Row States" uid="351705" url="https://community.jmp.com/t5/Discussions/Col-Functions-and-Row-States/m-p/351705#U351705" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;&lt;BR /&gt;&lt;LI-MESSAGE title="Exclude data in formula" uid="512366" url="https://community.jmp.com/t5/Discussions/Exclude-data-in-formula/m-p/512366#U512366" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="151px"&gt;&lt;STRONG&gt;Source&lt;/STRONG&gt; Scripts + Tables/&lt;STRONG&gt;Update&lt;/STRONG&gt;&lt;/TD&gt;
&lt;TD width="251px" height="151px"&gt;&lt;SPAN&gt;Tables/Update overwrites an existing Source script&lt;BR /&gt;&lt;BR /&gt;same issue for Concatenate +&amp;nbsp;&lt;FONT face="courier new,courier"&gt;Append to first table&lt;BR /&gt;&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="151px"&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;LI-MESSAGE title="Update &amp;amp; Concatenate:source script collision" uid="590519" url="https://community.jmp.com/t5/JMP-Wish-List/Update-amp-Concatenate-source-script-collision/m-p/590519#U590519" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-idea-thread lia-fa-icon lia-fa-idea lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&lt;BR /&gt;workaround,&amp;nbsp;&lt;/STRONG&gt;@internal:&lt;BR /&gt;use our bug-fixed Update platform&lt;BR /&gt;it archives the source script before overwriting it&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="478px"&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="hogi_0-1752874060251.png" style="width: 400px;"&gt;&lt;img src="https://community.jmp.com/t5/image/serverpage/image-id/78563i5BB123FBF24CFC61/image-size/medium?v=v2&amp;amp;px=400" role="button" title="hogi_0-1752874060251.png" alt="hogi_0-1752874060251.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="251px" height="478px"&gt;&lt;SPAN&gt;&lt;STRONG&gt;Danger!&lt;/STRONG&gt;&lt;BR /&gt;Besides importing new data from an Excel file,&lt;BR /&gt;the script resets ALL changes of the data table. (!!!)&lt;/SPAN&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="478px"&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;LI-MESSAGE title="Disable &amp;amp;quot;Update Table&amp;amp;quot; script?" uid="887849" url="https://community.jmp.com/t5/Discussions/Disable-quot-Update-Table-quot-script/m-p/887849#U887849" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="96px"&gt;issues with &lt;STRONG&gt;dates&lt;/STRONG&gt;&lt;/TD&gt;
&lt;TD width="251px" height="96px"&gt;&lt;SPAN&gt;JMP prefers M.D.Y&amp;nbsp;&lt;BR /&gt;this can lead to issues with D.M.Y&lt;/SPAN&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="96px"&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&lt;LI-MESSAGE title="CSV import force MDY or DMY date format" uid="746985" url="https://community.jmp.com/t5/JMP-Wish-List/CSV-import-force-MDY-or-DMY-date-format/m-p/746985#U746985" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-idea-thread lia-fa-icon lia-fa-idea lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="64px"&gt;issues with &lt;STRONG&gt;decimal separator&lt;/STRONG&gt;&lt;/TD&gt;
&lt;TD width="251px" height="64px"&gt;&lt;SPAN&gt;file import: no setting for decimal separator&lt;BR /&gt;neither via GUI nor via JSL&lt;/SPAN&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="64px"&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;LI-MESSAGE title="txt import - point and comma ?" uid="825586" url="https://community.jmp.com/t5/Discussions/txt-import-point-and-comma/m-p/825586#U825586" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&lt;LI-MESSAGE title="Make decimal separator an option" uid="251768" url="https://community.jmp.com/t5/JMP-Wish-List/Make-decimal-separator-an-option/m-p/251768#U251768" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-idea-thread lia-fa-icon lia-fa-idea lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="92px"&gt;Score unique &amp;amp; count unique&lt;/TD&gt;
&lt;TD width="251px" height="92px"&gt;
&lt;P&gt;&lt;SPAN&gt;&amp;nbsp;excluded rows are excluded from the calculation.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;values don't get updated after changing the row states&lt;/SPAN&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="310.953px" height="92px"&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&lt;LI-MESSAGE title="score Unique &amp;amp;amp; count unique" uid="905815" url="https://community.jmp.com/t5/Discussions/score-Unique-amp-count-unique/m-p/905815#U905815" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="39px"&gt;&amp;nbsp;&lt;/TD&gt;
&lt;TD width="251px" height="39px"&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="39px"&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="39px"&gt;&lt;FONT face="arial black,avant garde"&gt;Platforms&lt;/FONT&gt;&lt;/TD&gt;
&lt;TD width="251px" height="39px"&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="39px"&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="55px"&gt;Query Builder + Formula Columns&lt;/TD&gt;
&lt;TD width="251px" height="55px"&gt;Formula Columns get transferred to the result table, where they get evaluated again. Issues with&lt;FONT face="courier new,courier"&gt; dif()&lt;/FONT&gt;, L&lt;FONT face="courier new,courier"&gt;ag()&lt;/FONT&gt;, &lt;FONT face="courier new,courier"&gt;Col.. ()&lt;/FONT&gt; aggregations ... !&lt;/TD&gt;
&lt;TD width="310.953px" height="55px"&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;LI-MESSAGE title="Why is there such unexpected re-calculation of columns without formulas?" uid="906901" url="https://community.jmp.com/t5/Discussions/Why-is-there-such-unexpected-re-calculation-of-columns-without/m-p/906901#U906901" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="89px"&gt;issue with &lt;FONT face="courier new,courier"&gt;excluded()&lt;/FONT&gt;&lt;/TD&gt;
&lt;TD width="251px" height="89px"&gt;Some of the Platforms of the Tables menu&lt;BR /&gt;produce their output&amp;nbsp;&lt;STRONG&gt;ignoring&amp;nbsp;&lt;FONT face="courier new, courier"&gt;&lt;FONT face="courier new,courier"&gt;the&lt;/FONT&gt;&lt;/FONT&gt;&lt;/STRONG&gt;&amp;nbsp;&lt;FONT face="courier new,courier"&gt;excluded()&lt;/FONT&gt;&amp;nbsp;row state, others take the&amp;nbsp;&lt;FONT face="courier new,courier"&gt;excluded()&lt;/FONT&gt;&amp;nbsp;row state into account.&lt;/TD&gt;
&lt;TD width="310.953px" height="89px"&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;LI-MESSAGE title="Handling Hidden / Excluded rows / columns in Table-handling" uid="611402" url="https://community.jmp.com/t5/JMP-Wish-List/Handling-Hidden-Excluded-rows-columns-in-Table-handling/m-p/611402#U611402" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-idea-thread lia-fa-icon lia-fa-idea lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="140px"&gt;&lt;FONT face="courier new,courier"&gt;Tables/Split&lt;/FONT&gt;&lt;BR /&gt;possible issue with &lt;STRONG&gt;Keep&lt;/STRONG&gt;&lt;/TD&gt;
&lt;TD width="251px" height="140px"&gt;Split merges multiple rows into a single row. "Keep" - which entry?&amp;nbsp;the &lt;STRONG&gt;first&lt;/STRONG&gt; one - can lead to surprising results:&lt;/TD&gt;
&lt;TD width="310.953px" height="140px"&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;LI-MESSAGE title="Bad Stacking?" uid="869509" url="https://community.jmp.com/t5/Discussions/Bad-Stacking/m-p/869509#U869509" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="39px"&gt;Scoring in Graph Builder&lt;/TD&gt;
&lt;TD width="251px" height="39px"&gt;The graph doesn't get updated when row states are changed in the data table&lt;/TD&gt;
&lt;TD width="310.953px" height="39px"&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;LI-MESSAGE title="score Unique &amp;amp;amp; count unique" uid="905815" url="https://community.jmp.com/t5/Discussions/score-Unique-amp-count-unique/m-p/905815#U905815" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="39px"&gt;&amp;nbsp;&lt;/TD&gt;
&lt;TD width="251px" height="39px"&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="39px"&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="39px"&gt;&lt;FONT face="arial black,avant garde"&gt;&lt;STRONG&gt;JSL&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/TD&gt;
&lt;TD width="251px" height="39px"&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="39px"&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="96px"&gt;Jmp doesn't wait till a data table is fully processed when executing subsequent JSL code.&lt;/TD&gt;
&lt;TD width="251px" height="96px"&gt;add &lt;FONT face="courier new,courier"&gt;wait()&lt;BR /&gt;&lt;/FONT&gt;or &lt;FONT face="courier new,courier"&gt;dt &amp;lt;&amp;lt; run formulas()&lt;/FONT&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="96px"&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&lt;LI-MESSAGE title="When to use Wait(0)?" uid="14069" url="https://community.jmp.com/t5/Discussions/When-to-use-Wait-0/m-p/14069#U14069" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;&lt;BR /&gt;&lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;&lt;LI-MESSAGE title="Why is there an empty table if you don't add wait（）?" uid="664414" url="https://community.jmp.com/t5/Discussions/Why-is-there-an-empty-table-if-you-don-t-add-wait/m-p/664414#U664414" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&lt;/P&gt;
&lt;P&gt;&lt;LI-MESSAGE title="run table script" uid="754736" url="https://community.jmp.com/t5/Discussions/run-table-script/m-p/754736#U754736" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="39px"&gt;&amp;nbsp;&lt;/TD&gt;
&lt;TD width="251px" height="39px"&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="39px"&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="39px"&gt;&lt;FONT face="arial black,avant garde"&gt;&lt;STRONG&gt;Python&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/TD&gt;
&lt;TD width="251px" height="39px"&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="39px"&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="10px"&gt;&amp;nbsp;&lt;/TD&gt;
&lt;TD width="251px" height="10px"&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="10px"&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="39px"&gt;&lt;FONT face="arial black,avant garde"&gt;&lt;STRONG&gt;Graph Builder&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/TD&gt;
&lt;TD width="251px" height="39px"&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="39px"&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="57px"&gt;Platforms in JMP accept fractional values as Freq : )&lt;/TD&gt;
&lt;TD width="251px" height="57px"&gt;&lt;A href="https://community.jmp.com/t5/Discussions/Not-sure-how-to-use-amp-quot-Weight-amp-quot-in-amp-quot-Analyze/m-p/805175/highlight/true#M98325" target="_blank" rel="noopener"&gt;... Graph Builder doesn't&lt;/A&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="57px"&gt;&lt;LI-MESSAGE title="Freq and Weight: better documentation" uid="684843" url="https://community.jmp.com/t5/JMP-Wish-List/Freq-and-Weight-better-documentation/m-p/684843#U684843" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-idea-thread lia-fa-icon lia-fa-idea lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="57px"&gt;Graph Builder&lt;BR /&gt;+ &lt;STRONG&gt;Heatmaps&lt;/STRONG&gt;&lt;/TD&gt;
&lt;TD width="251px" height="57px"&gt;there should be an option to disable the&lt;BR /&gt;automatic adjustment of the axis increment&lt;/TD&gt;
&lt;TD width="310.953px" height="57px"&gt;&lt;LI-MESSAGE title="Heatmap - option: fixed Tick spacing (aggregation area)" uid="571486" url="https://community.jmp.com/t5/JMP-Wish-List/Heatmap-option-fixed-Tick-spacing-aggregation-area/m-p/571486#U571486" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-idea-thread lia-fa-icon lia-fa-idea lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="68px"&gt;&lt;STRIKE&gt;Graph Builder&lt;/STRIKE&gt;&lt;BR /&gt;&lt;STRIKE&gt;+ &lt;STRONG&gt;manually changed axis labels&lt;/STRONG&gt;&lt;/STRIKE&gt;&lt;/TD&gt;
&lt;TD width="251px" height="68px"&gt;&lt;STRIKE&gt;Manual axis labels are mixed up when columns are added, removed or dragged to a different position&lt;/STRIKE&gt;&lt;/TD&gt;
&lt;TD width="310.953px" height="68px"&gt;&lt;LI-MESSAGE title="Manual axis labels are 'mixed up' when plotting multiple columns" uid="602543" url="https://community.jmp.com/t5/JMP-Wish-List/Manual-axis-labels-are-mixed-up-when-plotting-multiple-columns/m-p/602543#U602543" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-idea-thread lia-fa-icon lia-fa-idea lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&lt;BR /&gt;Bug fixed&amp;nbsp; in JMP19&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="41px"&gt;Type Properties&lt;/TD&gt;
&lt;TD width="251px" height="41px"&gt;Type properties collide with Data Filters&lt;BR /&gt;-&amp;gt; significant harm for exploratory data analysis&lt;/TD&gt;
&lt;TD width="310.953px" height="41px"&gt;&lt;A href="https://community.jmp.com/t5/Discussions/consistent-marker-and-style-control-type-properties/m-p/917699/highlight/true#M107731" target="_blank" rel="noopener"&gt;https://community.jmp.com/t5/Discussions/consistent-marker-and-style-control-type-properties/m-p/917699/highlight/true#M107731&lt;/A&gt;&amp;nbsp;&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="404px" height="16px"&gt;Several Inconsistencies of Color/Style settings in Graph Builder&lt;/TD&gt;
&lt;TD width="251px" height="16px"&gt;&amp;nbsp;&lt;/TD&gt;
&lt;TD width="310.953px" height="16px"&gt;&lt;LI-MESSAGE title="Why is this DropZone called &amp;amp;quot;Color&amp;amp;quot;" uid="783786" url="https://community.jmp.com/t5/Discussions/Why-is-this-DropZone-called-quot-Color-quot/m-p/783786#U783786" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"&gt;&lt;/LI-MESSAGE&gt;&amp;nbsp;&lt;/TD&gt;
&lt;/TR&gt;
&lt;/TBODY&gt;
&lt;/TABLE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 25 Dec 2025 21:39:52 GMT</pubDate>
      <guid>https://community.jmp.com/t5/Discussions/Caution-Places-where-Jmp-does-something-unexpected/m-p/699820#M88462</guid>
      <dc:creator>hogi</dc:creator>
      <dc:date>2025-12-25T21:39:52Z</dc:date>
    </item>
  </channel>
</rss>

