https://bugs.freedesktop.org/show_bug.cgi?id=69749
Priority: medium
Bug ID: 69749
Assignee: [email protected]
Summary: FILEOPEN: Importing Excel (xls) books including
scenarios results in extra sheets
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.1.2 release
Component: Spreadsheet
Product: LibreOffice
Problem description:
If you open Excel (xls) books including scenarios, you get extra sheets whose
names are shown in blue. Each of those sheets contain values for a scenario.
If you print the document or export it as a PDF, those sheets are also printed.
Steps to reproduce:
1. Get an Excel book including scenarios and open it with Calc.
http://www.openoffice.org/sc/testdocs/index.html
http://www.openoffice.org/sc/testdocs/scenarios_import_biff8_12.xls
2. See extra sheets appear.
3. If you print the whole book, those extra sheets are also printed.
Current behavior:
See above.
Expected behavior:
Ideally those Excel scenarios are imported as Calc's scenarios.
Or at least they should not be treated as a visible part of the worksheet.
Additional info:
- It might be a valid feature, but I could not found any reference to it on the
User Guide or Wiki.
- Apache OO 3.4.1 / 4.0.0 also exhibit the same problem.
- I found the following OOo-era bug report which says the import function had
been implemented in OOo 3 circa 2009.
https://issues.apache.org/ooo/show_bug.cgi?id=99426
- I also found an ancient bug report c.2007 in downstream Ubuntu bug database,
which claims the exact same issue. They just ignored it then.
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/159844
Operating System: Windows 7
Version: 4.1.1.2 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
