https://bugs.documentfoundation.org/show_bug.cgi?id=115159
Bug ID: 115159
Summary: FILESAVE XLSX Print Titles are duplicated every time
we export an XLSX file
Product: LibreOffice
Version: 5.4.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: filter:xlsx
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 139270
--> https://bugs.documentfoundation.org/attachment.cgi?id=139270&action=edit
Example file made with Excel 2013
If we create simple Print Titles with Microsoft Excel 2010/2013/2016 and export
the file with LibreOffice Calc, the Print Titles are duplicated.
Steps to reproduce:
1. Create a new spreadsheet with Microsoft Excel 2010/2013/2016.
2. Fill the first row with some data.
3. Select the worksheet range that you want to include titles when print.
4. Go to Page Layout tab, click Print Titles.
5. Click on the select button in Rows to repeat at top area and select a title
row (the first row you fill with data.)
6. Press OK to finish setting.
7. Check the new Print titles which you have set, at the Formulas, Name Manager
tab.
8. Save the file as *.xlsx.
9. Open the file with LibreOffice Calc 5.4.4 and save as Print_Title_LO-54.xlsx
and reload it.
10. Check the Print Titles at the Sheet-→Named Ranges and Expressions-→Manager
tab. (There will be a duplicated Print Titles)
Actual results:
After we reload the file there will be a duplicated Print Titles
(_xlnm.Print_Tiles_0). If we open the exported file with Microsoft Excel and
check the Name Manager, there will be only the original Print Titles, but the
duplicated will not be there.
If we export the Print_Title_LO-54.xlsx file with LibreOffice Calc again (this
is the second time), at the Sheet-→Named Ranges and Expressions-→Manager will
be two duplicated Print Titles (_xlnm.Print_Tiles_0 and _xlnm.Print_Tiles_0_0).
If we open this file with Microsoft Excel and check the Name Manager, we will
see one duplicated Print Titles (Print_Tiles_0). And so it goes on.
Comment: This bug can be produced only with these settings and steps. In the
same way you can set column(s) to repeat at the left of each page, but in this
case the Print Titles will not be duplicated. The Print Areas not duplicated at
LibreOffice 5.4.4.
Expected results:
The Print Titles should not be duplicated after we export the *.xlsx file with
LibreOffice Calc.
Version: 5.4.4.2
Build az.: 2524958677847fb3bb44820e40380acbe820f960
CPU szálak: 4; OS: Windows 6.1; Felületmegjelenítés: alapértelmezett;
Területi beállítások: hu-HU (hu_HU); Calc: group
Version: 6.0.0.1.0+
Build ID: c678dc5309741097d9b0265f03dd279a8794d256
CPU threads: 4; OS: Windows 6.1; UI render: default;
TinderBox: Win-x86@42, Branch:libreoffice-6-0, Time: 2017-12-28_04:21:33
Locale: hu-HU (hu_HU); Calc: group
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
