Bug 135088 - India Income tax returns excel file multiple macro errors (VBA)
Summary: India Income tax returns excel file multiple macro errors (VBA)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Macro-VBA
  Show dependency treegraph
Reported: 2020-07-24 03:15 UTC by johnks
Modified: 2020-12-07 18:39 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:

demo data file containing macro errors (5.12 MB, application/vnd.ms-excel)
2020-07-24 03:16 UTC, johnks
excel file containing unaltered macro file. use data from first file to check (2.77 MB, application/zip)
2020-07-24 03:17 UTC, johnks

Note You need to log in before you can comment on or make changes to this bug.
Description johnks 2020-07-24 03:15:37 UTC
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

Actual Results:
1. "ActiveWorkbook.FollowHyperlink _

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:
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
Comment 1 johnks 2020-07-24 03:16:39 UTC
Created attachment 163467 [details]
demo data file containing macro errors
Comment 2 johnks 2020-07-24 03:17:31 UTC
Created attachment 163468 [details]
excel file containing unaltered macro file. use data from first file to check
Comment 3 johnks 2020-07-24 03:17:52 UTC

you can download this file and others from above link
Comment 4 Robert Großkopf 2020-07-24 15:41:31 UTC
This isn't a bug for Base - database. Could be something for BASIC or Calc. I have changed the component to Calc.
Comment 5 Buovjaga 2020-12-07 17:58:34 UTC

Arch Linux 64-bit
Build ID: 43d07ddf487fae1b966abf00a36612b109ed01fc
CPU threads: 8; OS: Linux 5.9; UI render: default; VCL: kf5
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 7 December 2020