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