Interesting (?) behavior of design tables

gerard
Posts: 60
Joined: Wed Oct 05, 2022 10:24 am
Answers: 0
x 6
x 35

Interesting (?) behavior of design tables

Unread post 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.
User avatar
josh
Posts: 295
Joined: Thu Mar 11, 2021 1:05 pm
Answers: 16
x 22
x 508

Re: Interesting (?) behavior of design tables

Unread post by josh »

Format the cells. Change to "general".
TTevolve
Posts: 254
Joined: Wed Jan 05, 2022 10:15 am
Answers: 3
x 86
x 161

Re: Interesting (?) behavior of design tables

Unread post 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
gerard
Posts: 60
Joined: Wed Oct 05, 2022 10:24 am
Answers: 0
x 6
x 35

Re: Interesting (?) behavior of design tables

Unread post by gerard »

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

UU
Post Reply