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: [email protected]
Reporter: [email protected]
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.
