Bug 107659
depends on
295
open
bugs:
view as bug list
-
107659:
[META] Macro bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
64314:
[META] Macro recording issues
[NEW; assigned to libreoffice-bugs]
-
78254:
Substantial performance deterioration by scroll through cells via macro in LibreOffice Calc (Linux, gtk3)
[NEW; assigned to libreoffice-bugs]
-
79588:
Macros called from within formulas doesn't survive save, close and reopen of the calc-document.
[NEW; assigned to libreoffice-bugs]
-
95445:
Add an event to trigger an action after printing a document
[NEW; assigned to libreoffice-bugs]
-
97694:
Base macros cannot be digitally signed
[NEW; assigned to libreoffice-bugs]
-
100297:
API, Calc sheets, Inconsistency concerning changes of cell properties by a user function.
[NEW; assigned to libreoffice-bugs]
-
102943:
Combobox dropdown property setting ignored when set via basic macro
[NEW; assigned to libreoffice-bugs]
-
103339:
Implement bitwise shift operators in LO BASIC
[NEW; assigned to libreoffice-bugs]
-
103615:
Macro with ShareDocument dispatch command -> no functionnality
[NEW; assigned to libreoffice-bugs]
-
108908:
[META] Visual Basic for Applications (VBA) macro issues
[NEW; assigned to libreoffice-bugs]
-
35593:
macro themecolor - tintandshade - patterntintandshade are all problems.
[NEW; assigned to libreoffice-bugs]
-
43147:
error - symbol ... already defined differently
[NEW; assigned to libreoffice-bugs]
-
44195:
First row of data added to XYDiagram is interpretted as Y-Values rather than X-Values
[NEW; assigned to libreoffice-bugs]
-
46736:
Add additional text about Macros, when they are present, at warning for saving in non ODF formats, saying that they won't be saved
[NEW; assigned to libreoffice-bugs]
-
48634:
FILEOPEN: Import Excel VBA basic runtime error
[NEW; assigned to libreoffice-bugs]
-
52601:
Excel Visual Basic compatibility issue in LibreOffice Calc: If Not ... Like … Then
[NEW; assigned to libreoffice-bugs]
-
52603:
Excel Visual Basic compatibility issue in LibreOffice Calc: "Application.ScreenUpdating = False" does not _always_ work!
[NEW; assigned to libreoffice-bugs]
-
53976:
XLS FILESAVE: File loses it's ActiveX VBA functionality (lost form) after saving in latest version(after 3.4)
[NEW; assigned to libreoffice-bugs]
-
55969:
BASIC: API methods for select-protected-cells
[NEW; assigned to libreoffice-bugs]
-
56541:
Spreadsheet created in MS Excel 2010 does not translate VB script correctly in Spreadsheet program
[NEW; assigned to libreoffice-bugs]
-
61398:
FILEOPEN: can't get rid of macro warning ('solution' by manualy editing the file's zip container in comment #11)
[NEW; assigned to libreoffice-bugs]
-
63497:
BASIC: BASIC-error after opening XLS
[NEW; assigned to libreoffice-bugs]
-
64436:
FILEOPEN MSOffice document import List/ComboBox does not track boundcolumn vs display column correctly
[NEW; assigned to libreoffice-bugs]
-
69795:
Macros: Copying a cell form one table to another looks different on Windows
[NEW; assigned to libreoffice-bugs]
-
77437:
Macros: VBA loop While ActiveCell <> "" don't work on Libreoffice
[NEW; assigned to libreoffice-bugs]
-
77722:
Excel file with VBA goes into an infinite error loop upon load
[NEW; assigned to libreoffice-bugs]
-
84097:
Windows: Unit test & extend native calling
[NEW; assigned to libreoffice-bugs]
-
90278:
VBA Compatibility - Regression on Range().Borders().Weight()
[REOPENED; assigned to libreoffice-bugs]
-
90580:
Cannot delete "VBA context"
[NEW; assigned to libreoffice-bugs]
-
91008:
FILEOPEN: XLS - VBA code lost during import
[NEW; assigned to libreoffice-bugs]
-
93488:
Implement password protection for VBA export
[NEW; assigned to libreoffice-bugs]
-
93623:
Provide graceful recovery from Excel VBA Basic Runtime Error which causes endless execution loop and message box display
[NEW; assigned to libreoffice-bugs]
-
96952:
FILEOPEN: Doesn't open XLS spreadsheets forms, BASIC error
[NEW; assigned to libreoffice-bugs]
-
99097:
VBA/Basic formatting datetime with function FORMAT gives wrong result with nn (minutes)
[NEW; assigned to libreoffice-bugs]
-
100488:
FILEOPEN: Formula errors with XLSM
[NEW; assigned to libreoffice-bugs]
-
101631:
VBA function parameter is passed by reference by default
[UNCONFIRMED; assigned to libreoffice-bugs]
-
102076:
Excel XLSM import: VBA compatibility mode insufficient: "EVALUATE" not supported
[NEW; assigned to libreoffice-bugs]
-
102078:
Excel XLSM import with VBA: calling <StringVar>.Chars() fails with bogus "Object variable not set"
[NEW; assigned to libreoffice-bugs]
-
102210:
Cannot use '°' character in subroutine name
[NEW; assigned to libreoffice-bugs]
-
102381:
A user function called from a Calc formula wrongly gets passed numeric 0 for missing optional parameters.
[NEW; assigned to libreoffice-bugs]
-
105813:
MS->ODF VBA macro assignment to control lost. Same with fixed-VBA-ODF->MS (comment 10)
[NEW; assigned to libreoffice-bugs]
-
115707:
Crash in: cppu::_copyConstructAny(_uno_Any *,void *,_typelib_TypeDescriptionReference *,_typelib_TypeDescription *,void (*)(void *),_uno_Mapping *)
[NEW; assigned to libreoffice-bugs]
-
117266:
FILESAVE: xlsm- VBA broken by export - missing userforms (comment 18)
[NEW; assigned to libreoffice-bugs]
-
117739:
Malfunction MSScriptControl in com.sun.star.bridge.OleObjectFactory (Windows 32 bits only)
[NEW; assigned to libreoffice-bugs]
-
118146:
VBA Macro: Application.ActiveWorkbook.SaveAs changes file format from xlsm to xls
[NEW; assigned to libreoffice-bugs]
-
118167:
FILESAVE XLSX VBA-Project and Microsoft Excel Objects look different after export
[NEW; assigned to libreoffice-bugs]
-
118224:
FILEOPEN XLSX Basic code to Enable Control does not work with Application.OnKey "^x" and Application.CellDragAndDrop
[NEW; assigned to libreoffice-bugs]
-
118241:
FILEOPEN XLSX Basic code with CreateObject("Scripting.FileSystemObject") and “For Each ” loop does not work
[NEW; assigned to libreoffice-bugs]
-
118273:
FILESAVE XLSX Basic code with Userform does not work in Calc
[NEW; assigned to libreoffice-bugs]
-
118276:
FILEOPEN XLSX Basic code with Validity and Sheets does not work in Calc
[NEW; assigned to libreoffice-bugs]
-
118277:
FILEOPEN XLSX Basic project with VBA Project Password does not work in Calc
[NEW; assigned to libreoffice-bugs]
-
120504:
VBA Worksheet.PrintOut method prints active sheet, not the one that calls the method
[NEW; assigned to libreoffice-bugs]
-
122394:
changing named ranges content via vba macro will not update cell formula
[NEW; assigned to libreoffice-bugs]
-
122420:
FILESAVE: VBA Worksheet_Change Listener lost on saving .xlsm in LO
[NEW; assigned to libreoffice-bugs]
-
122681:
LineStyle can't be read and set using VBA
[NEW; assigned to libreoffice-bugs]
-
124203:
FILESAVE XLSX: no auto-run macro after round-trip, VBA error running "For Each ws In ThisWorkbook.Worksheets" after roundtrip
[NEW; assigned to libreoffice-bugs]
-
131555:
Cannot set cell borders from VBA macro
[NEW; assigned to libreoffice-bugs]
-
131564:
Cannot set cell number format to percentage + 1 decimal from VBA macro (locale-dependent)
[NEW; assigned to libreoffice-bugs]
-
131818:
BASIC: Declaring an array parameter as optional should not be possible with option VBASupport
[NEW; assigned to libreoffice-bugs]
-
134361:
activeworkbook.followhyperlink in macro throws error
[NEW; assigned to libreoffice-bugs]
-
134471:
"Application.CommandBars("Ply").Enabled = True" VBA error
[NEW; assigned to libreoffice-bugs]
-
134487:
macros dont work as expected. calc crashes on running the macros in file
[NEW; assigned to libreoffice-bugs]
-
134492:
Opening an .xla file containing custom formula throws basic runtime error
[NEW; assigned to libreoffice-bugs]
-
134493:
VBA macro for input field capitalisation not working (see comment 5)
[NEW; assigned to libreoffice-bugs]
-
134714:
VBA Macro: Range names don't work
[NEW; assigned to libreoffice-bugs]
-
135088:
India Income tax returns excel file multiple macro errors (VBA)
[NEW; assigned to libreoffice-bugs]
-
136112:
Basic Time function returns inconsistent datatype
[NEW; assigned to libreoffice-bugs]
-
137629:
Calc Error when trying to use a regression analysis spreadsheet
[NEW; assigned to libreoffice-bugs]
-
139938:
by exporting an *.ods file with makros to an *.xlsm file no VBAProject created
[NEW; assigned to libreoffice-bugs]
-
140475:
FILESAVE XLSM Macro using Range processing failed to work after File Save
[NEW; assigned to libreoffice-bugs]
-
141758:
vba NumberFormat for dates does only work once and never again
[NEW; assigned to libreoffice-bugs]
-
144453:
[META] VBA-Error 423, Unimplemented Member
[NEW; assigned to libreoffice-bugs]
-
146112:
IsNull must return False when testing object variables (including non-initialized/assigned to Nothing) in VBASupport 1 mode
[NEW; assigned to libreoffice-bugs]
-
147457:
Basic 'Me' keyword not implemented
[NEW; assigned to libreoffice-bugs]
-
148766:
Hidden sheets are inaccessible to VBA scripts
[NEW; assigned to libreoffice-bugs]
-
149560:
Excel Visual Basic compatibility issue in LibreOffice Calc: Round trip produces a corrupt xls file
[NEW; assigned to libreoffice-bugs]
-
150195:
There is no support for Application.International in VBA macro
[NEW; assigned to libreoffice-bugs]
-
150458:
Incorrect calculation of the boundaries of the For loop (Option VbaSupport 1)
[NEW; assigned to libreoffice-bugs]
-
150491:
Infinite recursion in a VBA macro that works without errors in Excel
[NEW; assigned to libreoffice-bugs]
-
151005:
With "Option VBASupport 1" arguments should be treated as ByValue by default (not as ByRef)
[NEW; assigned to libreoffice-bugs]
-
153238:
Unsupported VBA macro method keeps throwing error
[NEW; assigned to libreoffice-bugs]
-
153593:
VBA SaveAs method with relative file paths does not work
[NEW; assigned to libreoffice-bugs]
-
153595:
VBA SaveAs method does not add default file extension
[NEW; assigned to libreoffice-bugs]
-
153635:
VBA Methods could handle file path separators OS-independently
[NEW; assigned to libreoffice-bugs]
-
153719:
7.5 BASIC shell function fails (flatpak and snap versions)
[NEW; assigned to libreoffice-bugs]
-
154100:
FORMCONTROLS: unable to migrate Excel Form to Calc
[NEW; assigned to libreoffice-bugs]
-
154166:
MID statement non VBA-conformant
[NEW; assigned to libreoffice-bugs]
-
154215:
The WeekNum worksheet function is very slow
[UNCONFIRMED; assigned to libreoffice-bugs]
-
154710:
Calc freezes when saving file after running macros: Assertion `nIndex >= 0 && "coverity#1438402"' failed
[NEW; assigned to libreoffice-bugs]
-
155428:
thisworkbook.unprotect password shows "Basic runtime error '1'
[NEW; assigned to libreoffice-bugs]
-
157946:
VBA SendKeys not implemented (?)
[NEW; assigned to libreoffice-bugs]
-
111731:
changing properties of inserted graphic-objects via macro (Basic) causes file store error
[NEW; assigned to libreoffice-bugs]
-
117280:
Duplicate Macro execution when triggered by Document print event.
[NEW; assigned to libreoffice-bugs]
-
120295:
A cell with comment text prevent a cell event
[NEW; assigned to libreoffice-bugs]
-
120465:
The sheet event 'Content changed' is not raised if an array-formula was edited
[NEW; assigned to libreoffice-bugs]
-
122940:
Allow per-document Macro Security settings
[NEW; assigned to libreoffice-bugs]
-
123005:
FILEOPEN: Error on creating getCurrentController().getActiveSheet() for basic script from location=document ?
[NEW; assigned to libreoffice-bugs]
-
123558:
Execute Macro dialog: Remember last selected Macro
[NEW; assigned to libreoffice-bugs]
-
123625:
getattr fails with \..
[NEW; assigned to libreoffice-bugs]
-
125042:
ThisComponent undefined/outdated when a spreadsheet loads
[NEW; assigned to libreoffice-bugs]
-
125421:
The Basic function EqualUnoObjects wrongly returns False for two variables having assigned the same object by different ways of access.
[NEW; assigned to libreoffice-bugs]
-
127354:
Erroneous path to image inserted by Basic macro causes crash on entering bounding box for image
[NEW; assigned to libreoffice-bugs]
-
127590:
[META] Application Programming Interface (API), when all scripted languages are affected
[NEW; assigned to libreoffice-bugs]
-
127591:
[META] User Interface (UI) related Macro bugs
[NEW; assigned to libreoffice-bugs]
-
127592:
[META] LibreOffice Basic macros incl."Option Compatible" modules
[NEW; assigned to libreoffice-bugs]
-
127593:
[META] Python Macro bugs
[NEW; assigned to libreoffice-bugs]
-
127594:
[META] Javascript Macro bugs
[NEW; assigned to libreoffice-bugs]
-
127596:
[META] Beanshell Macro bugs
[NEW; assigned to libreoffice-bugs]
-
127597:
[META] Macro-Related Documentation, incl. local/online help or wiki
[NEW; assigned to libreoffice-bugs]
-
127598:
[META] Windows specific Macro bugs, e.g. COM/OLE
[NEW; assigned to libreoffice-bugs]
-
128296:
Sheet event 'Content changed' not thrown in some cases where it should be
[NEW; assigned to libreoffice-bugs]
-
128650:
Calling setToDefault doesn't work in Impress
[NEW; assigned to libreoffice-bugs]
-
131196:
Formcontrols: Borders couldn't be set to "no border" through macros
[NEW; assigned to libreoffice-bugs]
-
132347:
BASIC VBASupport=1 erroneously inherited by StrComp() in module without VBASupport
[NEW; assigned to libreoffice-bugs]
-
133789:
BASIC function DIR does not deliver correct result list
[NEW; assigned to libreoffice-bugs]
-
135242:
Calc: Macro - sorting is working just for first 3 criteria
[NEW; assigned to libreoffice-bugs]
-
135628:
SendSimpleMailMessage bodytext with new lines ends up as multiple recipients
[NEW; assigned to libreoffice-bugs]
-
136006:
Shapes in LO Calc do not get hidden from print preview UI when hidden from printing
[NEW; assigned to libreoffice-bugs]
-
139373:
Private variables are not only available in the module in which they are defined.
[NEW; assigned to libreoffice-bugs]
-
140618:
Calc: Problem with macro for on/off Automatic Spell Checking
[NEW; assigned to libreoffice-bugs]
-
141183:
feature request: temporary macro
[UNCONFIRMED; assigned to libreoffice-bugs]
-
141275:
Macro in Writer generates runtime error when trying to move the cursor from a Comment Box
[NEW; assigned to libreoffice-bugs]
-
143758:
Content of listbox in table control will disappear when listbox is refreshed by macro (Windows and kf5)
[NEW; assigned to libreoffice-bugs]
-
145487:
UI BASIC - Macro causes infinite sheets to be added
[NEW; assigned to libreoffice-bugs]
-
146099:
CALC Macro Basic - Link to external data not refreshed for doc loaded hidden
[NEW; assigned to libreoffice-bugs]
-
146109:
Macro Commands Appear to Execute Out of Sequence in the UI, though ordering is preserved in output
[NEW; assigned to libreoffice-bugs]
-
147594:
com.sun.star.ui.dialogs.FilePicker:mac --C++ code threw unknown exception,win -- suspend
[UNCONFIRMED; assigned to libreoffice-bugs]
-
148129:
UNOControlDateField: Can't enable dropdown from macro code
[NEW; assigned to libreoffice-bugs]
-
148314:
ODS corrupted after crash, not calculating properly
[NEW; assigned to libreoffice-bugs]
-
148880:
Range duplication in case of multi-sheet ranges when selecting them
[NEW; assigned to libreoffice-bugs]
-
149236:
CALC / MACRO graphics of a sheet messed up after inserting a sheet in a lower index number
[NEW; assigned to libreoffice-bugs]
-
149714:
BitsPerPixel property of Graphic has Boolean UNO type
[NEW; assigned to libreoffice-bugs]
-
150094:
File properties dialog does not update with programmatically added Custom Fields
[NEW; assigned to libreoffice-bugs]
-
150600:
MaxImageResolution is ignored in macro
[NEW; assigned to libreoffice-bugs]
-
152133:
Stack Protection is not provided for BASIC call to DLL using declare - lib
[UNCONFIRMED; assigned to libreoffice-bugs]
-
152238:
FILESAVE: The structure of the book is broken when saving to LO in the .xlsm format in the case when the book (sheet) module has macros.
[NEW; assigned to libreoffice-bugs]
-
153077:
A ComboBox inserted into a spreadsheet and raising an onLosingFocus event doesn't pass the .Source correctly
[NEW; assigned to libreoffice-bugs]
-
153322:
RFE: Add Macro Security Settings button to macro infobar
[NEW; assigned to libreoffice-bugs]
-
154284:
IsNumeric(" ") returns True
[NEW; assigned to libreoffice-bugs]
-
154570:
LO Writer not saving macros globally on macOS (works in file)
[NEW; assigned to libreoffice-bugs]
-
155780:
FileName Field displays wrong content if IsFixed is True when inserted by Macro.
[NEW; assigned to libreoffice-bugs]
-
156340:
Document contains macro signed by OpenPGP key can't be enabled and causes operation hanging
[NEW; assigned to libreoffice-bugs]
-
157053:
Writer: error for re-used variable when macro changes the witdh of cells in TextTable
[NEW; assigned to libreoffice-bugs]
-
157621:
dialog.dtd Is Outdated or Incomplete
[NEW; assigned to libreoffice-bugs]
-
157935:
After installation of 7.6.2, first form opening of .odb file freezes LO
[NEW; assigned to libreoffice-bugs]
-
158889:
Macro kill => any attempt to access macros crashes LOo
[NEW; assigned to libreoffice-bugs]
-
158918:
Calc,API:queryContentCells(23) returns wrong results outside Used Area
[NEW; assigned to libreoffice-bugs]
-
159638:
[META] ScriptForge related issues (Basic/Python)
[NEW; assigned to libreoffice-bugs]
-
160001:
Exporting PDF via macro with AllowDuplicateFieldNames = true does not have effect
[NEW; assigned to libreoffice-bugs]
-
160247:
CONVERT becomes CONVERT_OOO when cell formula is set via macro
[NEW; assigned to libreoffice-bugs]
-
160321:
On GoSub statement does not work properly
[ASSIGNED; assigned to andreas.heinisch]
Bug 107659
does not block any open bugs.