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:
Here, in above image, "r" attribute is missing for row tag.
Do you have any idea why this happens?
Thank you in advance.
Excel : Row numbers are missing in sheet information
Excel : Row numbers are missing in sheet information
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
Reason: "I am working on a Excel parser." → Moved topic from Calc forum to General Discussion
OpenOffice 4.1.7
Operating System: Windows 10
Operating System: Windows 10
Re: Excel : Row numbers are missing in sheet information
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.
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.
Re: Excel : Row numbers are missing in sheet information
Attaching the file
- Attachments
-
- AnalysisReport.xlsx
- Error file
- (11.14 KiB) Downloaded 199 times
OpenOffice 4.1.7
Operating System: Windows 10
Operating System: Windows 10
Re: Excel : Row numbers are missing in sheet information
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.
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.
Re: Excel : Row numbers are missing in sheet information
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.
I have OpenOffice downloaded. I opened Excel file with OpenOffice calc. It is opened in there.
OpenOffice 4.1.7
Operating System: Windows 10
Operating System: Windows 10
Re: Excel : Row numbers are missing in sheet information
AOO is the Apache OpenOffice, and the LO is the LibreOffice. Your OpenOffice 4.1.7 _is_ Apache OpenOffice really.What is LO and AOO? Sorry, but I am not aware of these terms.
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.
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.
Re: Excel : Row numbers are missing in sheet information
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.
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.
Re: Excel : Row numbers are missing in sheet information
This .xlsx file is generated by a external Windows software.
OpenOffice 4.1.7
Operating System: Windows 10
Operating System: Windows 10
Re: Excel : Row numbers are missing in sheet information
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice