I'm in the process of redoing the template of my nomenclature and I have a display problem, especially that of my revisions when displaying my nomenclature.
I want my revisions to be displayed in this format: ".00" ".01" etc... As they are displayed in solidworks, SmartBom by the way
But when I generate a nomenclature, they are displayed in this format in my excel file: "0" "0.01" etc...
I tried to change the format ed cell, but it doesn't come from there.
I think it's something to change in the .xml file but I don't know what to add to change the display format.
The trick in Excel is to precede the numerical values that you want to display as text with an apostrophe (number 4 = '). If this apostrophe is included in the template for export, it should work!
Where can I include this apostrophe? In the SmartBom?
EDIT: Indeed, in the SmartBom revision column, when I advance my revisions with an apostrophe, it is displayed in my excel file.
However I am looking for a way for the apostrophe to be displayed automatically with my revisions. It's not practical to think about adding it every time, especially for large assemblies...
Yes, it is possible to add a concatenation in SmartBom. You have to choose "custom properties" in "column type", then in the name of the write property (considering that revision is the name of the revision property):
'&$revision
See Smartbom Help for more information.
Alternatively, you can create a custom property directly in SolidWorks that would be a concatenation of the apostrophe and the revision property. And it is this additional property that we would use for the column in SmartBom.
It is the grouping of several properties into one. So if you need to produce a property with the project name followed by the thickness and the file name, Come and see the trick to group these properties into one.
However, when I fill in the "default value" field, the characters don't stay displayed, I don't know how to somehow save, since when I exit the property window of my column and enter it, the field I just filled in is empty again...
EDIT: I even tried to save it in my .xml file between the "default value" tags but it doesn't work either.
EDIT 2: IT'S GOOD! It was in the "property name" box that the field should be entered and not in the "default value" box. Thank you very much!!
One last question, I would like a formula so that it does not display "Material <not specified>" in my excel column when the material is not filled in solidworks.
I think I should put this formula (according to the help of the SmartBom): IFF($Mat eriau=Material <unspecified>| but it doesn't work, I think I have to use a term to inform it that I want a "void" (no characters) after the bar...
When you say "However, when I fill in the "default value" field, the characters do not remain displayed, what is the window in? SolidWorks? SmartProperties or smart bom?