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
Created attachment 187420 [details] india taxation file containing errors
Created attachment 187421 [details] demo "prefil json" to import into software
i mistakenly wrote "try to navigate to "income details" sheet and press on sidebar "import from JSON"." when it should be "try to navigate to "income details" sheet and press on sidebar "import from prefil". you can try with both json or prefil
Created attachment 187423 [details] screenshot of error
Reproduced with import from prefill button. Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: e4e5fb4b2935e395c7e4b3a794d544a6f44709ce CPU threads: 2; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: en-US (en_FI); UI: en-US Calc: threaded