Description: I have .xlsx document which contains drop-down list with 40 values in the cell. Each value in the drop-down list contains 8 characters. The drop-down list was created by means of 'Data Validity'. When I add notes in any other cell in this file, click to save and to close, the validity list is reduced to 27 values instead of 40. Steps to Reproduce: 1. Open a new document in the LibreOffice Calc 2. Change any cell, for example, "A1" 3. Click tab "Data" and option "Validity"; a new window "Validity" will appear. 4. Choose the tab "Criteria" 5. Choose "List" in the field "Allow" 6. Enter 40 values in the field "Entries". Every value should contain 8 characters. 7. Click "Ok", save as .xlsx file and close the file. 8. Open this .xlsx file again and check data validity list in the cell "A1". Actual Results: The validity list in chosen cell "A1" was reduced to 27 values instead of 40. Expected Results: The validity list isn't changed after saving and closing this file in .xlsx format. Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.4.3.2 / LibreOffice Community Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890 CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: gtk3 Locale: ru-RU (ru_RU.UTF-8); UI: en-US Calc: threaded
Works fine with ODS format file. Seems about 255 characters (including line break) are saved with xlsx. I think it is a format file limitation, trying to do in excel, it doesn't accept longer lists. Resolved as notabug, please if you are no agree, reopen it. .
For XLS(X); * The limitation for the typed-in list is 256 characters. * The limitation for a list on the worksheet is 32767.
(In reply to ady from comment #2) > * The limitation for a list on the worksheet is 32767. FWIW, that's 32767 items, not chars.
*** This bug has been marked as a duplicate of bug 137167 ***