Excel : Row numbers are missing in sheet information

Talk about anything at all....
Post Reply
NKR8
Posts: 12
Joined: Mon Nov 18, 2019 1:42 pm

Excel : Row numbers are missing in sheet information

Post by NKR8 »

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
User avatar
Zizi64
Volunteer
Posts: 11359
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Excel : Row numbers are missing in sheet information

Post by Zizi64 »

Please upload a real .xlsx sample file here.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
NKR8
Posts: 12
Joined: Mon Nov 18, 2019 1:42 pm

Re: Excel : Row numbers are missing in sheet information

Post by NKR8 »

Attaching the file
Attachments
AnalysisReport.xlsx
Error file
(11.14 KiB) Downloaded 199 times
OpenOffice 4.1.7
Operating System: Windows 10
User avatar
Zizi64
Volunteer
Posts: 11359
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Excel : Row numbers are missing in sheet information

Post by Zizi64 »

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; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
NKR8
Posts: 12
Joined: Mon Nov 18, 2019 1:42 pm

Re: Excel : Row numbers are missing in sheet information

Post by NKR8 »

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
User avatar
Zizi64
Volunteer
Posts: 11359
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Excel : Row numbers are missing in sheet information

Post by Zizi64 »

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; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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: 11359
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Excel : Row numbers are missing in sheet information

Post by Zizi64 »

How you created that .xlsx file?
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
NKR8
Posts: 12
Joined: Mon Nov 18, 2019 1:42 pm

Re: Excel : Row numbers are missing in sheet information

Post by NKR8 »

This .xlsx file is generated by a external Windows software.
OpenOffice 4.1.7
Operating System: Windows 10
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Excel : Row numbers are missing in sheet information

Post by Villeroy »

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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply