Created attachment 145070 [details]
Example ods file with 2000 rows of validation
+++ This bug was initially created as a clone of Bug #41425 +++
Hi. I have a file with lots of data validation, I open it in LibreOffice, and I do nothing else but save it as either XLS or XLSX.
The resulting XLS or XLSX now have no data validation.
This bug is here as a reminder to find a proper solution to saving formatting and data validation to XLSX format. The workaround for Bug #41425 works for the next 1000 rows after the last one, which should cover most user needs.
However we should not settle for a workaround, but support this for all and every single rows.
Created attachment 145072 [details]
The same file saved as xlsx with LO 6.2
Validation ends in row 1003 with:
Build ID: a27ae800fed5a974c9b255f7ce2b38ec2dbaa426
CPU threads: 4; OS: Windows 6.3; UI render: default;
Locale: hu-HU (hu_HU); Calc: CL
From bibisect-win32-6.2 repo.
Silly me, there is already one bug left open for this. Sorry for the spam :(.
*** This bug has been marked as a duplicate of bug 46738 ***