[Libreoffice-bugs] [Bug 137168] New: Validity List truncated when saving in Excel format

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=137168

            Bug ID: 137168
           Summary: Validity List truncated when saving in Excel format
           Product: LibreOffice
           Version: 7.0.0.3 release
          Hardware: x86 (IA32)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: aakorn_ez at yahoo.com

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200930/58f462ff/attachment.htm>