Bug 143410 - XLSX File doesn't view properly.
Summary: XLSX File doesn't view properly.
Status: RESOLVED NOTOURBUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.4.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: XLSX-External-Generators
  Show dependency treegraph
 
Reported: 2021-07-16 14:52 UTC by Simon Napper
Modified: 2021-07-17 13:28 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
Column headers not visible (11.28 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2021-07-16 14:53 UTC, Simon Napper
Details
Excel-Calc screenshot (181.36 KB, image/png)
2021-07-16 14:58 UTC, Simon Napper
Details
Screenshot with the message error opening with excel (20.25 KB, image/png)
2021-07-16 17:37 UTC, m.a.riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Simon Napper 2021-07-16 14:52:19 UTC
Description:
When I open the file, the column headings are missing. Excel shows them to be present.

Steps to Reproduce:
1.Open the file
2. Compare the results with excel
3.

Actual Results:
Column headers are missing.

Expected Results:
Column headers present


Reproducible: Always


User Profile Reset: No



Additional Info:
I can provide the example file that you can see and/or screenshot of comparison of Excel/Calc
Comment 1 Simon Napper 2021-07-16 14:53:28 UTC
Created attachment 173635 [details]
Column headers not visible

This is the file that doesn't show headers.
Comment 2 Simon Napper 2021-07-16 14:58:52 UTC
Created attachment 173636 [details]
Excel-Calc screenshot

Shows the different views of the same file.
Comment 3 m.a.riosv 2021-07-16 17:37:34 UTC
Created attachment 173639 [details]
Screenshot with the message error opening with excel

Seems there is same error in the file, like the error message opening with excel show. Excel it's able to recover it, while LibreOffice not.

Should be more a request for enhancement to recover files with error like this one.
Comment 4 Gabor Kelemen (allotropia) 2021-07-17 10:09:40 UTC
app.xml says:

<Properties xmlns="http://schemas.openxmlformats.org/officeDocument/2006/extended-properties"><Application>Apache POI</Application></Properties>

Another observation: if I split the merged cells in A1:T2 or U1:BH2 then everything becomes visible in the third row that was somehow hidden, in:

Version: 7.2.0.0.beta1+ / LibreOffice Community
Build ID: 65dee56eed2111dfbe923ef82b3ba41a4c5edf75
CPU threads: 2; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: hu-HU (hu_HU.UTF-8); UI: en-US
Calc: threaded

But considering that both attachment 173636 [details] and attachment 173639 [details] shows this file is not valid according to Excel, I'd say this is a bug in the Apache POI generator or the way it was used.
Comment 5 Buovjaga 2021-07-17 13:28:04 UTC
Ok, let's close as notourbug