https://bugs.documentfoundation.org/show_bug.cgi?id=112566
Bug ID: 112566
Summary: FILESAVE XLSX Spreadsheets with data validation from
external file XLSX export issue when the external file
is not present
Product: LibreOffice
Version: 5.4.1.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: filter:xlsx
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: kelem...@ubuntu.com
Created attachment 136456
--> https://bugs.documentfoundation.org/attachment.cgi?id=136456&action=edit
The source data file.
If an XLSX spreadsheet created with Microsoft Excel 2013 contains data
validation from an external XLSX file, and the external file is not present
while the spreadsheet is saved as XLSX with LibreOffice Calc, the link to the
source file is not retained and the following error message appears when the
document is opened in Microsoft Excel 2013:
Removed Records: Named range from /xl/workbook.xml part (Workbook).
Steps to reproduce:
1. Create a new spreadsheet in Microsoft Excel.
2. Add values to a few cells in a column (the attached vsource.xlsx file uses
raptors as an example but it should work with other kind of dinosaurs too).
3. Select the cell range that contains the data.
4. Click on the Define Name on the Formulas ribbon.
5. Give a new name to the datarange, e.g.: Raptors.
6. Save the file as vsource.xlsx, but do not close it yet!
7. Create a new spreadsheet in Excel while still keeping the previously created
file open.
8. Click on the Define Name on the Formulas ribbon, give it a name (e.g.:
RaptorSource) and fill out the “Refers to:” field like this:
='vsource.xlsx'!Raptors
9. Click on the Data Validation button on the Data ribbon.
10. Select the “List” option from the “Allow” drop-down list.
11. Enter the following in the Source field: =RaptorSource
12. Save it as ValidityFromExternalFile-original.xlsx and close the file.
13. Close the vsource.xlsx file.
14. Move the source data file (vsource.xlsx) to a different location.
15. Open the second spreadsheet in LibreOffice Calc and save it as a new XLSX
file called ValidityFromExternalFile-LO.xlsx.
16. Open the ValidityFromExternalFile-LO.xlsx file with Microsoft Excel.
Actual results:
The link to the source file is not retained and the following error message
appears when the spreadsheet is opened in Microsoft Excel 2013: Removed
Records: Named range from /xl/workbook.xml part (Workbook).
Expected results:
The link to the original source file should be retained even if the file is no
longer available, and the spreadsheet should open in Excel without an error
message.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
