Bug 98263

Summary: Autofill does not respect data validation rule
Product: LibreOffice Reporter: Roberto <rgnodev>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: buzea.bogdan, jmadero.dev, raal, rgnodev
Priority: medium    
Version: 5.1.0.3 release   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 108988, 113499    
Attachments: A file where the bug is demoed

Description Roberto 2016-02-29 00:45:02 UTC 
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.
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.
Roberto.
Comment 4 raal 2016-03-06 09:19:59 UTC 
I can confirm with Version: 5.2.0.0.alpha0+
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: 7.6.0.0.alpha1+ (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