[Libreoffice-bugs] [Bug 108908] New: [META] Visual Basic for Applications (VBA) issues

[b***@bugs.documentfoundation.org]

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

Bug ID: 108908
Summary: [META] Visual Basic for Applications (VBA) issues
Product: LibreOffice
Version: Master old -3.6
Hardware: All
URL: https://en.wikipedia.org/wiki/Visual_Basic_for_Applica
tions
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: LibreOffice
Assignee: libreoffice-***@lists.freedesktop.org
Reporter: ***@hotmail.com
Depends on: 52600, 52601, 52602, 52603, 102076, 102078
Blocks: 107585


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=52600
[Bug 52600] Excel Visual Basic compatibility issue in LibreOffice Calc:
Inserted Calc formula with Excel Visual Basic Code
https://bugs.documentfoundation.org/show_bug.cgi?id=52601
[Bug 52601] Excel Visual Basic compatibility issue in LibreOffice Calc: If Not
... Like 
 Then
https://bugs.documentfoundation.org/show_bug.cgi?id=52602
[Bug 52602] Excel Visual Basic compatibility issue in LibreOffice Calc:
NumberFormat to date/time
https://bugs.documentfoundation.org/show_bug.cgi?id=52603
[Bug 52603] Excel Visual Basic compatibility issue in LibreOffice Calc:
"Application.ScreenUpdating = False" does not work!
https://bugs.documentfoundation.org/show_bug.cgi?id=102076
[Bug 102076] Excel XLSM import: VBA compatibility mode insufficient: "EVALUATE"
not supported
https://bugs.documentfoundation.org/show_bug.cgi?id=102078
[Bug 102078] Excel XLSM import with VBA: calling function fails with bogus
"Object variable not set"
https://bugs.documentfoundation.org/show_bug.cgi?id=107585
[Bug 107585] [META] Microsoft Office binary, text and xml file formats

[b***@bugs.documentfoundation.org]

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

Yousuf Philips (jay) <***@hotmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
CC| |***@nouenoff.nl,
| |***@utsa.edu
Depends on| |91008
Ever confirmed|0 |1


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=91008
[Bug 91008] FILEOPEN: XLS - VBA code lost during import

[b***@bugs.documentfoundation.org]

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

Yousuf Philips (jay) <***@hotmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Version|Master old -3.6 |unspecified

[b***@bugs.documentfoundation.org]

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

Yousuf Philips (jay) <***@hotmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Blocks| |107659


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=107659
[Bug 107659] [META] Macro bugs and enhancements

[b***@bugs.documentfoundation.org]

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

Yousuf Philips (jay) <***@hotmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Summary|[META] Visual Basic for |[META] Visual Basic for
|Applications (VBA) issues |Applications (VBA) macro
| |issues

[b***@bugs.documentfoundation.org]

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

Yousuf Philips (jay) <***@hotmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Alias|VBA |Macro-VBA

[b***@bugs.documentfoundation.org]

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

Yousuf Philips (jay) <***@hotmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |107902


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=107902
[Bug 107902] Macro in XLSM gives error in Calc, but runs fine in Excel

[b***@bugs.documentfoundation.org]

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

Yousuf Philips (jay) <***@hotmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |107858


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=107858
[Bug 107858] Autofilter is created differently in Excel macro compared to
manual creation

[b***@bugs.documentfoundation.org]

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

Pénzes Dávid <***@yahoo.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |109132


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=109132
[Bug 109132] FILESAVE: ODS: VBA Macro name in Cell are converted to lowercase
and macro is unknown

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108908
Bug 108908 depends on bug 107858, which changed state.

Bug 107858 Summary: Autofilter is created differently in Excel macro compared to manual creation
https://bugs.documentfoundation.org/show_bug.cgi?id=107858

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108908
Bug 108908 depends on bug 107902, which changed state.

Bug 107902 Summary: Macro in XLSM gives error in Calc, but runs fine in Excel
https://bugs.documentfoundation.org/show_bug.cgi?id=107902

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

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

Aron Budea <***@caesar.elte.hu> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |107797


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=107797
[Bug 107797] Autofilter dropdown behaves strangely when it's created by a macro
in a specific XLSM

[b***@bugs.documentfoundation.org]

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

Thomas Lendo <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |53042


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=53042
[Bug 53042] [FILEOPEN] Bad macros import from xlsm

[b***@bugs.documentfoundation.org]

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

Aron Budea <***@caesar.elte.hu> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |111833


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=111833
[Bug 111833] "This command cannot be used on multiple selection" error in XLSM
macro (OK in Excel)

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108908
Bug 108908 depends on bug 111833, which changed state.

Bug 111833 Summary: "This command cannot be used on multiple selection" error in XLSM macro (OK in Excel)
https://bugs.documentfoundation.org/show_bug.cgi?id=111833

What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

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

Pénzes Dávid <***@yahoo.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |112003


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=112003
[Bug 112003] VBA function weekdayname not documented

[b***@bugs.documentfoundation.org]

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

Pénzes Dávid <***@yahoo.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |111939


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=111939
[Bug 111939] Toggling off Autofilter with VBA macro does not restore filtered
rows

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108908
Bug 108908 depends on bug 111939, which changed state.

Bug 111939 Summary: Toggling off Autofilter with VBA macro does not restore filtered rows
https://bugs.documentfoundation.org/show_bug.cgi?id=111939

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

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

Aron Budea <***@caesar.elte.hu> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |101631


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=101631
[Bug 101631] VBA function parameter is passed by reference by default

[b***@bugs.documentfoundation.org]

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

Aron Budea <***@caesar.elte.hu> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |93488


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=93488
[Bug 93488] Implement password protection for VBA export

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108908
Bug 108908 depends on bug 112003, which changed state.

Bug 112003 Summary: VBA function weekdayname not documented
https://bugs.documentfoundation.org/show_bug.cgi?id=112003

What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108908
Bug 108908 depends on bug 96889, which changed state.

Bug 96889 Summary: getPrintAreas generates [automation bridge] exception (but works in AOO>=3.4.1)
https://bugs.documentfoundation.org/show_bug.cgi?id=96889

What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution|--- |INSUFFICIENTDATA

[b***@bugs.documentfoundation.org]

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

Thomas Lendo <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |117266


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=117266
[Bug 117266] FILESAVE: xlsm- spreedsheet looses function after saving

[b***@bugs.documentfoundation.org]

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

Thomas Lendo <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |56541


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=56541
[Bug 56541] Spreadsheet created in MS Excel 2010 does not translate VB script
correctly in Spreadsheet program

[b***@bugs.documentfoundation.org]

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

Xisco Faulí <***@libreoffice.org> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |118153


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=118153
[Bug 118153] FILEOPEN VBA Macro:“Workbooks.Open Filename” command does not work

[b***@bugs.documentfoundation.org]

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

Aron Budea <***@caesar.elte.hu> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |118180


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=118180
[Bug 118180] Assertion failed opening an XLSM with Application.ScreenUpdating
set to true

[b***@bugs.documentfoundation.org]

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

Thomas Lendo <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |90278


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=90278
[Bug 90278] VBA Compatibility - Regression on Range().Borders().Weight()

[b***@bugs.documentfoundation.org]

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

Aron Budea <***@caesar.elte.hu> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |118218


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=118218
[Bug 118218] VBA FormatNumber function is unsupported

[b***@bugs.documentfoundation.org]

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

Buovjaga <***@suomi24.fi> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |118129


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=118129
[Bug 118129] The implementation of the ooo.vba.excel.XWindow.Caption property
getter obviously does not work as intended

[b***@bugs.documentfoundation.org]

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

raal <***@post.cz> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |118277


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=118277
[Bug 118277] FILEOPEN XLSX Basic project with VBA Project Password does not
work in Calc

