Ejemplo n.º 1
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="sh"></param>
        /// <param name="target"></param>
        public void SheetPivotTableChangeSync([In, MarshalAs(UnmanagedType.IDispatch)] object sh, [In, MarshalAs(UnmanagedType.IDispatch)] object target)
        {
            if (!Validate("SheetPivotTableBeforeAllocateChanges"))
            {
                Invoker.ReleaseParamsArray(sh, target);
                return;
            }

            object newSh = Factory.CreateEventArgumentObjectFromComProxy(EventClass, sh) as object;

            NetOffice.ExcelApi.PivotTable newTarget = Factory.CreateKnownObjectFromComProxy <NetOffice.ExcelApi.PivotTable>(EventClass, target, typeof(NetOffice.ExcelApi.PivotTable));
            object[] paramsArray = new object[2];
            paramsArray[0] = newSh;
            paramsArray[1] = newTarget;
            EventBinding.RaiseCustomEvent("SheetPivotTableChangeSync", ref paramsArray);
        }
Ejemplo n.º 2
0
        public void PivotTableAfterValueChange([In, MarshalAs(UnmanagedType.IDispatch)] object targetPivotTable, [In, MarshalAs(UnmanagedType.IDispatch)] object targetRange)
        {
            Delegate[] recipients = _eventBinding.GetEventRecipients("PivotTableAfterValueChange");
            if ((true == _eventClass.IsCurrentlyDisposing) || (recipients.Length == 0))
            {
                Invoker.ReleaseParamsArray(targetPivotTable, targetRange);
                return;
            }

            NetOffice.ExcelApi.PivotTable newTargetPivotTable = Factory.CreateObjectFromComProxy(_eventClass, targetPivotTable) as NetOffice.ExcelApi.PivotTable;
            NetOffice.ExcelApi.Range      newTargetRange      = Factory.CreateObjectFromComProxy(_eventClass, targetRange) as NetOffice.ExcelApi.Range;
            object[] paramsArray = new object[2];
            paramsArray[0] = newTargetPivotTable;
            paramsArray[1] = newTargetRange;
            _eventBinding.RaiseCustomEvent("PivotTableAfterValueChange", ref paramsArray);
        }
Ejemplo n.º 3
0
        public void SheetPivotTableChangeSync([In, MarshalAs(UnmanagedType.IDispatch)] object sh, [In, MarshalAs(UnmanagedType.IDispatch)] object target)
        {
            Delegate[] recipients = _eventBinding.GetEventRecipients("SheetPivotTableChangeSync");
            if ((true == _eventClass.IsCurrentlyDisposing) || (recipients.Length == 0))
            {
                Invoker.ReleaseParamsArray(sh, target);
                return;
            }

            object newSh = NetOffice.Factory.CreateObjectFromComProxy(_eventClass, sh) as object;

            NetOffice.ExcelApi.PivotTable newTarget = NetOffice.Factory.CreateObjectFromComProxy(_eventClass, target) as NetOffice.ExcelApi.PivotTable;
            object[] paramsArray = new object[2];
            paramsArray[0] = newSh;
            paramsArray[1] = newTarget;
            _eventBinding.RaiseCustomEvent("SheetPivotTableChangeSync", ref paramsArray);
        }
Ejemplo n.º 4
0
        public void SheetPivotTableAfterValueChange([In, MarshalAs(UnmanagedType.IDispatch)] object sh, [In, MarshalAs(UnmanagedType.IDispatch)] object targetPivotTable, [In, MarshalAs(UnmanagedType.IDispatch)] object targetRange)
        {
            if (!Validate("SheetPivotTableAfterValueChange"))
            {
                Invoker.ReleaseParamsArray(sh, targetPivotTable, targetRange);
                return;
            }

            object newSh = Factory.CreateEventArgumentObjectFromComProxy(EventClass, sh) as object;

            NetOffice.ExcelApi.PivotTable newTargetPivotTable = Factory.CreateKnownObjectFromComProxy <NetOffice.ExcelApi.PivotTable>(EventClass, targetPivotTable, NetOffice.ExcelApi.PivotTable.LateBindingApiWrapperType);
            NetOffice.ExcelApi.Range      newTargetRange      = Factory.CreateKnownObjectFromComProxy <NetOffice.ExcelApi.Range>(EventClass, targetRange, NetOffice.ExcelApi.Range.LateBindingApiWrapperType);
            object[] paramsArray = new object[3];
            paramsArray[0] = newSh;
            paramsArray[1] = newTargetPivotTable;
            paramsArray[2] = newTargetRange;
            EventBinding.RaiseCustomEvent("SheetPivotTableAfterValueChange", ref paramsArray);
        }
