Ghost in the worksheet

[fuberator]

Hi

 

I have a worksheet where I list all Rectangular Tube 3D instances in a design. I use a record to tell what part of the frame the tube belongs to and get the length.

 

There are ghost instances of the categories B and VBOT that are 0mm/52mm long. After thorough investigation I am 99% sure that they do not not exist.

 

In any case, how do I go about tracing this to its source?

Is there a way to search for objects that have a record entry (in spotlight)?

 

Thank you

 

 

 

Edited July 21, 2022 by fuberator

[Tom W.]

What happens when you right-click on 2.3 + choose 'Select Item'?

[fuberator]

Wow thats perfect, thank you

 

I have another mystery, now that I have it clean, it does not want to give me some of the lengths. I get three dashes.

 

 

[Pat Stanford]

The three dashes indicate that there are items with different values SUMmarized.

 

So if all the A parts are supposed to be the same, they aren't.

 

Turn off the SUMmarization in Column A and see why those objects are different.

[fuberator]

Hi

 

You are right, there were non tube objects on the sheet that had the record attached, I would never have looked there. The tip about selecting 2.3 in an unsummarised list was really great. Found all bugs now.

 

Thank you!