https://bugs.documentfoundation.org/show_bug.cgi?id=96470
Bug ID: 96470
Summary: FORMATTING: Validation Range List in Excel doesn't
transfer to Libreoffice
Product: LibreOffice
Version: 5.0.3.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: cfntmar...@gmail.com
Created attachment 121284
--> https://bugs.documentfoundation.org/attachment.cgi?id=121284&action=edit
File
I have this excel File that calculates food costs in different grocery stores.
The grocery stores are selected from a drop-down list (Data Validation). As my
formatting doesn't allow me to select only the column, I created a Data Range
Validation for that list, so I can quickly adjust the list for all cells when I
update the store list.
Anyway, I tried to open the file in Libreoffice 5.03. Everything works, but the
list, which doesn't appear as list anymore.
1. Open file Food.xlsx in Excel.
2. Look at column J, linked with the second sheet of the spreadsheet
3. Open the file Food.xlsx in Libreoffice 5.03
4. Notice the column J no longer is a drop down list.
Thank you guys for all your work.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
