Description: https://learn.microsoft.com/en-us/office/vba/api/Excel.Workbook.PrintOut ThisWorkbook.PrintOut , Preview:=True this is the problematic code. Screenshot attached. https://www.teachexcel.com/free-excel-macros/m-64,Complete-Guide-to-Printing-in-Excel-Macros-PrintOut-Method-in-Excel.html try to run this example macro in libreoffice Steps to Reproduce: 1. try to run macro with printout 2. 3. Actual Results: 423 error Expected Results: macro should work as it works in excel Reproducible: Always User Profile Reset: No Additional Info: Version: 7.5.3.2 (X86_64) / LibreOffice Community Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3 CPU threads: 4; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: en-IN (en_IN); UI: en-US Flatpak Calc: threaded
Created attachment 187336 [details] 423 for printout
https://www.exceldemy.com/excel-vba-print-preview/ i downloaded this file https://www.exceldemy.com/wp-content/uploads/2022/02/VBA-Print-Preview.xlsm found out the following ActiveWindow.SelectedSheets.PrintPreview (this works in calc) Worksheets("Specific Sheet").PrintPreview (method or property not found) ActiveSheet.PrintPreview (method or property not found) this is quite a good example of what works and what does not work in calc with regards to the formulae --- Version: 7.5.3.2 (X86_64) / LibreOffice Community Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3 CPU threads: 4; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: en-IN (en_IN); UI: en-US Flatpak Calc: threaded
*** Bug 161314 has been marked as a duplicate of this bug. ***
Created attachment 194430 [details] file containing bug simple code ThisWorkbook.PrintOut , Preview:=True in sheet 4 the file says 423 on this macro but elsewhere it sometimes show 92 error
johnks, reports usually need to be set to "new" by someone other than the report. Setting back to "unconfirmed". Mike, what do you think?
(In reply to Stéphane Guillou (stragu) from comment #5) > Mike, what do you think? Any VBA that works in MS Office, but fails in LibreOffice, is an interoperability bug. Sometimes there might appear a reason to not fix some specific cases of these bugs (but they don't cease to be bugs nonetheless, just may be closed as WONTFIX) - but this is even not that corner case. Just a normal bug. We only have PrintOut defined for several VBA object model objects: https://opengrok.libreoffice.org/search?project=core&full=printout&path=vba%2Fexcel VBA defines it for much larger set of objects: https://learn.microsoft.com/en-us/search/?terms=Excel%20PrintOut Workbook is one of these objects, that misses the method in out code. https://learn.microsoft.com/en-us/office/vba/api/excel.workbook.printout Note that we need separate bugs for different methods. We can't have an actionable "implement perfect VBA support" bug. Please create a similar bug for PrintPreview, and likewise for any other missing object/property/method.