Page 1 of 1

Interesting (?) behavior of design tables

Posted: Thu Mar 16, 2023 1:02 pm
by gerard
So,

I've been playing a lot with design tables of late. Build a couple of configurations, create a design table, open it in Excel and then create the remaining configurations.

Typically I add a column for a Custom Property named Description which looks (of course) looks like $PRP@'Description'. (Or something like that, my SolidWorks is busy right now and I can't check specifically).

In the past I would typically create some sort of concatenation, etc in a formula to define the property.

Now with v2022 SP5.0, the formula will not compute, but only for this column.

Formula's work fine in other columns, but not the one with the $PRP@'Description' header.

This is the same on my home box with Office 2010 and my work box with Office 2016.

Any idea why this is so?

Thanks.

Re: Interesting (?) behavior of design tables

Posted: Thu Mar 16, 2023 1:23 pm
by josh
Format the cells. Change to "general".

Re: Interesting (?) behavior of design tables

Posted: Thu Mar 16, 2023 1:29 pm
by TTevolve
In a design table you don't need a formula, only $PRP@description in the header column to create the description field in your Custom properties.
image.png
The fields in the design table create the field in the custom properties for that configuration.
image.png

Re: Interesting (?) behavior of design tables

Posted: Thu Mar 16, 2023 2:23 pm
by gerard
josh wrote: Thu Mar 16, 2023 1:23 pm Format the cells. Change to "general".
Thank you very much.

UU