https://bugs.documentfoundation.org/show_bug.cgi?id=98263
Bug ID: 98263
Summary: Autofill does not respect data validation rule
Product: LibreOffice
Version: 5.1.0.3 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
I'm using LibreOffice 5.1.0.3 (1:5.1.0~rc3-0ubuntu1~trusty0) on Ubuntu 14.04
LTS (64 bits). To reproduce the bug, follow these steps:
1. Open a new book with Calc.
2. For Sheet 1, fill cells A2 to A4 with 1, 2, and 3, respectively. Write 'ID'
in A1, for the column header.
3. For sheet 2, write 'Name' in A1, and 'ID' in B1.
4. Fill range A2:A5 of sheet 2 with the following names: 'Berta', 'Allan',
'Mary', and 'Fred' (or whatever you want).
4. Set a data validation rule for range B2:B30 of sheet 2, by allowing only
values coming from range A2:A15 of sheet 1 (let's suppose that, over time, you
could add more and more IDs in sheets 1 and 2).
5. For sheet 2, enter a value of 2 in cell B2. Then, click the bottom-right
corner of B2, and let Calc to auto-fill B3:B5.
Current behaviour: Calc automatically fills the range with values 3, 4, and 5,
but 4 and 5 are not valid, according with the data validation rule set in step
4. Even more, not a single error message warns you about the error.
Expected behaviour: Calc shouldn't fill the range with invalid values.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
