Description: Move Validity drop-down list control inside cell Steps to Reproduce: 1. Create a validity for cell with "Cell range" or "List" criteria 2. Select that cell 3. Look at drop-down list control => it's on right anf out of cell I suggest move that control inside cell and make it always visibly as it's in Google Docs (look at screenshot from attach) Actual Results: drop-down list control is on right anf out of cell and it dissappears when you select another cell Expected Results: on right anf out of cell is inside cell and always visibly Reproducible: Always User Profile Reset: No Additional Info: -
Created attachment 165656 [details] GDocs vs Calc
advantages of implementation: 1. User will be always see these cells have some validity 2. Control will not hide info in cell right from current
Eike, what is the blocker for this?
Created attachment 177982 [details] GSheets with mixed content and content being added GSheet adds a margin to numbers so it starts after the control. Looks a bit odd for mixed content. Plus, GSheet always starts input from left while we come from right. Sounds to me like a major refactoring and I wonder if it's worth the effort. Code wise, ScGridWindow::GetListValButtonRect() calculates the button position which is drawn in ScGridWindow::DrawButtons().
(In reply to Roman Kuznetsov from comment #2) > advantages of implementation: > > 1. User will be always see these cells have some validity I do not see that as an advantage. > 2. Control will not hide info in cell right from current That is OK for me :)
Putting all together it is visually appealing but functionally not an improvement. => WF