Bug 139508 - ExportAsFixedFormat- basic runtime error '423'
Summary: ExportAsFixedFormat- basic runtime error '423'
Status: RESOLVED DUPLICATE of bug 149786
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
(earliest affected) release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2021-01-09 05:55 UTC by johnks
Modified: 2023-02-15 13:24 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

exportasfixedformat (15.72 KB, application/vnd.ms-excel.sheet.macroEnabled.12)
2021-02-24 05:08 UTC, johnks

Note You need to log in before you can comment on or make changes to this bug.
Description johnks 2021-01-09 05:55:27 UTC
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.

Actual Results:
error message

Expected Results:
macro should export the sheet as a pdf file.

Reproducible: Always

User Profile Reset: No

Additional Info:
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-IN (en_IN); UI: en-US
Calc: threaded
Comment 1 Xisco Faulí 2021-02-23 09:41:55 UTC
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.)
Comment 2 johnks 2021-02-24 05:08:17 UTC
Created attachment 170014 [details]
Comment 3 John 2021-03-03 14:56:40 UTC
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.
Comment 4 Gabor Kelemen (allotropia) 2023-02-07 13:04:56 UTC
Implementation of this is in progress in (newer) bug 149786.

*** This bug has been marked as a duplicate of bug 149786 ***