Bug 122298

Summary: Charts in Base-Forms couldn't be changed by macro any more
Product: LibreOffice Reporter: Robert Großkopf <robert>
Component: BASICAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: normal CC: ilmari.lauhakangas, raal
Priority: medium Keywords: notBibisectable, regression
Version: 5.3.0.3 release   
Hardware: All   
OS: All   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=140155
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 90486, 107659, 108440    
Attachments: Open any form in the database. Charts should be refreshed while data are updated.
Chart in a Base-Form: Working version with different code.

Description Robert Großkopf 2018-12-23 20:01:07 UTC
Created attachment 147789 [details]
Open any form in the database. Charts should be refreshed while data are updated.

I created the attached database for Base-Handbook (German version for LO 5.1) and translated it now for the new English version.
The forms in the database will show charts for the data you could input into the tablecontrol.

Open the attached database.
Open any form.
Change data in the form.
The chart in the form will be changed, too.

This all works in LO 5.1.5.2 on OpenSUSE 15, 64bit rpm Linux.
Fails with all LO-versions, which are newer than LO 5.4.6.2. Haven't tested version between LO 5.1.5.2 and 5.4.6.2, so could be the bug appears also under 5.2 or 5.3.

Don't know if there must be only changed something in the code, while the behaviour of objects have been changed.
Comment 1 raal 2018-12-24 07:07:23 UTC
Confirm with LO 6.3; Linux
Comment 2 Robert Großkopf 2018-12-24 09:20:15 UTC
Have tested this a little bit more:
Last version without this behaviour is LO 5.2.7.2.
First version which fails is LO 5.3.0.3 here.
So I will set the version to 5.3.0.3.
Comment 3 Buovjaga 2020-06-05 16:41:18 UTC
Tried to bibisect with win32-5.3, but sadly there is a huge number of commits, where the forms do not show in the UI - I can't click to open any of them! The rough result after some bisect skips etc. was that there are about 1100 commits between the confirmable good and bad commits.

Robert: if you can advise some way for me to open a form without the UI (a macro?), I can try again.
Comment 4 Robert Großkopf 2020-06-06 09:25:38 UTC
(In reply to Buovjaga from comment #3)
> Tried to bibisect with win32-5.3, but sadly there is a huge number of
> commits, where the forms do not show in the UI - I can't click to open any
> of them! The rough result after some bisect skips etc. was that there are
> about 1100 commits between the confirmable good and bad commits.
> 
> Robert: if you can advise some way for me to open a form without the UI (a
> macro?), I can try again.

Hi Buovjaga,

have tested it a littel bit more. Seems I had the wrong macro-code. Don't know why it worked in the past, but when I changed it, it will work well.

I will set this one to WORKSFORME
Comment 5 Robert Großkopf 2020-06-06 09:26:52 UTC
Created attachment 161675 [details]
Chart in a Base-Form: Working version with different code.