[b***@bugs.documentfoundation.org]

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

Buovjaga <***@suomi24.fi> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |118167


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=118167
[Bug 118167] FILESAVE XLSX VBA-Project and Microsoft Excel Objects look
different after export

[b***@bugs.documentfoundation.org]

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

Aron Budea <***@caesar.elte.hu> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |118441


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=118441
[Bug 118441] VBA macro unnecessarily recalculated

[b***@bugs.documentfoundation.org]

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

Aron Budea <***@caesar.elte.hu> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |118146


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=118146
[Bug 118146] VBA Macro: Application.ActiveWorkbook.SaveAs saves invalid files

[b***@bugs.documentfoundation.org]

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

Aron Budea <***@caesar.elte.hu> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |105813


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=105813
[Bug 105813] VBA Macro assignment to control not saved to XLS

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108908
Bug 108908 depends on bug 118441, which changed state.

Bug 118441 Summary: VBA macro unnecessarily recalculated
https://bugs.documentfoundation.org/show_bug.cgi?id=118441

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108908
Bug 108908 depends on bug 118218, which changed state.

Bug 118218 Summary: VBA FormatNumber function is unsupported
https://bugs.documentfoundation.org/show_bug.cgi?id=118218

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108908
Bug 108908 depends on bug 118180, which changed state.

Bug 118180 Summary: Assertion failed opening an XLSM with Application.ScreenUpdating set to true
https://bugs.documentfoundation.org/show_bug.cgi?id=118180

What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108908
Bug 108908 depends on bug 52600, which changed state.

Bug 52600 Summary: Excel Visual Basic compatibility issue in LibreOffice Calc: Inserted Calc formula with Excel Visual Basic Code
https://bugs.documentfoundation.org/show_bug.cgi?id=52600

What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution|--- |INSUFFICIENTDATA

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108908
Bug 108908 depends on bug 118153, which changed state.

Bug 118153 Summary: FILEOPEN VBA Macro:“Workbooks.Open Filename” command does not work
https://bugs.documentfoundation.org/show_bug.cgi?id=118153

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

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

Aron Budea <***@caesar.elte.hu> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |115707


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=115707
[Bug 115707] Crash in: cppu::_copyConstructAny(_uno_Any *,void
*,_typelib_TypeDescriptionReference *,_typelib_TypeDescription *,void (*)(void
*),_uno_Mapping *)

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108908
Bug 108908 depends on bug 109132, which changed state.

Bug 109132 Summary: FILESAVE: ODS: VBA Macro name in Cell are converted to lowercase and macro is unknown
https://bugs.documentfoundation.org/show_bug.cgi?id=109132

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

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

Xisco Faulí <***@libreoffice.org> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |118493


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=118493
[Bug 118493] xlt file with macros BASIC runtime error. '423' Panes

[b***@bugs.documentfoundation.org]

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

Aron Budea <***@caesar.elte.hu> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |118241


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=118241
[Bug 118241] FILEOPEN XLSX Basic code with
CreateObject("Scripting.FileSystemObject") and “For Each ” loop does not work

[b***@bugs.documentfoundation.org]

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

Aron Budea <***@caesar.elte.hu> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |120689


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=120689
[Bug 120689] FILESAVE Roundtripped XLSM opens with recovery in Excel

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108908
Bug 108908 depends on bug 120689, which changed state.

Bug 120689 Summary: FILESAVE Roundtripped XLSM opens with recovery in Excel
https://bugs.documentfoundation.org/show_bug.cgi?id=120689

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

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

Roman Kuznetsov <***@mail.ru> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |121919


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=121919
[Bug 121919] Basic Runtime Error 423

[b***@bugs.documentfoundation.org]

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

eisa01 <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |77722


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=77722
[Bug 77722] Excel file with VBA goes into an infinite error loop upon load

[b***@bugs.documentfoundation.org]

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

raal <***@post.cz> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |121988


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=121988
[Bug 121988] VBA macro / LO freeze when running macro