https://bugs.documentfoundation.org/show_bug.cgi?id=149786
Óvári <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #3 from Óvári <[email protected]> --- (In reply to m.a.riosv from comment #2) Thank you for your response. At “Projects selected for LibreOffice in the Google Summer of Code 2022” https://blog.documentfoundation.org/blog/2022/05/26/projects-selected-for-libreoffice-in-the-google-summer-of-code-2022/ Ilmari Lauhakangas wrote: I think the best way is to create a new bug report for each missing function and add 108908 to the “Blocks” field. To see what is already covered in the bug tracker, see the dependency tree of the meta bug: https://bugs.documentfoundation.org/showdependencytree.cgi?id=108908&hide_resolved=1 Isn’t “ExportAsFixedFormat” a missing function in LO VBA compatibility? Saving (or exporting) as PDF does not require a virtual PDF printer driver to be installed. LibreOffice Calc → Menu Bar → File → Export as PDF… enables PDFs to be created without using a virtual PDF printer. LibreOffice VBA compatibility support printing to a printer; however, VBA compatibility does not currently support PDF exporting. Surely this is a feature that is required as more processes become digitised? It seems that the VBA syntax of the “ExportAsFixedFormat” method is generally as follows: expression.ExportAsFixedFormat (Type, Filename, Quality, IncludeDocProperties, IgnorePrintAreas, From, To, OpenAfterPublish) Internet search of “vba export as pdf” finds pages like: Excel VBA Save As PDF: Step-By-Step Guide And 10 Code Examples To Export Excel To PDF https://powerspreadsheets.com/save-excel-file-pdf-vba/ Excel VBA to Export Selected Sheets to PDF https://stackoverflow.com/questions/20750854/excel-vba-to-export-selected-sheets-to-pdf Save Excel as PDF with VBA https://exceloffthegrid.com/vba-code-save-excel-file-as-pdf/ Can the status of this issue please be set to NEW? Thank you -- You are receiving this mail because: You are the assignee for the bug.
