https://bugs.documentfoundation.org/show_bug.cgi?id=148853
Bug ID: 148853
Summary: "Before Submitting" event of a Base form does not fire
Product: LibreOffice
Version: 7.0.6.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
I can set up a brand new .odb file, give it a single table, create a form with
a grid for filling in the table. If I pull up the Form Properties, go to the
"Events" tab and select a macro for "Before submitting", and save the form, it
does not work. When I start using the form to populate the table, new records
can be entered into the table without the macro's being launched.
Steps to Reproduce:
1.Create a new database in Base. (Use HSQLDB.) Save it as Test Datase.odb on
the desktop.
2.Create a Table "Characters" with two columns: Make the first "id
int(10)unsigned auto_increment primary key" and the second "name varchar(55)".
3.Create a macro in a trusted location:
sub Say_Hey()
msgBox "Hey!"
End Sub
4.Create a Form with a grid to the Characters table. Right-click the grid and
click "Form Properties". Click the "Events" tab. For the "Before submitting"
event, select the Say_Hey macro.
5.Save the Form and open it for use. Start by entering the name "Mickey Mouse"
in the "name" column. Then hit Tab. It will move on to the next record.
enter "Donald Duck" and close the form. If prompted to save the data, click
"Yes". Now open the table and observe its contents.
Actual Results:
Both characters were entered into the table without the macro ever having been
launched.
Expected Results:
When hitting Tab after Mickey Mouse and when hitting "Yes" to saving the data,
the "Hey" message box should have cropped up.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.0.6.2 (x64)
Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