Ejemplo n.º 5
0
        public void PivotTableBeforeDiscardChanges([In, MarshalAs(UnmanagedType.IDispatch)] object targetPivotTable, [In] object valueChangeStart, [In] object valueChangeEnd)
        {
            if (!Validate("PivotTableBeforeDiscardChanges"))
            {
                Invoker.ReleaseParamsArray(targetPivotTable, valueChangeStart, valueChangeEnd);
                return;
            }

            NetOffice.ExcelApi.PivotTable newTargetPivotTable = Factory.CreateKnownObjectFromComProxy <NetOffice.ExcelApi.PivotTable>(EventClass, targetPivotTable, NetOffice.ExcelApi.PivotTable.LateBindingApiWrapperType);
            Int32 newValueChangeStart = Convert.ToInt32(valueChangeStart);
            Int32 newValueChangeEnd   = Convert.ToInt32(valueChangeEnd);

            object[] paramsArray = new object[3];
            paramsArray[0] = newTargetPivotTable;
            paramsArray[1] = newValueChangeStart;
            paramsArray[2] = newValueChangeEnd;
            EventBinding.RaiseCustomEvent("PivotTableBeforeDiscardChanges", ref paramsArray);
        }
Ejemplo n.º 6
0
        public void PivotTableBeforeDiscardChanges([In, MarshalAs(UnmanagedType.IDispatch)] object targetPivotTable, [In] object valueChangeStart, [In] object valueChangeEnd)
        {
            Delegate[] recipients = _eventBinding.GetEventRecipients("PivotTableBeforeDiscardChanges");
            if ((true == _eventClass.IsCurrentlyDisposing) || (recipients.Length == 0))
            {
                Invoker.ReleaseParamsArray(targetPivotTable, valueChangeStart, valueChangeEnd);
                return;
            }

            NetOffice.ExcelApi.PivotTable newTargetPivotTable = Factory.CreateObjectFromComProxy(_eventClass, targetPivotTable) as NetOffice.ExcelApi.PivotTable;
            Int32 newValueChangeStart = Convert.ToInt32(valueChangeStart);
            Int32 newValueChangeEnd   = Convert.ToInt32(valueChangeEnd);

            object[] paramsArray = new object[3];
            paramsArray[0] = newTargetPivotTable;
            paramsArray[1] = newValueChangeStart;
            paramsArray[2] = newValueChangeEnd;
            _eventBinding.RaiseCustomEvent("PivotTableBeforeDiscardChanges", ref paramsArray);
        }
Ejemplo n.º 7
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="sh"></param>
        /// <param name="targetPivotTable"></param>
        /// <param name="valueChangeStart"></param>
        /// <param name="valueChangeEnd"></param>
        public void SheetPivotTableBeforeDiscardChanges([In, MarshalAs(UnmanagedType.IDispatch)] object sh, [In, MarshalAs(UnmanagedType.IDispatch)] object targetPivotTable, [In] object valueChangeStart, [In] object valueChangeEnd)
        {
            if (!Validate("SheetPivotTableBeforeAllocateChanges"))
            {
                Invoker.ReleaseParamsArray(sh, targetPivotTable, valueChangeStart, valueChangeEnd);
                return;
            }

            object newSh = Factory.CreateEventArgumentObjectFromComProxy(EventClass, sh) as object;

            NetOffice.ExcelApi.PivotTable newTargetPivotTable = Factory.CreateKnownObjectFromComProxy <NetOffice.ExcelApi.PivotTable>(EventClass, targetPivotTable, typeof(NetOffice.ExcelApi.PivotTable));
            Int32 newValueChangeStart = ToInt32(valueChangeStart);
            Int32 newValueChangeEnd   = ToInt32(valueChangeEnd);

            object[] paramsArray = new object[4];
            paramsArray[0] = newSh;
            paramsArray[1] = newTargetPivotTable;
            paramsArray[2] = newValueChangeStart;
            paramsArray[3] = newValueChangeEnd;
            EventBinding.RaiseCustomEvent("SheetPivotTableBeforeDiscardChanges", ref paramsArray);
        }
Ejemplo n.º 8
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="targetPivotTable"></param>
        /// <param name="valueChangeStart"></param>
        /// <param name="valueChangeEnd"></param>
        /// <param name="cancel"></param>
        public void PivotTableBeforeCommitChanges([In, MarshalAs(UnmanagedType.IDispatch)] object targetPivotTable, [In] object valueChangeStart, [In] object valueChangeEnd, [In][Out] ref object cancel)
        {
            if (!Validate("PivotTableBeforeCommitChanges"))
            {
                Invoker.ReleaseParamsArray(targetPivotTable, valueChangeStart, valueChangeEnd, cancel);
                return;
            }

            NetOffice.ExcelApi.PivotTable newTargetPivotTable = Factory.CreateKnownObjectFromComProxy <NetOffice.ExcelApi.PivotTable>(EventClass, targetPivotTable, typeof(NetOffice.ExcelApi.PivotTable));
            Int32 newValueChangeStart = Convert.ToInt32(valueChangeStart);
            Int32 newValueChangeEnd   = Convert.ToInt32(valueChangeEnd);

            object[] paramsArray = new object[4];
            paramsArray[0] = newTargetPivotTable;
            paramsArray[1] = newValueChangeStart;
            paramsArray[2] = newValueChangeEnd;
            paramsArray.SetValue(cancel, 3);
            EventBinding.RaiseCustomEvent("PivotTableBeforeCommitChanges", ref paramsArray);

            cancel = ToBoolean(paramsArray[3]);
        }
