cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Read all cells from linked Excel - only yellow-mark invalid parameter values

Read all cells from linked Excel - only yellow-mark invalid parameter values

If a cell value in xlsx is "#DIVISION/0!", this parameter becomes yellow in Inventors fx-dialog. This is expected behavior since there is no valied value to read. But all remaining parameters also becomes yellow - the read procedure simply stalls at the first error:

SkadborgNTI_0-1682324179534.png

If your focus is on p5 in this sample, then you have to figure out, that core problem is p3. Easy to see here, but if you read hundreds of values it is not always obvious for a user, where to look for the error.

 

Suggestion: read all values, and yellow-mark only those values that has invalid errors.

Can't find what you're looking for? Ask the community or share your knowledge.

Submit Idea