Download it now!
Bug 61623 - UI Data Validity List and icon drawing bugs
Summary: UI Data Validity List and icon drawing bugs
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.5.2 release
Hardware: All All
: medium trivial
Assignee: Not Assigned
Keywords: needsDevEval, topicUI
: 45470 63178 69734 89374 90980 121827 133741 (view as bug list)
Depends on:
Blocks: Cell-Validity
  Show dependency treegraph
Reported: 2013-02-28 16:57 UTC by Krisztian Pinter
Modified: 2020-06-07 07:01 UTC (History)
10 users (show)

See Also:
Crash report or crash signature:

An image showing the bug (29.48 KB, image/png)
2013-02-28 16:57 UTC, Krisztian Pinter

Note You need to log in before you can comment on or make changes to this bug.
Description Krisztian Pinter 2013-02-28 16:57:36 UTC
Created attachment 75701 [details]
An image showing the bug

If a cell has a Data Validity List, then when the cell is selected, the drop-down icon next to the cell is still drawn when switching to another sheet. If the drop-down list is opened, and another application is brought to the front, the list is drawn over it.

Steps to Reproduce:
1. Create a new spreadsheet.
2. Select cell A1.
3. Data->Validity menu, on Criteria tab, select List from the Allow drop-down list, add some entries.
4. Create a new sheet.
5. The little drop-down icon next to the cell on the first sheet is drawn over the new sheet, when it shouldn't be.
6. Go back to the first sheet and open the list. Bring another application to the foreground. The dropdown list is drawn over it when it shouldn't be.

Build Version built on 2013-02-28
Under Linux Mint 14 MATE 64 bits
Comment 1 Joel Madero 2013-02-28 17:50:22 UTC
Thank you for reporting this issue! I have been able to confirm the issue on:
Platform: Bodhi Linux 2.2 x64

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

As I've been able to confirm this problem on an earlier release I am changing the version number as version is the earliest version that we can confirm the bug, we use comments to say that the bug exists in newer versions as well.

Marking as:

New (confirmed)
Trivial - if you click off the cell the arrow disappears for good, just kind of awkward to have it there at the beginning.
Low - Because it's only a short period that it exists there at all, it's not a high priority but possibly a very easy hack to fix it.

Keywords - ProposedEasyHack

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

LibreOffice is powered by a team of volunteers, every bug is confirmed (triaged) by human beings who mostly give their time for free. We invite you to join our triaging by checking out this link:

There are also other ways to get involved including with marketing, UX, documentation, and of course developing - 

Lastly, good bug reports help tremendously in making the process go smoother, please visit WIKI to see examples of great bug reports..
Comment 2 Joel Madero 2014-02-27 22:55:10 UTC
In order to limit the confusion between ProposedEasyHack and EasyHack and to make queries much easier we are changing ProposedEasyHack to NeedsDevEval.

Thank you and apologies for the noise
Comment 3 m.a.riosv 2015-02-14 14:27:17 UTC
*** Bug 89374 has been marked as a duplicate of this bug. ***
Comment 4 raal 2015-04-30 20:15:12 UTC
*** Bug 90980 has been marked as a duplicate of this bug. ***
Comment 5 raal 2015-04-30 20:18:06 UTC
*** Bug 63178 has been marked as a duplicate of this bug. ***
Comment 6 Terrence Enger 2015-05-01 15:03:38 UTC
*** Bug 45470 has been marked as a duplicate of this bug. ***
Comment 7 Robinson Tryon (qubit) 2015-12-13 11:23:57 UTC Comment hidden (obsolete)
Comment 8 QA Administrators 2017-01-03 19:50:42 UTC Comment hidden (obsolete)
Comment 9 grofaty 2017-01-04 07:49:47 UTC
I have tested steps from this first post and also tested very similar (but not the same) step-by-steps from bug 63178 reported by me and marked as duplicate by QA member. In both cases the problem still persists and is exactly the same as reported in previous versions.

I did the tests on Windows 7 using LibreOffice version:
Build ID: 3d5603e1122f0f102b62521720ab13a38a4e0eb0
CPU Threads: 3; OS Version: Windows 6.1; UI Render: default; 
Locale: sl-SI (sl_SI); Calc: group

P.S. In comment 8 it is stated the tests should be performed using 5.2.3 version, but it looks to me this is some old message not updated to the latest official release. Is it?
Comment 10 grofaty 2017-01-04 08:02:27 UTC
Now I have also tested this bug and bug 63178 on LibreOffice master nightly and this problem still persists.

From LibreOffice Calc menu Help | About:
Build ID: 0ab8a27244e74e1c0916b3737f15c6c949aead78
CPU Threads: 3; OS Version: Windows 6.1; UI Render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2017-01-04_00:43:26
Locale: sl-SI (sl_SI); Calc: group
Comment 11 Roman Kuznetsov 2017-12-10 19:22:28 UTC
still present in LO 6.0 beta 2 on Windows 7
Comment 12 Xisco Faulí 2018-01-17 17:30:49 UTC
*** Bug 69734 has been marked as a duplicate of this bug. ***
Comment 13 m.a.riosv 2018-12-01 01:01:15 UTC
*** Bug 121827 has been marked as a duplicate of this bug. ***
Comment 14 Wolfgang Jäger 2019-06-07 11:08:57 UTC
The bug was already present in V3.5.2.2 (portable). I will change the version info to this.

The bug is NOT legacy! It does not show in V3.3 nor does it in AOO up to date.

I personally never experienced the issue described in the original report for reproducing in step 6. I woiuld like to know if it actually showed for other users with ANY other software or with specific ones. 

In addition to the already described issues there is a related neagtive variant: 
Having gotten rid of the icon in a sheet where it shouldnÄt show by selecting a cell, you will NOT be presented the icon if you select the sheet it belongs to EVEN if the cell possessing the validity setting is still under focus.

The additional issue also is present already in V3.5.2.2.

Everything is unchanged up to V

The importance is set medium/trivial. May this mean the bug will never be addressed?
Comment 15 m.a.riosv 2020-06-06 23:10:42 UTC
*** Bug 133741 has been marked as a duplicate of this bug. ***