Bug 162936 - Calc shown an empty file when open this file, but it is OK en Excel
Summary: Calc shown an empty file when open this file, but it is OK en Excel
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.1.2 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: XLSX-External-Generators
  Show dependency tree / graph
 
Reported: 2024-09-12 23:59 UTC by Angel
Modified: 2024-09-22 14:52 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
File I can´t see the content (9.26 MB, application/vnd.ms-excel)
2024-09-13 00:01 UTC, Angel 		Details
fixed file (132.26 KB, application/x-bzip2)
2024-09-13 07:12 UTC, Julien Nabet 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Angel 2024-09-12 23:59:36 UTC 
Description:
This file is Ok en Excel, but when it is opened in Calc nothing is shown, like an empty file.

FILEOPEN

Steps to Reproduce:
1.Just open the attached file
2.It is shown as an empty file
3.

Actual Results:
The data content is not shown

Expected Results:
I would like to seen the data inside the file


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 24.8.1.2 (X86_64) / LibreOffice Community
Build ID: 87fa9aec1a63e70835390b81c40bb8993f1d4ff6
CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win
Locale: es-AR (es_AR); UI: es-ES
Calc: threaded
Comment 1 Angel 2024-09-13 00:01:41 UTC 
Created attachment 196415 [details]
File I can´t see the content

I have also tried to open it with version 24.2.2 and I had the same problem
Comment 2 Xisco Faulí 2024-09-13 06:34:55 UTC 
When I open it, I get this message in console:

136610:13: </Workbook>
                       ^
malformed_xml_error: error parsing encoded character: terminating character is not found. (offset=9707542)
Comment 3 Julien Nabet 2024-09-13 07:12:51 UTC 
Created attachment 196419 [details]
fixed file

I replaced "& SPA" by "&amp; SPA" with this command line on Linux:
sed -i 's/& SPA/&amp; SPA/g' testjul.xml
it worked.

(I bzipped the fixed file)
Comment 4 Bogaboga Man 2024-09-13 17:17:08 UTC 
Could reproduce!
Environment:
Version: 24.8.1.2 (X86_64) / LibreOffice Community
Build ID: 87fa9aec1a63e70835390b81c40bb8993f1d4ff6
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win
Locale: en-CA (en_CA); UI: en-GB
Calc: CL threaded
Comment 5 ady 2024-09-13 17:49:09 UTC 
FWIW, Excel also complains about some kind of mismatch between the internal format and the file name extension.

Was this file actually created by Excel itself? Is this file perhaps created by some other tool (which exports the data to some file, intended to be opened by Excel)?