NetOfficeFw / NetOffice

🌌 Create add-ins and automation code for Microsoft Office applications.
MIT License
697 stars 143 forks source link

create vba-style overloads for properties with parameters #41

Closed netoffice-bot closed 6 years ago

netoffice-bot commented 12 years ago

Issue by SebastianDotNet Mon, 09 Jan 2012 22:07:23 GMT Originally opened as https://netoffice.codeplex.com/workitem/17224


properties with parameters are mapped in NetOffice and Interop assemblies as method with "get" or/and "set" prefix. this is very untypical for VBA developers. task: create a mapped method without "get" or/and "set" for the possible scenarios.   the possible scenario is: the property has min. 1 non optional parameter and the property name is not the same as the including type.

netoffice-bot commented 12 years ago

Comment by Tue, 10 Jan 2012 01:27:37 GMT


the following table shows all properties with a prefix on it. these properties have a additional overload without this prefix in new NetOffice release.

Office IAccessible => accChild IAccessible => accName IAccessible => accValue IAccessible => accDescription IAccessible => accRole IAccessible => accState IAccessible => accHelp IAccessible => accHelpTopic IAccessible => accKeyboardShortcut IAccessible => accDefaultAction _CommandBars => Item _CommandBars => IdsString _CommandBars => TmcGetName CommandBar => accChild CommandBar => accName CommandBar => accValue CommandBar => accDescription CommandBar => accRole CommandBar => accState CommandBar => accHelp CommandBar => accHelpTopic CommandBar => accKeyboardShortcut CommandBar => accDefaultAction CommandBarControls => Item CommandBarControl => accChild CommandBarControl => accName CommandBarControl => accValue CommandBarControl => accDescription CommandBarControl => accRole CommandBarControl => accState CommandBarControl => accHelp CommandBarControl => accHelpTopic CommandBarControl => accKeyboardShortcut CommandBarControl => accDefaultAction _CommandBarButton => accChild _CommandBarButton => accName _CommandBarButton => accValue _CommandBarButton => accDescription _CommandBarButton => accRole _CommandBarButton => accState _CommandBarButton => accHelp _CommandBarButton => accHelpTopic _CommandBarButton => accKeyboardShortcut _CommandBarButton => accDefaultAction CommandBarPopup => accChild CommandBarPopup => accName CommandBarPopup => accValue CommandBarPopup => accDescription CommandBarPopup => accRole CommandBarPopup => accState CommandBarPopup => accHelp CommandBarPopup => accHelpTopic CommandBarPopup => accKeyboardShortcut CommandBarPopup => accDefaultAction _CommandBarComboBox => accChild _CommandBarComboBox => accName _CommandBarComboBox => accValue _CommandBarComboBox => accDescription _CommandBarComboBox => accRole _CommandBarComboBox => accState _CommandBarComboBox => accHelp _CommandBarComboBox => accHelpTopic _CommandBarComboBox => accKeyboardShortcut _CommandBarComboBox => accDefaultAction _CommandBarComboBox => List _CommandBarActiveX => accChild _CommandBarActiveX => accName _CommandBarActiveX => accValue _CommandBarActiveX => accDescription _CommandBarActiveX => accRole _CommandBarActiveX => accState _CommandBarActiveX => accHelp _CommandBarActiveX => accHelpTopic _CommandBarActiveX => accKeyboardShortcut _CommandBarActiveX => accDefaultAction _CommandBarActiveX => QueryControlInterface Adjustments => Item BalloonCheckboxes => Item BalloonLabels => Item AnswerWizardFiles => Item IFoundFiles => Item FoundFiles => Item PropertyTests => Item LanguageSettings => LanguageID LanguageSettings => LanguagePreferredForEditing WebPageFonts => Item SignatureSet => Item FileTypes => Item SearchFolders => Item ScopeFolders => Item SearchScopes => Item SharedWorkspaceMembers => Item SharedWorkspaceTasks => Item SharedWorkspaceFiles => Item SharedWorkspaceFolders => Item SharedWorkspaceLinks => Item DocumentLibraryVersions => Item Permission => Item MsoDebugOptions_UTs => Item MetaProperties => Item ServerPolicy => Item DocumentInspectors => Item WorkflowTasks => Item WorkflowTemplates => Item CustomXMLPrefixMappings => Item _CustomXMLSchemaCollection => Item _CustomXMLSchemaCollection => NamespaceURI CustomXMLNodes => Item CustomXMLValidationErrors => Item _CustomXMLParts => Item GradientStops => Item TextRange2 => Paragraphs TextRange2 => Sentences TextRange2 => Words TextRange2 => Characters TextRange2 => Lines TextRange2 => Runs TextRange2 => MathZones IMsoChart => ChartGroups IMsoChart => HasAxis IMsoChart => Walls Axes => Item Axes => _Default IMsoChartTitle => Characters PickerFields => Item PickerProperties => Item PickerResults => Item EffectParameters => Item PictureEffects => Item DocumentProperties => Item LegendEntries => _Default SeriesCollection => _Default Trendlines => _Default IMsoDataLabels => Characters IMsoDataLabels => _Default IMsoDataLabel => Characters Points => _Default Excel Adjustments => Item _Application => Range _Application => ShortcutMenus _Application => Caller _Application => ClipboardFormats _Application => FileConverters _Application => International _Application => PreviousSelections _Application => RegisteredFunctions _Application => FileDialog _Chart => HasAxis Sheets => Item Sheets => _Default _Worksheet => Range _Global => Range _Global => ShortcutMenus _Workbook => Colors Workbooks => Item Workbooks => _Default CubeFields => Item CubeFields => _Default Windows => Item Windows => _Default Range => Address Range => AddressLocal Range => Characters Range => _Default Range => End Range => Item Range => Offset Range => Resize HPageBreaks => Item HPageBreaks => _Default VPageBreaks => Item VPageBreaks => _Default RecentFiles => Item RecentFiles => _Default Styles => Item Styles => _Default Borders => Item Borders => _Default AddIns => Item AddIns => _Default Toolbars => _Default Toolbars => Item ToolbarButtons => Item ToolbarButtons => _Default Areas => Item Areas => _Default MenuBars => _Default MenuBars => Item Menus => _Default Menus => Item MenuItems => _Default MenuItems => Item Charts => Item Charts => _Default DrawingObjects => Characters PivotCaches => _Default PivotFormulas => _Default PivotTable => ColumnFields PivotTable => DataFields PivotTable => HiddenFields PivotTable => PageFields PivotTable => RowFields PivotTable => VisibleFields PivotField => ChildItems PivotField => HiddenItems PivotField => ParentItems PivotField => Subtotals PivotField => VisibleItems CalculatedFields => _Default PivotItem => ChildItems CalculatedItems => _Default Dialogs => Item Dialogs => _Default Button => Characters Buttons => Characters CheckBox => Characters CheckBoxes => Characters OptionButton => Characters OptionButtons => Characters EditBox => Characters EditBoxes => Characters ListBox => List ListBox => Selected ListBoxes => List ListBoxes => Selected GroupBox => Characters GroupBoxes => Characters DropDown => List DropDown => Selected DropDown => Characters DropDowns => List DropDowns => Selected DropDowns => Characters DialogFrame => Characters Label => Characters Labels => Characters Panes => Item Panes => _Default Scenario => Values Rectangle => Characters Rectangles => Characters Oval => Characters Ovals => Characters Arc => Characters Arcs => Characters TextBox => Characters TextBoxes => Characters Drawing => Characters Drawing => Vertices Drawings => Characters RoutingSlip => Recipients Modules => Item Modules => _Default DialogSheets => Item DialogSheets => _Default Worksheets => Item Worksheets => _Default PageSetup => PrintQuality CustomViews => _Default FormatConditions => _Default Comments => _Default QueryTables => _Default Parameters => _Default ODBCErrors => _Default Hyperlinks => Item Hyperlinks => _Default Filters => _Default Filters => Item AutoCorrect => ReplacementList ChartTitle => Characters AxisTitle => Characters DataLabel => Characters Shapes => Range GroupShapes => Range PublishObjects => Item PublishObjects => _Default OLEDBErrors => _Default Phonetics => Item Phonetics => _Default PivotLayout => ColumnFields PivotLayout => DataFields PivotLayout => PageFields PivotLayout => RowFields PivotLayout => HiddenFields PivotLayout => VisibleFields PivotLayout => PivotFields DisplayUnitLabel => Characters UsedObjects => _Default UsedObjects => Item CustomProperties => _Default CustomProperties => Item CalculatedMembers => Item CalculatedMembers => _Default Watches => _Default Watches => Item Errors => Item Errors => _Default SmartTagActions => _Default SmartTagActions => Item SmartTags => _Default SmartTagRecognizers => Item SmartTagRecognizers => _Default PivotItemList => _Default AllowEditRanges => Item AllowEditRanges => _Default UserAccessList => Item UserAccessList => _Default ListObjects => _Default ListObjects => Item ListColumns => _Default ListColumns => Item ListRows => _Default ListRows => Item XmlNamespaces => _Default XmlNamespaces => Item XmlSchemas => _Default XmlSchemas => Item XmlMaps => _Default XmlMaps => Item PivotLineCells => _Default PivotLineCells => Item PivotLines => _Default PivotLines => Item PivotFilters => _Default PivotFilters => Item Connections => _Default SheetViews => Item SheetViews => _Default Actions => _Default Actions => Item ColorScaleCriteria => _Default ColorScaleCriteria => Item IconCriteria => _Default IconCriteria => Item IconSet => _Default IconSet => Item IconSets => _Default IconSets => Item Ranges => _Default Ranges => Item Pages => Item Pages => _Default ServerViewableItems => _Default TableStyleElements => _Default TableStyles => _Default SortFields => Item SortFields => _Default ColorStops => _Default FileExportConverters => _Default FileExportConverters => Item AddIns2 => Item AddIns2 => _Default SparklineGroups => Item SparklineGroups => _Default SparklineGroup => Item PivotTableChangeList => _Default PivotTableChangeList => Item DisplayFormat => Characters SlicerCaches => Item SlicerCaches => _Default SlicerCacheLevels => Item SlicerCacheLevels => _Default Slicers => Item Slicers => _Default SlicerItems => Item SlicerItems => _Default SlicerPivotTables => Item SlicerPivotTables => _Default ProtectedViewWindows => Item ProtectedViewWindows => _Default IWindows => Item IWindows => _Default IRange => Address IRange => AddressLocal IRange => Characters IRange => _Default IRange => End IRange => Item IRange => Offset IRange => Range IRange => Resize IHPageBreaks => Item IHPageBreaks => _Default IVPageBreaks => Item IVPageBreaks => _Default IRecentFiles => Item IRecentFiles => _Default IStyles => Item IStyles => _Default IBorders => Item IBorders => _Default IAddIns => Item IAddIns => _Default IToolbars => _Default IToolbars => Item IToolbarButtons => Item IToolbarButtons => _Default IAreas => Item IAreas => _Default IMenuBars => _Default IMenuBars => Item IMenus => _Default IMenus => Item IMenuItems => _Default IMenuItems => Item ICharts => Item ICharts => _Default IDrawingObjects => Characters IPivotCaches => _Default IPivotFormulas => _Default IPivotTable => ColumnFields IPivotTable => DataFields IPivotTable => HiddenFields IPivotTable => PageFields IPivotTable => RowFields IPivotTable => VisibleFields IPivotField => ChildItems IPivotField => HiddenItems IPivotField => ParentItems IPivotField => Subtotals IPivotField => VisibleItems ICalculatedFields => _Default IPivotItem => ChildItems ICalculatedItems => _Default IDialogs => Item IDialogs => _Default IButton => Characters IButtons => Characters ICheckBox => Characters ICheckBoxes => Characters IOptionButton => Characters IOptionButtons => Characters IEditBox => Characters IEditBoxes => Characters IListBox => List IListBox => Selected IListBoxes => List IListBoxes => Selected IGroupBox => Characters IGroupBoxes => Characters IDropDown => List IDropDown => Selected IDropDown => Characters IDropDowns => List IDropDowns => Selected IDropDowns => Characters IDialogFrame => Characters ILabel => Characters ILabels => Characters IPanes => Item IPanes => _Default IScenario => Values IRectangle => Characters IRectangles => Characters IOval => Characters IOvals => Characters IArc => Characters IArcs => Characters ITextBox => Characters ITextBoxes => Characters IDrawing => Characters IDrawing => Vertices IDrawings => Characters IRoutingSlip => Recipients IModules => Item IModules => _Default IDialogSheets => Item IDialogSheets => _Default IWorksheets => Item IWorksheets => _Default IPageSetup => PrintQuality ICustomViews => _Default IFormatConditions => _Default IComments => _Default IQueryTables => _Default IParameters => _Default IODBCErrors => _Default IHyperlinks => Item IHyperlinks => _Default IFilters => _Default IFilters => Item IAutoCorrect => ReplacementList IChartTitle => Characters IAxisTitle => Characters IDataLabel => Characters IShapes => Range IGroupShapes => Range IPublishObjects => Item IPublishObjects => _Default IOLEDBErrors => _Default IPhonetics => Item IPhonetics => _Default IPivotLayout => ColumnFields IPivotLayout => DataFields IPivotLayout => PageFields IPivotLayout => RowFields IPivotLayout => HiddenFields IPivotLayout => VisibleFields IPivotLayout => PivotFields IDisplayUnitLabel => Characters IUsedObjects => _Default IUsedObjects => Item ICustomProperties => _Default ICustomProperties => Item ICalculatedMembers => Item ICalculatedMembers => _Default IWatches => _Default IWatches => Item IErrors => Item IErrors => _Default ISmartTagActions => _Default ISmartTagActions => Item ISmartTags => _Default ISmartTagRecognizers => Item ISmartTagRecognizers => _Default IPivotItemList => _Default IAllowEditRanges => Item IAllowEditRanges => _Default IUserAccessList => Item IUserAccessList => _Default IListObjects => _Default IListObjects => Item IListColumns => _Default IListColumns => Item IListRows => _Default IListRows => Item IXmlNamespaces => _Default IXmlNamespaces => Item IXmlSchemas => _Default IXmlSchemas => Item IXmlMaps => _Default IXmlMaps => Item IPivotLineCells => _Default IPivotLineCells => Item IPivotLines => _Default IPivotLines => Item IPivotFilters => _Default IPivotFilters => Item IConnections => _Default ISheetViews => Item ISheetViews => _Default IActions => _Default IActions => Item IColorScaleCriteria => _Default IColorScaleCriteria => Item IIconCriteria => _Default IIconCriteria => Item IIconSet => _Default IIconSet => Item IIconSets => _Default IIconSets => Item IRanges => _Default IRanges => Item IPages => Item IPages => _Default IServerViewableItems => _Default ITableStyleElements => _Default ITableStyles => _Default ISortFields => Item ISortFields => _Default IColorStops => _Default IFileExportConverters => _Default IFileExportConverters => Item IAddIns2 => Item IAddIns2 => _Default ISparklineGroups => Item ISparklineGroups => _Default ISparklineGroup => Item IPivotTableChangeList => _Default IPivotTableChangeList => Item IDisplayFormat => Characters ISlicerCaches => Item ISlicerCaches => _Default ISlicerCacheLevels => Item ISlicerCacheLevels => _Default ISlicers => Item ISlicers => _Default ISlicerItems => Item ISlicerItems => _Default ISlicerPivotTables => Item ISlicerPivotTables => _Default IProtectedViewWindows => Item IProtectedViewWindows => _Default VBIDE Events => ReferencesEvents Events => CommandBarEvents Property => IndexedValue _CodeModule => Lines _CodeModule => ProcStartLine _CodeModule => ProcCountLines _CodeModule => ProcBodyLine _CodeModule => ProcOfLine Word _Application => International _Application => SynonymInfo _Application => KeysBoundTo _Application => FindKey _Application => IsObjectValid _Application => FileDialog _Global => SynonymInfo _Global => KeysBoundTo _Global => FindKey _Global => IsObjectValid _Document => Compatibility _Document => ActiveWritingStyle RoutingSlip => Recipients Range => Information Range => XML Paragraph => ListNumberOriginal System => ProfileString System => PrivateProfileString Selection => Information Selection => XML ListGallery => Modified SynonymInfo => SynonymList Options => DefaultFilePath Adjustments => Item ColorFormat => Ink Frameset => ChildFramesetItem XMLNode => XML XMLNode => ValidationErrorText XMLNamespace => Location XMLNamespace => Alias XMLNamespace => DefaultTransform XSLTransform => Alias XSLTransform => Location Source => Field OMathMat => Cell Chart => ChartGroups Chart => HasAxis DataLabel => Characters ChartTitle => Characters AxisTitle => Characters DisplayUnitLabel => Characters PowerPoint _Application => FileDialog Adjustments => Item PPListBox => IsSelected AxisTitle => Characters Chart => HasAxis ChartTitle => Characters DataLabel => Characters DisplayUnitLabel => Characters Access Properties => Item FormatConditions => Item _ItemsSelected => Item Children => Item Pages => Item _Control => Column _Control => Selected _Control => ItemData _Control => ObjectVerbs Controls => Item _BoundObjectFrame => ObjectVerbs _ListBox => Column _ListBox => Selected _ListBox => ItemData _Combobox => Column _Combobox => ItemData _Combobox => Selected _ObjectFrame => ObjectVerbs _CustomControl => ObjectVerbs Module => Lines Module => ProcStartLine Module => ProcCountLines Module => ProcBodyLine Module => ProcOfLine Modules => Item _Form => DefaultControl _Form => Section Forms => Item _Report => DefaultControl _Report => Section _Report => GroupLevel Reports => Item _Application => FileDialog DataAccessPages => Item AllObjects => Item AccessObjectProperties => Item _WizHook => IsMatchToDbcConnectString Printers => Item _Form2 => DefaultControl _Form2 => Section _Report2 => DefaultControl _Report2 => Section _Report2 => GroupLevel _AdditionalData => Item _DependencyObjects => Item _SmartTags => Item _SmartTagActions => Item _SmartTagProperties => Item ImportExportSpecifications => Item _Form3 => DefaultControl _Form3 => _SectionOld _Form3 => Section _Form3 => SectionOld _Report3 => DefaultControl _Report3 => _SectionOld _Report3 => GroupLevel _Report3 => Section _Report3 => SectionOld _Attachment => FileName _Attachment => FileType _Attachment => FileURL _Attachment => FileData _Attachment => PictureDisp _TempVars => Item WebServices => Item Entities => Item Operations => Item WSParameters => Item _LocalVars => Item SharedResources => Item _ReturnVars => Item DAO Properties => Item Workspaces => Item Databases => Item TableDefs => Item Fields => Item Indexes => Item Recordset => Collect Parameters => Item QueryDefs => Item Recordsets => Item Relations => Item Containers => Item Documents => Item Users => Item Groups => Item Connections => Item Errors => Item IndexFields => Item ADODB Properties => Item Errors => Item _Recordset => Collect Recordset15 => Collect Fields => Item Fields15 => Item Parameters => Item Recordset21 => Collect OWC10 ChChartSpace => International ChCharts => Item ChChart => Scalings ChAxes => Item ChCategoryLabels => ItemCount ChCategoryLabels => Item PivotData => Cells PivotData => DetailLeft PivotData => Range PivotData => CellsEx PivotFieldSets => Item PivotFieldSet => FindMember PivotFields => Item PivotField => Subtotals PivotMemberProperties => Item PivotMember => FindMember PivotMember => Path PivotMembers => Item PivotFilterUpdate => StateOf PivotTotals => Item PivotClassFactory => NewDetailCell PivotClassFactory => NewAggregate PivotClassFactory => NewRowMember PivotClassFactory => NewColumnMember PivotClassFactory => NewCell PivotCell => DetailCells PivotCell => DetailRange PivotAggregates => Item PivotRowMember => FindMember PivotRowMember => Path PivotRowMember => FindRowMember PivotAxisMember => FindAxisMember PivotAxisMembers => Item PivotResultMemberProperties => Item PivotRowMembers => Item PivotColumnMember => FindMember PivotColumnMember => Path PivotColumnMember => FindColumnMember PivotColumnMembers => Item PivotPageMember => FindMember PivotPageMember => Path PivotPageMember => FindPageMember PivotPageMembers => Item OCCommands => Item PivotRange => Cells PivotResultGroupFields => Item ChLegendEntries => Item ChSeriesCollection => Item ChSeries => Scalings ChDataLabelsCollection => Item ChDataLabels => Item ChPoints => Item ChPoint => PivotObject ChErrorBarsCollection => Item ChTrendlines => Item ChSegments => Item ChChartFields => Item OWCLanguageSettings => LanguageID OWCLanguageSettings => LanguagePreferredForEditing _Range => _Default _Range => Address _Range => End _Range => Item _Range => Offset _Range => Range _Range => Value ISpreadsheet => International ISpreadsheet => Range Worksheet => Range Filters => Item Criteria => Item Workbook => Colors Sheets => Item Windows => Item Headings => Item Panes => Item Worksheets => Item Workbooks => Item Borders => Item _NumberFormat => Format _NumberFormat => Width _NumberFormat => Height SchemaFields => Item SchemaProperties => Item SchemaRowsources => Item LookupSchemaRelationships => Item SchemaRelatedFields => Item SublistSchemaRelationships => Item SchemaParameters => Item SchemaDiagrams => Item SchemaRelationships => Item PageRowsources => Item RecordsetDef => ShapeText SublistRelationships => Item PageRelatedFields => Item PageFields => Item GroupingDefs => Item ParameterValues => Item LookupRelationships => Item RecordsetDefs => Item AllPageFields => Item AllGroupingDefs => Item GroupLevels => Item DataPages => Item ElementExtensions => Item IDataSourceControl => ProviderType FieldListDragDataList => Item ViewSurface => AlphaBlend ViewSurface => TextHeight ViewSurface => TextWidth ViewSurface => PictureAlphaBlended ViewSurface => ScaleX ViewSurface => ScaleY ViewObject => Query Moniker => Parse MSComctlLib IVBDataObjectFiles => Item ITabs => ControlDefault ITabs => Item IButtons => ControlDefault IButtons => Item IButtonMenus => ControlDefault IButtonMenus => Item IPanels => ControlDefault IPanels => Item INodes => ControlDefault INodes => Item IListItems => ControlDefault IListItems => Item IListItem => SubItems IColumnHeaders => ControlDefault IColumnHeaders => Item IListSubItems => ControlDefault IListSubItems => Item IImages => ControlDefault IImages => Item IControls => Item IComboItems => _CollectionDefault IComboItems => Item MSProject Years => Item Months => Item Days => Item List => Item Subprojects => Item TaskGroups => Item ResourceGroups => Item GroupCriteria => Item WeekDays => Item TimeScaleValues => Item CostRateTables => Item PayRates => Item Availabilities => Item TaskDependencies => Item Windows => Item SplitParts => Item Tasks => UniqueID Tasks => Item Resources => UniqueID Resources => Item Assignments => UniqueID Assignments => Item Calendars => Item _IProjectDoc => BaselineSavedDate Projects => Item _Global => FileFormatID _Global => FileBuildID _MSProject => FileFormatID _MSProject => FileBuildID Groups => Item Views => Item Tables => Item Filters => Item Profiles => Item TableFields => Item OutlineCodes => Item LookupTable => Item CodeMask => Item Windows2 => Item Exceptions => Item WorkWeeks => Item WorkWeekDays => Item ReportTemplates => Item StartDriver => OverAllocatedAssignments StartDriver => EffectiveDateDifference StartDriver => EffectiveDateAdd StartDriver => EffectiveDateSubtract ActualStartDrivers => Item PredecessorDrivers => Item ChildDrivers => Item CalendarDrivers => Item TaskGroups2 => Item ResourceGroups2 => Item GroupCriteria2 => Item Groups2 => Item OverAllocatedAssignments => Item MSHTML Outlook MSDATASRC

netoffice-bot commented 12 years ago

Comment by Tue, 10 Jan 2012 06:51:32 GMT


I don't think the "_Default" members should be exposed.

I don't know what the CommandBar.accXXX entries are. The don't show up in the VBA Intellisense.