Bug 140749 - Editing settings from a drop down menu from SQL to Value List and/or back, draws window black partially
Summary: Editing settings from a drop down menu from SQL to Value List and/or back, dr...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.0.4.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-03-01 22:00 UTC by Peter Ludwig
Modified: 2024-03-08 19:11 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
This is a LO Base Database with a formular/form. (13.49 KB, application/vnd.oasis.opendocument.database)
2021-03-01 22:08 UTC, Peter Ludwig 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Peter Ludwig 2021-03-01 22:00:11 UTC 
Description:
I am editing the settimngs of a drop down menu in a formular. The formular is created and now I want to change a text field to a drop down menu. In this drop down menu I change the type where the data is coming from, from  "value list" to "SQL". I then click the three dots on the right side of this field and choose: SELECT "Sports", "ID" FROM "Sports".
If I then change this back from "SQL" to "Value field" the window is drawn black partially. This bug only exists in Windows 10 with LO 7.1.0.3 and 7.0.4. In Linux this bug does not exist. In version 6.4 this bug does not exist.

Steps to Reproduce:
1.Create a form
2.Replace/Change a "text field" to "drop down" menu.
3.Change "Value List" to "SQL" and create you SQL phrase with the help of the three buttons on the right side of this field.
4. Change the settings back from SQL to "Value List" or the other way round.
5. Then (if not before) the window is drawn partially black.

Actual Results:
The window is drawn partially black.

Expected Results:
The windows does not change its color. 


Reproducible: Always


User Profile Reset: No



Additional Info:
Workaround: Drag this window to the bottom of the screen until it is almost completely outside from the screen. As soo as you drag this window back into the screen middle the windows is back to normal. (Seems some kind of refreshing/grafics/drawing problem?)
Comment 1 Peter Ludwig 2021-03-01 22:08:38 UTC 
Created attachment 170164 [details]
This is a LO Base Database with a formular/form.

Open the Database.
Click on Form/Formular. (3. on left side)
Right click on the formular "Teilnehmer" -> Edit / Bearbeiten
In the lower section right click in "Sportart". Click on "Spalte /column ..."
Choose "Data" - and in the middle change the type from "SQL" to "anything else/value list/SQL native/Query". Then, the window is drawn black.
Comment 2 pavlog 2021-03-28 18:43:44 UTC 
Thanks for reporting. I can confirm it in

Version: 7.2.0.0.alpha0+ (x64)
Build ID: ecb916667b633f8647790e040226b093760e6cfe
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL


Version: 7.1.1.2 (x64) / LibreOffice Community
Build ID: fe0b08f4af1bacafe4c7ecc87ce55bb426164676
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL
Comment 3 QA Administrators 2023-10-11 03:15:05 UTC Comment hidden (obsolete)
Comment 4 wjsim 2024-03-08 19:11:54 UTC 
This bug is still present in

Version: 24.2.1.2 (X86_64) / LibreOffice Community
Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac
CPU threads: 16; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded