Description: i have a simple excel macro. this is throwing 423 basic runtime error and not running. > Option VBASupport 1 Public Sub printplt1_click() Dim pdf_template As Worksheet Set pdf_template = ActiveSheet Dim wb As Workbook Set wb = ActiveWorkbook Dim ws As Worksheet If Dir(wb.Path & "\" & "export", vbDirectory) = "" Then MkDir (wb.Path & "\" & "export") End If pdf_template.ExportAsFixedFormat Type:=xlTypePDF, _ Filename:=wb.Path & "\" & "export" & "\" & "pdf" & ".pdf", _ Quality:=xlQualityStandard, IncludeDocProperties:=True, _ IgnorePrintAreas:=False, OpenAfterPublish:=False End Sub Steps to Reproduce: 1. save this macro in a file and run macro. 2. 3. Actual Results: error message Expected Results: macro should export the sheet as a pdf file. Reproducible: Always User Profile Reset: No Additional Info: Version: 7.0.4.2 Build ID: dcf040e67528d9187c66b2379df5ea4407429775 CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-IN (en_IN); UI: en-US Flatpak Calc: threaded
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Created attachment 170014 [details] exportasfixedformat
423 is method-not-found, and I verified in gdb the method in question is actually ExportAsFixedFormat itself. Object model documentation and OpenGrok concur: it simply isn't implemented. In my opinion this ticket should be phrased as an enhancement: please implement ExportAsFixedFormat in the object model exposed to macros.
Implementation of this is in progress in (newer) bug 149786. *** This bug has been marked as a duplicate of bug 149786 ***