https://bugs.documentfoundation.org/show_bug.cgi?id=155427
Bug ID: 155427 Summary: filters.add 423 property not found Product: LibreOffice Version: 7.5.3.2 release Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: BASIC Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: testing1237...@yahoo.com Description: .Filters.add "Json File", "*.json", 1 is the offending line of code that is missing in LO. other errors in the software that make the file unusable so going to add more bugs Steps to Reproduce: 1. open file and wait for errors in VB to show up 2. remove the following code lines from the vba a. ``` Private Sub ButtonHyperlink() On Error Resume Next fmsgboxsmall "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" ', vbInformation, "Alert" ActiveWorkbook.FollowHyperlink _ Address:="https://onlineservices.tin.egov-nsdl.com/etaxnew/tdsnontds.jsp" End Sub ``` and ```` Private Function DecodeBase64(ByVal strData As String) As Byte() Dim objXML As Object Dim objNode As Object ' help from MSXML Set objXML = CreateObject("MSXML2.DOMDocument") Set objNode = objXML.createElement("b64") objNode.DataType = "bin.base64" objNode.text = strData DecodeBase64 = objNode.nodeTypedValue ' thanks, bye Set objNode = Nothing Set objXML = Nothing End Function ```` and try to navigate to "income details" sheet and press on sidebar "import from JSON". 2 more errors will show. remove that. ```` .Height = 389 .LMessagebox.Height = 312 .CommandButton1.Top = 324 .LMessagebox = IntMsg .LMessagebox.TextAlign = fmTextAlignLeft .Show ```` deleting the offending filters file does show the file picker but attaching the demo file, nothing apparently happens. (but that is a separate bug in itself) Actual Results: BASIC runtime error '423' property or method not found:Filters Expected Results: like in excel, the file selector dialog box should import which should let you choose a JSON file and import the same into the file. 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 -- You are receiving this mail because: You are the assignee for the bug.