https://bugs.freedesktop.org/show_bug.cgi?id=88494
Bug ID: 88494
Summary: FILEOPEN: Dropdown list disappears when the file is
opened by MS Excel
Product: LibreOffice
Version: 4.3.5.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: gr...@npsh.hu
Created attachment 112340
--> https://bugs.freedesktop.org/attachment.cgi?id=112340&action=edit
sample files for the bug
Steps to reproduce with sample.ods:
1. Open the attached .ods file with LibO. (Cell A1 has a dropdown list).
2. Open the attached .ods file with MS Office (I worked with MS Office 2013).
3. Click OK when a window pops up with the following message: "Excel was able
to open the file repairing or removing the unreadable content".
4. Put the active cell on A1.
Current behavior:
A1 shows an empty cell.
Expected behavior:
A1 should show a dropdown list.
Steps to reproduce with sample.xls:
1. Open the attached .xls file with LibO. (Cell A1 has a dropdown list).
2. Open the attached .xls file with MS Office (I worked with MS Office 2013).
3. drop down the list of A1.
Current behavior:
It shows only part of the validity list.
Expected behavior:
A1 should show the full content of the dropdown list.
Steps to reproduce with sample.xlsx:
1. Open the attached .xlsx file with LibO. (Cell A1 has a dropdown list).
2. Open the attached .xlsx file with MS Office (I worked with MS Office 2013).
3. Click 'Yes' when a pop-up window appears. ("We found a problem with some
content in %FILENAME%. Do you want us try to recover as much as we can? If you
trust the source of this workbook. click Yes.")
4. Click 'Close' when the "Repairs" window appears.
5. Put the active cell on A1.
Current behavior:
A1 shows an empty cell.
Expected behavior:
A1 should show a dropdown list.
Facts:
- Issue can be reproduce if you copy the content of the validity list into
another sheet/file.
Here you can read the log of the repairs by MS Office:
<?xml version="1.0" encoding="UTF-8" standalone="true"?>
-<recoveryLog
xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main";>
<logFileName>error082200_01.xml</logFileName>
<summary>Errors were detected in file 'H:\Products\LibreOffice\2014_04_28
(Dropdown list)\Szakagi_alkalmazas_ertekelolap.xlsx'</summary>
-<removedFeatures summary="Following is a list of removed features:">
<removedFeature>Removed Feature: Data validation from /xl/worksheets/sheet1.xml
part</removedFeature>
</removedFeatures>
</recoveryLog>
--
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