Ejemplo n.º 9
0
        public void SheetPivotTableBeforeCommitChanges([In, MarshalAs(UnmanagedType.IDispatch)] object sh, [In, MarshalAs(UnmanagedType.IDispatch)] object targetPivotTable, [In] object valueChangeStart, [In] object valueChangeEnd, [In][Out] ref object cancel)
        {
            if (!Validate("SheetPivotTableBeforeAllocateChanges"))
            {
                Invoker.ReleaseParamsArray(sh, targetPivotTable, valueChangeStart, valueChangeEnd, cancel);
                return;
            }

            object newSh = Factory.CreateEventArgumentObjectFromComProxy(EventClass, sh) as object;

            NetOffice.ExcelApi.PivotTable newTargetPivotTable = Factory.CreateKnownObjectFromComProxy <NetOffice.ExcelApi.PivotTable>(EventClass, targetPivotTable, NetOffice.ExcelApi.PivotTable.LateBindingApiWrapperType);
            Int32 newValueChangeStart = ToInt32(valueChangeStart);
            Int32 newValueChangeEnd   = ToInt32(valueChangeEnd);

            object[] paramsArray = new object[5];
            paramsArray[0] = newSh;
            paramsArray[1] = newTargetPivotTable;
            paramsArray[2] = newValueChangeStart;
            paramsArray[3] = newValueChangeEnd;
            paramsArray.SetValue(cancel, 4);
            EventBinding.RaiseCustomEvent("SheetPivotTableBeforeCommitChanges", ref paramsArray);

            cancel = ToBoolean(paramsArray[4]);
        }
Ejemplo n.º 10
0
 public Int32 SheetPivotTableBeforeCommitChanges(object sh, NetOffice.ExcelApi.PivotTable targetPivotTable, Int32 valueChangeStart, Int32 valueChangeEnd, bool cancel)
 {
     return(Factory.ExecuteInt32MethodGet(this, "SheetPivotTableBeforeCommitChanges", new object[] { sh, targetPivotTable, valueChangeStart, valueChangeEnd, cancel }));
 }
Ejemplo n.º 11
0
 public Int32 PivotTableOpenConnection(NetOffice.ExcelApi.PivotTable target)
 {
     return(Factory.ExecuteInt32MethodGet(this, "PivotTableOpenConnection", target));
 }
Ejemplo n.º 12
0
 public Int32 SheetPivotTableAfterValueChange(object sh, NetOffice.ExcelApi.PivotTable targetPivotTable, NetOffice.ExcelApi.Range targetRange)
 {
     return(Factory.ExecuteInt32MethodGet(this, "SheetPivotTableAfterValueChange", sh, targetPivotTable, targetRange));
 }
Ejemplo n.º 13
0
 public Int32 SheetPivotTableBeforeDiscardChanges(object sh, NetOffice.ExcelApi.PivotTable targetPivotTable, Int32 valueChangeStart, Int32 valueChangeEnd)
 {
     return(Factory.ExecuteInt32MethodGet(this, "SheetPivotTableBeforeDiscardChanges", sh, targetPivotTable, valueChangeStart, valueChangeEnd));
 }
Ejemplo n.º 14
0
        public Int32 WorkbookPivotTableOpenConnection(NetOffice.ExcelApi.Workbook wb, NetOffice.ExcelApi.PivotTable target)
        {
            object[] paramsArray = Invoker.ValidateParamsArray(wb, target);
            object   returnItem  = Invoker.MethodReturn(this, "WorkbookPivotTableOpenConnection", paramsArray);

            return(NetRuntimeSystem.Convert.ToInt32(returnItem));
        }
Ejemplo n.º 15
0
 public Int32 PivotTableChangeSync(NetOffice.ExcelApi.PivotTable target)
 {
     return(Factory.ExecuteInt32MethodGet(this, "PivotTableChangeSync", target));
 }
Ejemplo n.º 16
0
 public Int32 PivotTableBeforeCommitChanges(NetOffice.ExcelApi.PivotTable targetPivotTable, Int32 valueChangeStart, Int32 valueChangeEnd, bool cancel)
 {
     return(Factory.ExecuteInt32MethodGet(this, "PivotTableBeforeCommitChanges", targetPivotTable, valueChangeStart, valueChangeEnd, cancel));
 }
Ejemplo n.º 17
0
 public Int32 WorkbookPivotTableOpenConnection(NetOffice.ExcelApi.Workbook wb, NetOffice.ExcelApi.PivotTable target)
 {
     return(Factory.ExecuteInt32MethodGet(this, "WorkbookPivotTableOpenConnection", wb, target));
 }
Ejemplo n.º 18
0
 public Int32 SheetPivotTableChangeSync(object sh, NetOffice.ExcelApi.PivotTable target)
 {
     return(Factory.ExecuteInt32MethodGet(this, "SheetPivotTableChangeSync", sh, target));
 }
Ejemplo n.º 19
0
 public Int32 PivotTableUpdate(NetOffice.ExcelApi.PivotTable target)
 {
     return(Factory.ExecuteInt32MethodGet(this, "PivotTableUpdate", target));
 }