[Issue 128491] New: Data validity used as dropdown cannot be drag copied or copy / pasted without shifting values

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=128491

          Issue ID: 128491
        Issue Type: DEFECT
           Summary: Data validity used as dropdown cannot be drag copied
                    or copy / pasted without shifting values
           Product: Calc
           Version: 4.1.11
          Hardware: Mac
                OS: macOS 11.0
            Status: UNCONFIRMED
          Severity: Normal
          Priority: P5 (lowest)
         Component: editing
          Assignee: issues@openoffice.apache.org
          Reporter: skywalk@yestertoy.com
  Target Milestone: ---

Scenario: Create dropdown picker list from set of rows in another sheet. Then,
attempt to use this dropdown list in multiple rows on another sheet.

Problem: Using a dropdown list created with Data Validity works fine for
exactly one (1) cell in another sheet. However, it's not useful if you have
more than one row that needs to use this same dropdown list because neither
"copy and paste" nor does "drag copy" work properly with the Data Validity
"Source" when using a Lookup from another sheet's values.

This problem means manually creating Data Validity separately for each cell,
one at a time, which is very time consuming. Attempting to time save using copy
/ paste or drag paste is impossible with this bug.

Steps:

1) Create a sheet named "sheet" with multiple rows
2) Create a second sheet with three rows of values (to be used as dropdown pick
list). I named sheet "Lookup".
3) In "sheet", select a cell and use Data Validity with 'Cell Range'
4) In the Source field, enter 'Lookup.A1:A10' (I'm using more than 3 rows here
for easy expansion of the picker list)
5) Return to "sheet" and validate the correct dropdown list for that cell is
now present.
6) Drag copy that cell downward by one. In Data Validity Source, for that
copied cell you'll now notice that the paste process has shifted the Source
field values by 1 for each copy. The Source now looks like "Lookup.A2:A11",
which is incorrect. Why would we want this?
7) Drag copying downward again makes Source look like "Lookup.A3:A12". Again,
why would you want this?
8) Attempting copy/paste forces this same "Source" increment problem.

When drag copying, I've attempted to press and hold the 'Command' key
qualifier, which prevents incrementing values when copying cell-to-cell. While
OpenOffice respects this qualifier key press for cell-to-cell copying, it
ignores this qualifier key when pasting Data Validity dropdown Source
information. In fact, I've found no way to copy paste a cell using a Data
Validity dropdown and retain the required "Lookup.A1:A10" value.

I'm not even sure of the reasoning behind incrementing values in the Source
field when using Data Validity.

Expected Outcome: Source information in Data Validity for 'Cell List' should
not increment by default. If incrementing is required, there should be a
checkbox in Data Validity to allow for incrementing on drag copy and/or
copy&paste.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 128491] Data validity used as dropdown cannot be drag copied or copy / pasted without shifting values

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=128491

oooforum (fr) <oo...@free.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOT_AN_OOO_ISSUE
                 CC|                            |oooforum@free.fr

--- Comment #2 from oooforum (fr) <oo...@free.fr> ---
This is not a bug
Your validity list source must be set with Lookup.$A$1:$A$10

Next time for this kind of question, please use our users mail list or forum:
https://www.openoffice.org/support/index.html

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 128491] Data validity used as dropdown cannot be drag copied or copy / pasted without shifting values

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=128491

Marcus <ma...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 128491] Data validity used as dropdown cannot be drag copied or copy / pasted without shifting values

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=128491

--- Comment #1 from Brian Wright <sk...@yestertoy.com> ---
Created attachment 87068
  --> https://bz.apache.org/ooo/attachment.cgi?id=87068&action=edit
Example spreadsheet using lookup dropdown from seperate sheet

Attachment for test case

-- 
You are receiving this mail because:
You are the assignee for the issue.