Created attachment 82786 [details]
Sheet with validation on column A1
Trying to move to using libreOffice Clac but need to support Excel as well. If you have an XLSX file that has validation on the entire column, when you save (as xlsx), only the last cell that has data retains the validation. Cells below that remove the validation.
Steps to reproduce:
1. Attached xlsx has cell validation from A1:A200
2. Modify any cell (say A10)
3. Save as xlsx
4. When re-opened, cells below A10 have no validation.
Operating System: Windows 7
Version: 22.214.171.124.alpha0+ Master
Version: 126.96.36.199.alpha0+ Build ID: 2cce78137bbf9810421b9fdedd45127b019b1188
TinderBox: Win-x86@6-debug, Branch:master, Time: 2013-07-18_23:43:36
Bug reproduced using Ubuntu 13.04 with two Calc versions - 188.8.131.52 and 184.108.40.206
*** Bug 80407 has been marked as a duplicate of this bug. ***
Change Version to 3.5.4 -> based on Bug 56823
For XLS : Bug 41425
*** Bug 88494 has been marked as a duplicate of this bug. ***
Bug is still reproducible.
Win 7, LibreOffice Version: 220.127.116.11 (x64)
I tested with LibreOffice 5.1 on Ubuntu 16.04 and it is validation list is showing correctly.