Excel : Row numbers are missing in sheet information

Talk about anything at all....

Excel : Row numbers are missing in sheet information

Postby NKR8 » Mon Apr 20, 2020 2:32 pm

Hi,

I am working on a Excel parser. I am parsing rows information from the sheetX.xml where sheetX is the ID of the worksheet.
In one of Excel file, on which I have to do parsing, row number information is missing as below:

Image

Here, in above image, "r" attribute is missing for row tag.

Do you have any idea why this happens?

Thank you in advance.
Last edited by MrProgrammer on Mon Apr 20, 2020 6:34 pm, edited 1 time in total.
Reason: "I am working on a Excel parser." → Moved topic from Calc forum to General Discussion
OpenOffice 4.1.7
Operating System: Windows 10
NKR8
 
Posts: 12
Joined: Mon Nov 18, 2019 1:42 pm

Re: Excel : Row numbers are missing in sheet information

Postby Zizi64 » Mon Apr 20, 2020 2:36 pm

Please upload a real .xlsx sample file here.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9444
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Excel : Row numbers are missing in sheet information

Postby NKR8 » Mon Apr 20, 2020 3:59 pm

Attaching the file
Attachments
AnalysisReport.xlsx
Error file
(11.14 KiB) Downloaded 30 times
OpenOffice 4.1.7
Operating System: Windows 10
NKR8
 
Posts: 12
Joined: Mon Nov 18, 2019 1:42 pm

Re: Excel : Row numbers are missing in sheet information

Postby Zizi64 » Mon Apr 20, 2020 4:15 pm

I just tried to open your file with my AOO 4.1.5 portable, and LO 6.2.8. AOO and LO can not open the file. The error message: The file is corrupt.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9444
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Excel : Row numbers are missing in sheet information

Postby NKR8 » Mon Apr 20, 2020 4:24 pm

What is LO and AOO? Sorry, but I am not aware of these terms.
I have OpenOffice downloaded. I opened Excel file with OpenOffice calc. It is opened in there.
OpenOffice 4.1.7
Operating System: Windows 10
NKR8
 
Posts: 12
Joined: Mon Nov 18, 2019 1:42 pm

Re: Excel : Row numbers are missing in sheet information

Postby Zizi64 » Mon Apr 20, 2020 6:02 pm

What is LO and AOO? Sorry, but I am not aware of these terms.

AOO is the Apache OpenOffice, and the LO is the LibreOffice. Your OpenOffice 4.1.7 _is_ Apache OpenOffice really.
The maintainer of the LO is The Document Fundation.
(LO has a little bit higher compatibility with the foreign file formats.)
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9444
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Excel : Row numbers are missing in sheet information

Postby Zizi64 » Mon Apr 20, 2020 6:18 pm

How you created that .xlsx file?
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9444
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Excel : Row numbers are missing in sheet information

Postby NKR8 » Mon Apr 20, 2020 7:01 pm

This .xlsx file is generated by a external Windows software.
OpenOffice 4.1.7
Operating System: Windows 10
NKR8
 
Posts: 12
Joined: Mon Nov 18, 2019 1:42 pm

Re: Excel : Row numbers are missing in sheet information

Postby Villeroy » Mon Apr 20, 2020 7:09 pm

It does not produce valid Excel files.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28443
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 2 guests