0 Replies Latest reply: Feb 26, 2013 11:21 AM by Andrew Fearn RSS

    Number Format Types

    Andrew Fearn

      Hi

       

      Can someone please help me, I am trying to dynamically set the number format of an expression in a chart

       

      Similar to:

       


       

          expItem.Label.v = ActiveDocument.fields(ViewMode&"PivotEx").GetPossibleValues.Item(0).Text

                    expItem.NumAdjust = 2    'right align

                    expItem.TextAdjust = 2

                          expItem.LabelAdjust = 2    'right align

                   

                    set expItem = p.Expressions.Item(i).Item(0).Data.ExpressionVisual.NumberPresentation

                   

                    ' Set the number format

                    select case ActiveDocument.fields(ViewMode&"PivotType").GetPossibleValues.Item(0).Text

                          case "Decimal"

                                    expItem.Dec = "."

                                    expItem.Fmt = "#,##0.00"

                                    expItem.nDec = 2

                                    expItem.Thou = ","

                                    expItem.Type = 11     'fixed decimal

                                    expItem.UseThou = 1

                          case "Integer"

                                    expItem.Fmt = "#,##0"

                                    expItem.Thou = ","

                                    expItem.Type = 10     'integer

                                    expItem.UseThou = 1


       

      I was wondering if how to find a list of values for expItem.Type, I coudn't find this info from the API guide.

       

      I actually need to set the type to interval

       

      Thanks

       

      Andy