https://bugs.documentfoundation.org/show_bug.cgi?id=155080
Bug ID: 155080
Summary: Part of values in data validity list disappear when I
save and close .xlsx file
Product: LibreOffice
Version: 7.5.2.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
