cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
FN
FN
Level VI

Bug? Excel add-in not loading combined cells properly

In JMP 16.2, the Excel add-in doesn't merge combined cells as it happens with the Excel wizard.

 

Let's create a table with combined cells (a common practice in Excel). [see attached]

 

RowABCXYZ
10.7762170.9834860.257156000
20.9760180.9965870.680165101
30.9525020.8645370.167309010
40.1993490.3476250.2285311-1-1
50.1876440.8889050.94740700-1
60.4202030.4967390.786041-101

 

Using Excel-addin (preferences changed).

 

FN_0-1677671248815.png

 

You get this:

FN_1-1677671281852.png

 

However, when using the Excel Wizard to import the file, it works as expected:

FN_2-1677671407744.png

 

FN_3-1677671507459.png

 

Is this something happening in JMP 17 as well?

 

 

2 REPLIES 2

Re: Bug? Excel add-in not loading combined cells properly

It is a difference, dare I say 'Feature Request'.  The Excel add-in does not support the combined header cells.  It's actually a little surprising that it did pick up the higher level headers in the first column of each secondary group.  If you want that functionality, the Excel Wizard is the best solution.  The Excel Add-in does allow you to specify on which row the data begins. 

FN
FN
Level VI

Re: Bug? Excel add-in not loading combined cells properly

The Excel add-in also allows you to select where the data start, you do that visually

 

Options are the same, but the behavior is different. Bug or not, this is something to improve, in my opinion.

 

Here is the wish:

https://community.jmp.com/t5/JMP-Wish-List/Loading-combined-cells-when-using-Excel-add-in/idi-p/6073...