Bug 98263 - Autofill does not respect data validation rule
Summary: Autofill does not respect data validation rule
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Cell-Validity AutoFill
  Show dependency treegraph
Reported: 2016-02-29 00:45 UTC by Roberto
Modified: 2023-05-17 15:47 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

A file where the bug is demoed (7.99 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-03-02 21:17 UTC, Roberto

Note You need to log in before you can comment on or make changes to this bug.
Description Roberto 2016-02-29 00:45:02 UTC
I'm using LibreOffice (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.
Comment 1 Joel Madero 2016-03-02 21:01:26 UTC
Hi Robert,

Please just attach the document :) Contributor time is really stretched thin so having to do all these minor steps sucks up valuable time. Attach a document that shows the problem (following those steps your provided) and then set the bug back to UNCONFIRMED.

Thanks for understanding. We have a small team and 100 million users ;) The more steps you can take off our plate, the more help you are for us to push the thousands of bugs forward.
Comment 2 Roberto 2016-03-02 21:17:36 UTC
Created attachment 123156 [details]
A file where the bug is demoed
Comment 3 Roberto 2016-03-02 21:20:07 UTC
No problem, Joel, here it is. As you can see, cells B4 and B5 in sheet 2 hold invalid values, but Calc doesn't even complain about it. It doesn't occur if you enter these values 'by hand'.
Kind regards.
Comment 4 raal 2016-03-06 09:19:59 UTC
I can confirm with Version:
Build ID: aaca25d67eb5ea252730cdcf555ecc04ce04a5e6
CPU Threads: 4; OS Version: Linux 4.2; UI Render: default; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2016-02-24_23:58:47
Comment 5 QA Administrators 2017-03-06 15:49:24 UTC Comment hidden (obsolete)
Comment 6 QA Administrators 2019-12-03 14:58:24 UTC Comment hidden (obsolete)
Comment 7 QA Administrators 2021-12-03 04:45:06 UTC Comment hidden (obsolete)
Comment 8 BogdanB 2023-05-17 15:47:22 UTC
Also in
Version: (X86_64) / LibreOffice Community
Build ID: 247738a9afeeb2f0644fa0307b7023fe115fae83
CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded