Bug 61623 - UI Data Validity List and icon drawing bugs
Summary: UI Data Validity List and icon drawing bugs
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.2 release
Hardware: All All
: medium trivial
Assignee: Balázs Varga (allotropia)
URL:
Whiteboard: target:7.5.0 target:7.4.0.2
Keywords: needsDevEval, topicUI
: 63178 69734 89374 90980 121827 130850 133741 (view as bug list)
Depends on:
Blocks: Cell-Validity
  Show dependency treegraph
 
Reported: 2013-02-28 16:57 UTC by Krisztian Pinter
Modified: 2022-07-15 11:21 UTC (History)
11 users (show)

See Also:
Crash report or crash signature:


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

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 4.1.0.0.alpha0+ 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:
Version 3.6.4.3 
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:
https://wiki.documentfoundation.org/QA/BugTriage

There are also other ways to get involved including with marketing, UX, documentation, and of course developing -  http://www.libreoffice.org/get-help/mailing-lists/. 

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 Comment hidden (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 (noise)
Comment 8 QA Administrators 2017-01-03 19:50:42 UTC Comment hidden (noise)
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:
=============================================================
Version: 5.2.4.2
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:
===============================================================
Version: 5.4.0.0.alpha0+
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 6.3.0.0.beta1.

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. ***
Comment 16 QA Administrators 2022-06-08 03:31:39 UTC Comment hidden (noise)
Comment 17 Gabor Kelemen (allotropia) 2022-06-10 13:37:44 UTC
Still a problem in

Version: 7.4.0.0.alpha1+ / LibreOffice Community
Build ID: 754eb1541a6ca709f78afbc7fb2b75f626562dcc
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: hu-HU (hu_HU.UTF-8); UI: en-US
Calc: threaded
Comment 18 Commit Notification 2022-07-14 18:25:08 UTC
Balazs Varga committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/cf936b57117b9bd4a9b1ae4c77244d544cc2bfec

tdf#61623 sc update current cell view if we switch or create a new tab

It will be available in 7.5.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 19 Gabor Kelemen (allotropia) 2022-07-15 09:13:31 UTC
*** Bug 130850 has been marked as a duplicate of this bug. ***
Comment 20 Commit Notification 2022-07-15 09:23:19 UTC
Balazs Varga committed a patch related to this issue.
It has been pushed to "libreoffice-7-4":

https://git.libreoffice.org/core/commit/d58f93b47c82f386b6e8f59ff1384e4cb433374e

tdf#61623 sc update current cell view if we switch or create a new tab

It will be available in 7.4.0.2.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.