[Libreoffice-bugs] [Bug 135088] New: India Income tax returns excel file multiple macro errors

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=135088

            Bug ID: 135088
           Summary: India Income tax returns excel file multiple macro
                    errors
           Product: LibreOffice
           Version: 6.4.5.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: testing1237a-c at yahoo.com

Description:
The attached file is the india government income tax return preparation excel
file and there are multiple macro errors in the same making the file unusable
in libreoffice. i have listed some errors below

Steps to Reproduce:
1. open file. enable macros
2. click on buttons like "validate" sheet
3.

Actual Results:
1. "ActiveWorkbook.FollowHyperlink _
Address:="https://onlineservices.tin.egov-nsdl.com/etaxnew/tdsnontds.jsp""

2. "Application.CommandBars("Ply").Enabled = True"

3. "If Mid(Sheet1.Range("sheet1.SeventhProvisoFlag").Value, 1, 1) <> "N" Then"

4. "If UserForm1.Visible = True Then"

5. "widthForm = UserForm1.ProgressFrame.Width"

6. If UserForm1.ProgressFrame.Caption = "" Then

7. .lblmainProgPercDisp.Caption = Round(mainProcPerc, 2) & "%"

8. If Mid(Sheet1.Range("sheet1.SeventhProvisoFlag").Value, 1, 1) <> "N" Then

on and on when clicking on "validate" button

if i click on the side bar "calculate tax" 

9. Sheet3.Range("IncD.TDS").Value = 0

there are probably hundreds of macro errors

on and on when using 

Expected Results:
i have deleted the above problem code from macros and it is still not working.
also attached will be a zip containing the original unaltered governmental
excel file. 
the first file would be for demo data to be put in the excel from zip file


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.4.5.2
Build ID: a726b36747cf2001e06b58ad5db1aa3a9a1872d6
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: kf5; 
Locale: en-IN (en_IN.UTF-8); UI-Language: en-US
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200724/9ebeb96f/attachment.htm>