topic Re: Set Number Format on a layer attribute table in ArcGIS Pro SDK Questions

Set Number Format on a layer attribute table

KarlBeal — Fri, 15 Dec 2023 03:59:03 GMT

I have a layer feature table with fields joined from a plugin datasource. How can I programmatically change the number format on a joined field?

Re: Set Number Format on a layer attribute table

GKmieliauskas — Tue, 19 Dec 2023 11:39:25 GMT

Hi,

You need to set NumberFormat property in layer field description:

var fieldDescriptions = featureLayer.GetFieldDescriptions(); foreach (var fieldDescr in fieldDescriptions) { if (!fieldDescr.IsVisible || fieldDescr.Name == shapeField) continue; if(fieldDescr.Type == FieldType.Integer) { var custNumbFormat = new CIMCustomNumberFormat(); custNumbFormat.FormatString = "###-##-####"; fieldDescr.NumberFormat = custNumbFormat; } } featureLayer.SetFieldDescriptions(fieldDescriptions);

Re: Set Number Format on a layer attribute table

KarlBeal — Tue, 19 Dec 2023 02:45:27 GMT

The code shown below is after a join. I do not see a change to the formatting in the attribute table after this executes.

var layerDef = layer.GetDefinition() as CIMFeatureLayer; JoinLibrary.UpdateJoinTable(layerDef, oldTableName, newTableName); // setup join here layer.SetDefinition(layerDef); // Attempt to update numeric format var fieldDescriptions = layer.GetFieldDescriptions(); foreach (var fieldDescr in fieldDescriptions) { if (fieldDescr.Type == ArcGIS.Core.Data.FieldType.Double) { var custNumbFormat = new CIMNumericFormat(); custNumbFormat.ZeroPad = true; custNumbFormat.RoundingValue = 6; fieldDescr.NumberFormat = custNumbFormat; } }

Re: Set Number Format on a layer attribute table

GKmieliauskas — Tue, 19 Dec 2023 06:00:50 GMT

You need to set back field descriptions after modifying using SetFieldDescriptions method.

Re: Set Number Format on a layer attribute table

KarlBeal — Tue, 19 Dec 2023 16:10:46 GMT

Apologies I missed that line in your original post. Works as expected now.