Description: ThisWorkbook.PrintOut , Preview:=True this code is not working in calc Steps to Reproduce: 1. file containing this code 2. try to run 3. Actual Results: 423 not found Expected Results: it should run Reproducible: Always User Profile Reset: No Additional Info: Version: 24.2.3.2 (X86_64) / LibreOffice Community Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba CPU threads: 4; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: en-IN (en_IN); UI: en-US Calc: threaded
Created attachment 194412 [details] screenshot of error
Reference: https://learn.microsoft.com/en-us/office/vba/api/excel.workbook.printout I VBA activated in your macro? Can you please provide a sample file?
Created attachment 194425 [details] zip containing the file remove the following in order (search for hyperlink) ActiveWorkbook.FollowHyperlink Address:="https://eportal.incometax.gov.in/iec/foservices/#/TaxCalc/calculator" Private Sub ButtonHyperlink() On Error Resume Next fmsgbox "After e-payment of Tax, the details of amount paid, Challan No., BSR Code, etc. should be filled in Schedule IT of Income Tax Return before submission of the return to claim the challan" ActiveWorkbook.FollowHyperlink _ Address:="https://onlineservices.tin.egov-nsdl.com/etaxnew/tdsnontds.jsp" End Sub (this is already a listed bug) Then on prefiljson sheet goto line 87 and remove As Byte() and goto line 2318 and type end function then remove Application.CommandBars("Ply").Enabled = True (by finding ply) this is already a listed bug then if you click on "prefil json button", you will get to filters 423 which is already a bug so remove .Filters.add "Json File", "*.json", 1 as well Set sourceSheet = ThisWorkbook.Sheets("Taxes Paid and Verification") and Set a = ThisWorkbook.Sheets("TCS") this one also shows 423 not found
Created attachment 194426 [details] sample data for tax paid sheet
(In reply to Stéphane Guillou (stragu) from comment #2) > Reference: > https://learn.microsoft.com/en-us/office/vba/api/excel.workbook.printout > > I VBA activated in your macro? Can you please provide a sample file? i have attached the zip file containing the macro file. it needs cleanup to make it work with libreoffice. i have given instructions after which errors come up one after the other so this one file is relevant for many bugs
https://crashreport.libreoffice.org/stats/crash_details/2556249b-eb3e-489a-8c72-cee728b75fbb https://crashreport.libreoffice.org/stats/crash_details/8d5c4b65-1eb8-477d-b75f-fc393f4fe634 this file has given me multiple crashes so should i start a fresh bug report for the crash or leave crash reports as it is?
*** This bug has been marked as a duplicate of bug 155360 ***