NetOfficeFw / NetOffice

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

More method overloads #40

Closed netoffice-bot closed 6 years ago

netoffice-bot commented 12 years ago

Issue by SebastianDotNet Mon, 09 Jan 2012 22:00:26 GMT Originally opened as https://netoffice.codeplex.com/workitem/17223


a lot of methods has parameter with default values, these parameter are not marked as optional parameters in COM Type Library but there are optional in reality. NetOffice doesnt support additional overloads for these methods currently and a client must give all parameters or Missing.Value. task: create overloads for these methods.

netoffice-bot commented 12 years ago

Comment by Tue, 10 Jan 2012 01:17:28 GMT


the following table shows all methods with one or more parameters there have a default value.

Office FreeformBuilder => AddNodes ShapeNodes => Insert Scripts => Add Shape => ScaleHeight ShapeRange => ScaleHeight Shapes => AddPicture PropertyTests => Add FileSearch => Execute HTMLProjectItem => Open HTMLProject => RefreshProject DiagramNodeChildren => AddNode DiagramNode => AddNode CanvasShapes => AddPicture OfficeDataSourceObject => Move ODSOFilters => Add ILicWizExternal => FormatDate IMsoEServicesDialog => Close SmartDocument => PickSolution _CustomXMLSchemaCollection => Add CustomXMLNode => AppendChildNode CustomXMLValidationErrors => Add _CustomXMLPart => AddNode _CustomXMLParts => Add GradientStops => Delete TextRange2 => InsertAfter IAssistance => ShowHelp IMsoChart => _ApplyDataLabels SmartArtNode => AddNode PickerResults => Add PickerDialog => Show PictureEffects => Insert ContactCard => Show Excel ShapeNodes => Insert _Chart => ApplyDataLabels Sheets => FillAcrossSheets _Workbook => ChangeLink Workbooks => _OpenText Windows => Arrange Range => ApplyNames DrawingObjects => CopyPicture PivotTable => PivotSelect Button => CopyPicture Buttons => CopyPicture CheckBox => CopyPicture CheckBoxes => CopyPicture OptionButton => CopyPicture OptionButtons => CopyPicture EditBox => CopyPicture EditBoxes => CopyPicture ScrollBar => CopyPicture ScrollBars => CopyPicture ListBox => CopyPicture ListBoxes => CopyPicture GroupBox => CopyPicture GroupBoxes => CopyPicture DropDown => CopyPicture DropDowns => CopyPicture Spinner => CopyPicture Spinners => CopyPicture DialogFrame => CopyPicture Label => CopyPicture Labels => CopyPicture Scenarios => CreateSummary GroupObject => CopyPicture GroupObjects => CopyPicture Line => CopyPicture Lines => CopyPicture Rectangle => CopyPicture Rectangles => CopyPicture Oval => CopyPicture Ovals => CopyPicture Arc => CopyPicture Arcs => CopyPicture _OLEObject => CopyPicture OLEObjects => CopyPicture TextBox => CopyPicture TextBoxes => CopyPicture Picture => CopyPicture Pictures => CopyPicture Drawing => CopyPicture Drawings => CopyPicture Worksheets => FillAcrossSheets ChartObject => CopyPicture ChartObjects => CopyPicture Axes => Item Point => ApplyDataLabels Series => ApplyDataLabels SeriesCollection => Add Trendlines => Add DiagramNodeChildren => AddNode DiagramNode => AddNode ListObjects => Add ListObject => UpdateChanges VBIDE _VBComponents => AddMTDesigner _CodeModule => DeleteLines Word _Application => Keyboard Documents => AddBlogDocument _Document => CheckIn Range => PhoneticGuide Paragraph => ListAdvanceTo Selection => ExportAsFixedFormat Shapes => AddChart ShapeRange => ScaleHeight Shape => ScaleHeight InlineShapes => AddChart FreeformBuilder => AddNodes ShapeNodes => Insert DiagramNode => AddNode DiagramNodeChildren => AddNode XMLNode => SelectSingleNode XMLSchemaReferences => Add XMLNamespaces => Add XSLTransforms => Add ContentControls => Add ContentControl => Delete XMLMapping => SetMapping ContentControlListEntries => Add BuildingBlocks => Add BuildingBlockEntries => Add Research => Query Chart => ApplyDataLabels SeriesCollection => Add Series => ApplyDataLabels Trendlines => Add Point => ApplyDataLabels Axes => Item UndoRecord => StartCustomRecord CoAuthLocks => Add PowerPoint _Application => Help DocumentWindows => Arrange DocumentWindow => LargeScroll View => PasteSpecial SlideShowView => GotoSlide Presentations => Add Slides => InsertFromFile _Slide => Export SlideRange => Export ColorSchemes => Add Shapes => AddPicture FreeformBuilder => AddNodes Shape => ScaleHeight ShapeRange => ScaleHeight ShapeNodes => Insert OLEFormat => DoVerb TextRange => Paragraphs _Presentation => FollowHyperlink PPDialogs => AddDialog FileDialog => Launch Table => ApplyStyle Columns => Add Rows => Add Designs => Add DiagramNode => AddNode DiagramNodeChildren => AddNode Sequences => Add Sequence => AddEffect AnimationBehaviors => Add AnimationPoints => Add CanvasShapes => AddPicture CustomLayouts => Paste Research => Query Axes => Item Chart => ApplyDataLabels Point => _ApplyDataLabels Series => _ApplyDataLabels SeriesCollection => Add Trendlines => Add MediaFormat => Resample ProtectedViewWindows => Open ProtectedViewWindow => Edit Access DoCmd => Close _FormatCondition => Modify FormatConditions => Add _Hyperlink => Follow Module => Find _Form => GoToPage _Application => OpenCurrentDatabase _Form2 => GoToPage _Form3 => GoToPage Operation => Execute DAO _DBEngine => CommitTrans Workspace => CommitTrans Database => CommitTrans Recordset => CancelUpdate ADODB Command15 => Execute Connection15 => Execute _Recordset => Delete Recordset20 => Save Recordset15 => Delete Fields => Append Recordset21 => Delete Fields20 => _Append _Record => MoveRecord _Stream => Read OWC10 ChInterior => SetTextured ChChartSpace => ExportPicture ChCharts => Add ChChart => SetSpreadsheetData PivotData => MoveTop PivotView => AutoLayout PivotFieldSet => AddCustomGroupField PivotField => AddCustomGroupMember PivotAxis => InsertFieldSet IPivotControl => Export PivotCell => MoveDetailTop PivotHyperlink => Follow PivotColumnMember => MoveDetailLeft ChSeriesCollection => Add ChSeries => Ungroup _Range => BorderAround ISpreadsheet => EndUndo PageFields => Add Section => MakeCurrent GroupLevels => Add ElementExtensions => Add IDataSourceControl => Execute IPivotCopy => Render MSProject Task => TimeScaleData Resource => TimeScaleData Assignment => TimeScaleData GroupCriteria => Add TaskDependencies => Add _IProjectDoc => SaveAs _Global => Quit _MSProject => Quit ViewsSingle => Add ViewsCombination => Add Tables => Add Filter => Apply Profiles => Add TableFields => Add CodeMask => Add GroupCriteria2 => Add MSHTML IHTMLElement => setAttribute IHTMLStyle => setAttribute IHTMLStyle2 => setExpression IHTMLRuleStyle => setAttribute DispHTMLStyle => setAttribute DispHTMLRuleStyle => setAttribute IHTMLCurrentStyle => getAttribute DispHTMLCurrentStyle => getAttribute IHTMLDOMNode => removeNode DispHTMLDOMTextNode => removeNode IHTMLElement2 => setCapture DispHTMLGenericElement => setAttribute IHTMLStyleSheet => addImport IHTMLStyleSheet2 => addPageRule DispHTMLStyleSheet => addImport DispHTMLLinkElement => setAttribute IHTMLTxtRange => scrollIntoView IHTMLSubmitData => appendNameValuePair DispHTMLFormElement => setAttribute DispHTMLTextElement => setAttribute IHTMLControlRange => execCommand DispHTMLImg => setAttribute DispHTMLBody => setAttribute DispHTMLFontElement => setAttribute DispHTMLAnchorElement => setAttribute DispHTMLLabelElement => setAttribute DispHTMLListElement => setAttribute DispHTMLUListElement => setAttribute DispHTMLOListElement => setAttribute DispHTMLLIElement => setAttribute DispHTMLBlockElement => setAttribute DispHTMLDivElement => setAttribute DispHTMLDDElement => setAttribute DispHTMLDTElement => setAttribute DispHTMLBRElement => setAttribute DispHTMLDListElement => setAttribute DispHTMLHRElement => setAttribute DispHTMLParaElement => setAttribute DispHTMLHeaderElement => setAttribute IHTMLSelectElement => remove DispHTMLSelectElement => setAttribute DispHTMLWndSelectElement => setAttribute DispHTMLOptionElement => setAttribute DispHTMLWndOptionElement => setAttribute DispHTMLInputElement => setAttribute DispHTMLTextAreaElement => setAttribute DispHTMLRichtextElement => setAttribute DispHTMLButtonElement => setAttribute DispHTMLMarqueeElement => setAttribute DispHTMLHtmlElement => setAttribute DispHTMLHeadElement => setAttribute DispHTMLTitleElement => setAttribute DispHTMLMetaElement => setAttribute DispHTMLBaseElement => setAttribute DispHTMLIsIndexElement => setAttribute DispHTMLNextIdElement => setAttribute DispHTMLBaseFontElement => setAttribute DispHTMLUnknownElement => setAttribute IHTMLPluginsCollection => refresh IHTMLLocation => reload IHTMLEventObj2 => setAttribute DispCEventObj => setAttribute IHTMLDocument2 => open IHTMLWindow2 => alert IHTMLWindow3 => showModelessDialog DispHTMLWindow2 => alert DispHTMLWindowProxy => alert IHTMLDocument3 => recalc DispHTMLDocument => open DispHTMLEmbed => setAttribute IHTMLAreasCollection => remove DispHTMLAreasCollection => remove DispHTMLMapElement => setAttribute DispHTMLAreaElement => setAttribute DispHTMLTableCaption => setAttribute DispHTMLCommentElement => setAttribute DispHTMLPhraseElement => setAttribute DispHTMLSpanElement => setAttribute IHTMLTableSection => insertRow IHTMLTable => insertRow IHTMLTable2 => moveRow IHTMLTableSection2 => moveRow IHTMLTableRow => insertCell DispHTMLTable => setAttribute DispHTMLTableCol => setAttribute DispHTMLTableSection => setAttribute DispHTMLTableRow => setAttribute DispHTMLTableCell => setAttribute DispHTMLScriptElement => setAttribute DispHTMLNoShowElement => setAttribute DispHTMLObjectElement => setAttribute DispHTMLParamElement => setAttribute DispHTMLFrameBase => setAttribute DispHTMLFrameElement => setAttribute DispHTMLIFrame => setAttribute DispHTMLDivPosition => setAttribute DispHTMLFieldSetElement => setAttribute DispHTMLLegendElement => setAttribute DispHTMLSpanFlow => setAttribute DispHTMLFrameSetSite => setAttribute DispHTMLBGsound => setAttribute DispHTMLStyleElement => setAttribute DispIHTMLInputButtonElement => setAttribute DispIHTMLInputTextElement => setAttribute DispIHTMLInputFileElement => setAttribute DispIHTMLOptionButtonElement => setAttribute DispIHTMLInputImage => setAttribute Outlook MSDATASRC MSComctlLib

netoffice-bot commented 12 years ago

Comment by Tue, 10 Jan 2012 06:53:34 GMT


I don't see the DAO REcordset.Update on the list.

netoffice-bot commented 12 years ago

Comment by Tue, 10 Jan 2012 10:16:39 GMT


OK - the Recordset.Update was fixed up in the 1.4 preview release. So I'm happy with this.