Report issues

Hi! im struggling with report, when i make it, it doesnt count the components that are the same and have the same lenght, because it renames them with #1, #2…and so

Senza titolo

i dont know what am i doing wrong

I think what you are doing:

(Copies the original componentinstance and adjusts its size in each instance >> wich causing the instance to be forced to “Make Unique” )

whatyoudo

What I think you should do:

Adjust the size of the original componentinstance, then copy.
needtodo

Got it, but what happens with the files and projects i have already made? can this be solved in excel?

It is possible to make and run a custom macro (VBA) to clean up the excel file. Remove all #nums , then sum and present as required

1 Like

this may go, but i have no idea how to do it, do you know any tutorial? thanks

:wink:
https://www.google.com/search?q=microsoft+excel+remove+duplicates+and+keep+sum&safe=strict&sca_esv=589753901&ei=6-92Zbe0J9P97_UP1ryC4A8&oq=microsoft+excel+remove+duplicates+and+kee+sum&gs_lp=Egxnd3Mtd2l6LXNlcnAiLW1pY3Jvc29mdCBleGNlbCByZW1vdmUgZHVwbGljYXRlcyBhbmQga2VlIHN1bSoCCAAyChAhGKABGMMEGAoyChAhGKABGMMEGApIuCxQjAtYvhZwAngBkAEAmAGqAaABjwOqAQMwLjO4AQHIAQD4AQHCAgoQABhHGNYEGLADwgIIEAAYgAQYogTiAwQYACBBiAYBkAYI&sclient=gws-wiz-serp

1 Like

Thanks! i will check it out

1 Like