Bug 155427 - filters.add 423 property not found
Summary: filters.add 423 property not found
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version:
(earliest affected)
7.5.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Macro-VBA-Error423
  Show dependency treegraph
 
Reported: 2023-05-21 17:39 UTC by johnks
Modified: 2023-07-06 12:52 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
india taxation file containing errors (8.32 MB, application/vnd.ms-excel.sheet.macroEnabled.12)
2023-05-21 17:40 UTC, johnks
Details
demo "prefil json" to import into software (5.49 KB, application/json)
2023-05-21 17:40 UTC, johnks
Details
screenshot of error (231.78 KB, image/png)
2023-05-21 17:49 UTC, johnks
Details

Note You need to log in before you can comment on or make changes to this bug.
Description johnks 2023-05-21 17:39:18 UTC
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
Comment 1 johnks 2023-05-21 17:40:08 UTC
Created attachment 187420 [details]
india taxation file containing errors
Comment 2 johnks 2023-05-21 17:40:59 UTC
Created attachment 187421 [details]
demo "prefil json" to import into software
Comment 3 johnks 2023-05-21 17:41:46 UTC
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
Comment 4 johnks 2023-05-21 17:49:56 UTC
Created attachment 187423 [details]
screenshot of error
Comment 5 Buovjaga 2023-07-06 12:52:26 UTC
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