[Libreoffice-bugs] [Bug 118668] New: Librecalc doesn't show all sheets

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118668

Bug ID: 118668
Summary: Librecalc doesn't show all sheets
Product: LibreOffice
Version: 6.0.5.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-***@lists.freedesktop.org
Reporter: ***@yandex.ru

Description:
Librecalc doesn't find the second sheet in the workbook.

Steps to Reproduce:
1. Open attached file


Actual Results:
You can't find the second sheet.

Expected Results:
You can find the second sheet


Reproducible: Always


User Profile Reset: No



Additional Info:
Gnumeric opens this file well.

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118668

--- Comment #1 from Ilya Zubakin <***@yandex.ru> ---
Created attachment 143426
--> https://bugs.documentfoundation.org/attachment.cgi?id=143426&action=edit
buggy file

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118668

Mike Kaganski <***@hotmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Ever confirmed|0 |1
OS|Linux (All) |All
Status|UNCONFIRMED |NEW

--- Comment #2 from Mike Kaganski <***@hotmail.com> ---
Reproducible using Version: 6.1.0.1 (x64)
Build ID: 378e26bd4f22a135cef5fa17afd5d4171d8da21a
CPU threads: 4; OS: Windows 10.0; UI render: default;
Locale: ru-RU (ru_RU); Calc: CL

Specifically: when opening in LibreOffice, the second sheet is hidden, and
available in menu Sheet→Show Sheet...

In Excel 2013, both sheets are visible right away.

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118668

Ilya Zubakin <***@yandex.ru> changed:

What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |UNCONFIRMED
Ever confirmed|1 |0

--- Comment #3 from Ilya Zubakin <***@yandex.ru> ---
Thanks, I see it. Why is the second disabled?

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118668

Mike Kaganski <***@hotmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Ever confirmed|0 |1
Status|UNCONFIRMED |NEW

--- Comment #4 from Mike Kaganski <***@hotmail.com> ---
(In reply to Ilya Zubakin from comment #3)

Post by b***@bugs.documentfoundation.org
Thanks, I see it. Why is the second disabled?

Because presumably there's a bug that needs investigation; that I had confirmed
in my comment 1, and you have set back to UNCONFIRMED for some reason.

Setting back to NEW.

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118668

Xisco Faulí <***@libreoffice.org> changed:

What |Removed |Added
----------------------------------------------------------------------------
CC| |***@libreoffice.org

--- Comment #5 from Xisco Faulí <***@libreoffice.org> ---
Created attachment 143449
--> https://bugs.documentfoundation.org/attachment.cgi?id=143449&action=edit
Second sheet displayed in MSO Excel

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118668

Xisco Faulí <***@libreoffice.org> changed:

What |Removed |Added
----------------------------------------------------------------------------
Version|6.0.5.2 release |Inherited From OOo

--- Comment #6 from Xisco Faulí <***@libreoffice.org> ---
Also reproducible in


Version: 4.3.0.0.alpha1+
Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e

Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)

LibreOffice 3.3.0
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118668

Timur <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Summary|Librecalc doesn't show all |Librecalc doesn't show all
|sheets |sheets from specific XLSX

--- Comment #7 from Timur <***@gmail.com> ---
If buggy XLSX is saved in MSO 2013 or 2016, than LO opens both sheets.

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118668

--- Comment #8 from Timur <***@gmail.com> ---
sheet2.xml from attached xlsx:
<sheetView workbookViewId="0" zoomScale="200" zoomScaleNormal="23"
view="pageBreakPreview">
<selection activeCell="T9" sqref="T9"/>
</sheetView>

sheet2.xml from saved xlsx:
<sheetView tabSelected="1" view="pageBreakPreview" zoomScale="200"
zoomScaleNormal="23" workbookViewId="0">
<selection activeCell="T9" sqref="T9"/>
</sheetView>

tabSelected="1" is missing in original xlsx.

If more than one SheetView.TabSelected is set to true, it looks like Excel just
picks the first one. Maybe also the same if it's missing from all sheets, like
with attached xlsx.

Ilya, please describe how the spreadsheet was generated, e.g. Excel (which
version) and how it was manually modified with which software.

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118668

--- Comment #9 from Ilya Zubakin <***@yandex.ru> ---
This spreadsheet was saved with MSO 2016 then modified with exceljs v1.5.1
(https://github.com/guyonroche/exceljs/).
I modified it with older version exceljs and all works fine for me.

Thanks for your help. I am going to open the issue in exceljs project.

By the way, Calc opens the source file without this problem.

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118668

--- Comment #10 from Ilya Zubakin <***@yandex.ru> ---
Created attachment 143520
--> https://bugs.documentfoundation.org/attachment.cgi?id=143520&action=edit
Source file

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118668

--- Comment #11 from Mike Kaganski <***@hotmail.com> ---
(In reply to Timur from comment #8)

If it is the tabSelected attribute that causes this, then we have a bug with
that. The attribute is used to indicate (possibly multiple) selection of
sheets, not their visibility. And it is optional (according to
ECMA-376-1:2016).

Anyway, this is a proper bug report, which shouldn't be closed until fixed.

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118668

Bartosz <***@poczta.onet.pl> changed:

What |Removed |Added
----------------------------------------------------------------------------
Summary|Librecalc doesn't show all |FILEOPEN XLSX Librecalc
|sheets from specific XLSX |doesn't show all sheets

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118668

Roman Kuznetsov <***@mail.ru> changed:

What |Removed |Added
----------------------------------------------------------------------------
Keywords| |filter:xlsx
Blocks| |108897


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker