Equation function "INT" doesn't seem to work

[charlesculp]

Am I missing something? I am trying to add an extra sheet at the end of all drawings. Because it is not part of the drawing itself, I need the page count for the drawing to be less than the actual calculated page count. I tried to use an equation in the custom properties to make this happen.

To do this, it does some math, but it looks like it turns it into a floating point number, and uses the length unit standard tolerance for significant digits (three past the .). Ok, so I used the "int" function, but it does nothing. What gives?

Shouldn't

Code: Select all

int ( $PRP:"SW-Total Sheets" - 1 )

return an integer? Solidworks 2022 SP5.0

[jcapriotti]

Hey Charles, long time.

I don't see a way to make this work with the equations in custom properties. The INT function is working somewhat if you put a decimal value in like 5.523, it changes it to 5.000. Excel does the same thing if you have decimal place formatting set on the cell.

image.png (6.18 KiB) Viewed 660 times

[JSculley]

Yeah, the INT function is borked. You wouldn't be bothering with this at all if this SPR were addressed:

SPR769752 - Ability to set certain drawing sheets to be ignored from total sheet count

[charlesculp]

Yeah, the INT function is borked. You wouldn't be bothering with this at all if this SPR were addressed:

SPR769752 - Ability to set certain drawing sheets to be ignored from total sheet count

Nice, I will +1 that SPR.

Nice to hear from you, Jason. Back doing engineering work again after a decade as a manager.

[josh]

I hope that's an old pic you're using there for your profile... I've considered you somewhat of a colleauge for almost as many years as you look old in that pic.

[gupta9665]

You may have to use a macro that counts the total sheet, subtract 1 and update the custom property. Downside, run macro every time you add/remove a sheet. A macro or add-in to run in the background and act on file save might help updating the sheet count.

[charlesculp]

I hope that's an old pic you're using there for your profile... I've considered you somewhat of a colleauge for almost as many years as you look old in that pic.

That was at least four haircuts ago. I had to get it trimmed when I started going on job interviews. It's all still there, though. The picture is from 2021, I believe.

My solution was to do this Solidworks PDM Dispatch Action (during check-out) by creating two variables, one that is the $PRP:"Total Sheets" and the other is the new calculated value. It determines if there is the attached change sheet at the end, and then if there is it subtracts a page from the total. This afternoon I will make it work for a variable number of change sheets; in case the designer gets ambitious and makes multiple pages worth of changes at a time.

[AlexLachance]

Yeah, the INT function is borked. You wouldn't be bothering with this at all if this SPR were addressed:

SPR769752 - Ability to set certain drawing sheets to be ignored from total sheet count

So um, I'm trying to vote on this SPR, but can't seem to find where anymore. I used to do it through the Knowledge base but it doesn't seem to work anymore, I get the search result, but can't vote on it. I tried looking up on the Platform but didn't find any topic on the platform linked to it either...

https://support.3ds.com/knowledge-base/ ... :SPR769752

Edit: Is it the badge on the right of the title to "Add to Favorites" that counts as a vote? If so, that is truely intuitive, feels just as intuitive as the platform.

[charlesculp]

I hope that's an old pic you're using there for your profile... I've considered you somewhat of a colleauge for almost as many years as you look old in that pic.

I updated my avatar for you. Funny story, I was at the grocery store with my daughter, who is 11, and we were getting a week's worth of groceries. Then I thought of something we forgot. I ran back to get it, while my daughter put all the groceries on the checkout conveyor. When I get back the cashier was patiently waiting for my return, because the mirin in our purchase contains alcohol.

So, I was carded last week for the first time in probably a decade.

[charlesculp]

As for setting the page numbers, I now do it TWO ways. On Checkin, PDM will run a refresh on the page numbers. I also added a macro to do it, whenever someone adds a DCN to the drawing. So, I did it both ways, neither using custom property equations. The Dispatch is shown above, the VBA code is below. This is a snippet of the appropriate portion.

Code: Select all

NewPropertyNames(28) = "DCN Total Sheets" ' total sheets in the regular drawing
NewPropertyNames(29) = "DCN Pages" ' total pages in the DCN
If SheetNames(UBound(SheetNames)) = "DCNSheet2" Then ' If the last sheet in the list is "DCNSheet2", then total number of regular drawing sheets is the total sheet count minus 2. Keep in mind arrays start at zero, not one
    NewPropertyValues(28) = UBound(SheetNames) - 1 ' arrays start at zero, so the total number of drawing sheets is one larger than the upper bound of SheetNames
    NewPropertyValues(29) = 2
Else
    NewPropertyValues(28) = UBound(SheetNames) ' arrays start at zero, so the value of the upper bound of this array is one less than the total number of sheets in the solidworks document.
    NewPropertyValues(29) = 1
End If
NewPropertyTypes(28) = 3
NewPropertyTypes(29) = 3

' This one updates all values to what is shown
For i = 27 To UBound(NewPropertyNames)
    value = propMgr.Add3(NewPropertyNames(i), NewPropertyTypes(i), NewPropertyValues(i), swCustomPropertyAddOption_e.swCustomPropertyReplaceValue) ' adds any custom properties missing
Next i

[josh]

I updated my avatar for you.

Ya still look way too young... :-D I'd card you.

[JSculley]

As for setting the page numbers, I now do it TWO ways. On Checkin, PDM will run a refresh on the page numbers. I also added a macro to do it, whenever someone adds a DCN to the drawing. So, I did it both ways, neither using custom property equations. The Dispatch is shown above, the VBA code is below. This is a snippet of the appropriate portion.

FYI: You can also add a macro feature to your drawing template so that the necessary code will run every time the drawing is rebuilt. A little automation always helps. Users often forget to run macros or follow procedures, etc....