Description: Data Validity List is truncated when saving a LibreOffice Calc doc in any Excel file format Steps to Reproduce: 1. Focus on a cell 2. Click on "Data/Validity..." menu 3. On Criteria Tab, select "List" from the "allow" drop down menu 4. Create at least 9 rows in the "Entries" input box (my example list is below) EXAMPLE LIST: Aluminum - Smooth Mill Finish Aluminum - Stucco Embossed Mill Finish Aluminum - Smooth White Aluminum - Stucco Embossed White Galvanized Steel - Smooth Mill Finish Galvanized Steel - Stucco Embossed Mill Finish Galvanized Steel - Smooth White Galvanized Steel - Stucco Embossed White Stainless Steel Save the document in Excel format (cannot reproduce in ODF format) Reopen the document and follow steps above to access the Validity list and you will find that the "Entries" list is truncated to the following: (note the last row on the list) EXAMPLE after saving Aluminum - Smooth Mill Finish Aluminum - Stucco Embossed Mill Finish Aluminum - Smooth White Aluminum - Stucco Embossed White Galvanized Steel - Smooth Mill Finish Galvanized Steel - Stucco Embossed Mill Finish Galvanized Steel - Smooth White Galvanized Steel - S Actual Results: complete list is not saved Expected Results: entire list would be saved Reproducible: Always User Profile Reset: No Additional Info: Version: 7.0.0.3 (x64) Build ID: 8061b3e9204bef6b321a21033174034a5e2ea88e CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
*** This bug has been marked as a duplicate of bug 137167 ***
(Closing INVALID, since this is not an independent duplicate, which increases importance of the original report)