You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2017/03/08 07:58:57 UTC
[Bug 60833] New: Initialisation of record 0x31 left 4 bytes
remaining still to be read.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60833
Bug ID: 60833
Summary: Initialisation of record 0x31 left 4 bytes remaining
still to be read.
Product: POI
Version: unspecified
Hardware: PC
Status: NEW
Severity: major
Priority: P2
Component: HSSF
Assignee: dev@poi.apache.org
Reporter: yoker.wu@gmail.com
Target Milestone: ---
Created attachment 34808
--> https://bz.apache.org/bugzilla/attachment.cgi?id=34808&action=edit
this is a report table received from email.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 60833] Initialisation of record 0x31 left 4 bytes remaining
still to be read.
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60833
--- Comment #6 from lintongchuan <li...@qq.com> ---
There is no problem opening the file using Microsoft Excel on Mac operating
system
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 60833] Initialisation of record 0x31 left 4 bytes remaining
still to be read.
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60833
Xiaohong Yang <xy...@yahoo.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |xyang200@yahoo.com
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 60833] Initialisation of record 0x31 left 4 bytes remaining
still to be read.
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60833
--- Comment #10 from Tim Allison <ta...@mitre.org> ---
Stats from our regression corpus on which Excel records cause
LeftoverDataExceptions (Record \t number of exceptions).
0x850(ChartFRTInfoRecord) 763 (Bug 47247)
0x85(BoundSheetRecord) 95
0x1D(SelectionRecord) 35
0x31(FontRecord) 15
0x203(NumberRecord) 8
0x42(CodepageRecord) 5
0x3C(ContinueRecord) 2
0x868(FeatRecord) 2
0x5B(FileSharingRecord) 1
0x5F(SaveRecalcRecord) 1
0xE(PrecisionRecord) 1
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 60833] Initialisation of record 0x31 left 4 bytes remaining still to be read.
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60833
qi20088 <20...@qq.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |2099206@qq.com
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 60833] Initialisation of record 0x31 left 4 bytes remaining
still to be read.
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60833
--- Comment #8 from Tim Allison <ta...@mitre.org> ---
We have 15 stacktraces like this in our regression corpus for Tika. I was
hoping from the file attached here (first) and the file attached on Bug 57093
(second), that the first byte or two specified a length somehow.
However, from govdocs1 085890.xls (third), it looks like junk at the end of the
font record. By junk, of course, I mean, "I don't understand why it's
there"...like junk DNA. :) But seriously, in 085890.xls, when I open the file
in Excel and search for "providing", I don't find anything.
First line is font name : length
Remaining lines are: byte index : byte&0xff : char (if above 20)
FONT NAME:黑体 : 2
0 : 0 :
1 : 0 :
2 : 0 :
3 : 0 :
FONT NAME:MS Sans Serif : 13
0 : 19 :
1 : 0 :
2 : 1 :
3 : 0 :
4 : 0 :
5 : 88 : X
6 : 1 :
7 : 0 :
8 : 0 :
9 : 89 : Y
10 : 95 : _
11 : 41 : )
12 : 63 : ?
13 : 95 : _
14 : 41 : )
15 : 59 : ;
16 : 95 : _
17 : 40 : (
18 : 64 : @
19 : 95 : _
20 : 41 : )
21 : 0 :
FONT NAME:MS Sans Serif : 13
0 : 116 : t
1 : 129 :
2 : 84 : T
3 : 73 : I
4 : 84 : T
5 : 85 : U
6 : 84 : T
7 : 73 : I
8 : 79 : O
9 : 78 : N
10 : 95 : _
11 : 80 : P
12 : 82 : R
13 : 79 : O
14 : 86 : V
15 : 73 : I
16 : 68 : D
17 : 73 : I
18 : 78 : N
19 : 71 : G
20 : 95 : _
21 : 68 : D
22 : 65 : A
23 : 84 : T
24 : 65 : A
25 : 95 : _
26 : 73 : I
27 : 68 : D
28 : 10 :
29 : 0 :
30 : 0 :
31 : 67 : C
32 : 79 : O
33 : 78 : N
34 : 84 : T
35 : 65 : A
36 : 67 : C
37 : 84 : T
38 : 95 : _
39 : 73 : I
40 : 68 : D
41 : 20 :
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 60833] Initialisation of record 0x31 left 4 bytes remaining
still to be read.
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60833
--- Comment #2 from Dominik Stadler <do...@gmx.at> ---
FYI, Bug 57093 sounds similar.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 60833] Initialisation of record 0x31 left 4 bytes remaining
still to be read.
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60833
--- Comment #5 from lintongchuan <li...@qq.com> ---
I have the same exception when reading xls file
the stack trace
org.apache.poi.hssf.record.RecordInputStream$LeftoverDataException:
Initialisation of record 0x31(FontRecord) left 4 bytes remaining still to be
read.
at
org.apache.poi.hssf.record.RecordInputStream.hasNextRecord(RecordInputStream.java:177)
~[poi-3.16.jar:3.16]
at
org.apache.poi.hssf.record.RecordFactoryInputStream.nextRecord(RecordFactoryInputStream.java:234)
~[poi-3.16.jar:3.16]
at
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:494)
~[poi-3.16.jar:3.16]
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:348)
~[poi-3.16.jar:3.16]
at
org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:99)
~[poi-ooxml-3.16.jar:3.16]
at
org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:182)
~[poi-ooxml-3.16.jar:3.16]
at
org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:144)
~[poi-ooxml-3.16.jar:3.16]
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 60833] Initialisation of record 0x31 left 4 bytes remaining
still to be read.
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60833
--- Comment #7 from lintongchuan <li...@qq.com> ---
(In reply to lintongchuan from comment #5)
> I have the same exception when reading xls file
> the stack trace
> org.apache.poi.hssf.record.RecordInputStream$LeftoverDataException:
> Initialisation of record 0x31(FontRecord) left 4 bytes remaining still to be
> read.
> at
> org.apache.poi.hssf.record.RecordInputStream.hasNextRecord(RecordInputStream.
> java:177) ~[poi-3.16.jar:3.16]
> at
> org.apache.poi.hssf.record.RecordFactoryInputStream.
> nextRecord(RecordFactoryInputStream.java:234) ~[poi-3.16.jar:3.16]
> at
> org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:
> 494) ~[poi-3.16.jar:3.16]
> at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:348)
> ~[poi-3.16.jar:3.16]
> at
> org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:99)
> ~[poi-ooxml-3.16.jar:3.16]
> at
> org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:182)
> ~[poi-ooxml-3.16.jar:3.16]
> at
> org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:144)
> ~[poi-ooxml-3.16.jar:3.16]
There is no problem opening the file using Microsoft Excel on Mac operating
system,
when I open the excel file using Microsoft Excel , then save it as another
file, another file can be correctly read and process.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 60833] Initialisation of record 0x31 left 4 bytes remaining
still to be read.
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60833
yoker.wu@gmail.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
--- Comment #3 from yoker.wu@gmail.com ---
@Javen O'Neal
this file can open without any errors in Microsoft Excel or WPS application.
i tested on poi-3.15.jar.
this is my code.
public static void main(String[] args) throws Exception{
String fileName = "F:\\Desktop\\buzhengc.xls";
InputStream inputStream = new FileInputStream(fileName);
POIFSFileSystem fs = new POIFSFileSystem(inputStream);
DirectoryEntry root = fs.getRoot();
System.out.println(root.getEntryNames());
HSSFWorkbook hssfworkbook = new HSSFWorkbook(fs);
System.out.println(hssfworkbook.getNameName(0));
}
i got this errors:
[Workbook]
Exception in thread "main"
org.apache.poi.hssf.record.RecordInputStream$LeftoverDataException:
Initialisation of record 0x31(FontRecord) left 4 bytes remaining still to be
read.
at
org.apache.poi.hssf.record.RecordInputStream.hasNextRecord(RecordInputStream.java:174)
at
org.apache.poi.hssf.record.RecordFactoryInputStream.nextRecord(RecordFactoryInputStream.java:253)
at
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:494)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:341)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:304)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:251)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:221)
at com.test.pppp.main(test.java:26)
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 60833] Initialisation of record 0x31 left 4 bytes remaining
still to be read.
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60833
--- Comment #4 from yoker.wu@gmail.com ---
Created attachment 34812
--> https://bz.apache.org/bugzilla/attachment.cgi?id=34812&action=edit
The Excel BIFF output file created by BIFFVIEW.exe
I found another problem.
there is a WINDOW2 record before at ROW record.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 60833] Initialisation of record 0x31 left 4 bytes remaining still to be read.
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60833
--- Comment #12 from PJ Fanning <fa...@yahoo.com> ---
Similar issue in https://bz.apache.org/bugzilla/show_bug.cgi?id=68854 (with
reproducible case)
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 60833] Initialisation of record 0x31 left 4 bytes remaining
still to be read.
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60833
--- Comment #11 from Slava <sl...@gmail.com> ---
I'm experiencing same issue while using TIKA, the failure is very annoying and
preventing from us to parse many excel files.
Thanks
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: [Bug 60833] Initialisation of record 0x31 left 4 bytes
remaining still to be read.
Posted by hong_derek <ho...@qq.com>.
I have got the same problem with POI 3.15.
Exception LeftoverDataException was throw in RecordInputStream.java:
public boolean hasNextRecord() throws LeftoverDataException {
if (_currentDataLength != -1 && _currentDataLength != _currentDataOffset)
{
throw new LeftoverDataException(_currentSid, remaining());
}
if (_currentDataLength != DATA_LEN_NEEDS_TO_BE_READ) {
_nextSid = readNextSid();
}
return _nextSid != INVALID_SID_VALUE;
}
While _currentDataLength is 24 and _currentDataOffset is 20.
And the error message as follow:
Exception in thread "main"
org.apache.poi.hssf.record.RecordInputStream$LeftoverDataException:
Initialisation of record 0x31(FontRecord) left 4 bytes remaining still to be
read.
at
org.apache.poi.hssf.record.RecordInputStream.hasNextRecord(RecordInputStream.java:174)
at
org.apache.poi.hssf.record.RecordFactoryInputStream.nextRecord(RecordFactoryInputStream.java:253)
at
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:494)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:341)
at
org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:95)
at
org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:178)
at
org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:140)
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Bug-60833-New-Initialisation-of-record-0x31-left-4-bytes-remaining-still-to-be-read-tp5726833p5726985.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 60833] Initialisation of record 0x31 left 4 bytes remaining
still to be read.
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60833
Javen O'Neal <on...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
OS| |All
--- Comment #1 from Javen O'Neal <on...@apache.org> ---
Thanks for the bug report and including the problematic file.
Before I spend time researching this, it would help us if you could answer a
few questions.
I'm assuming you get an exception (what exception class?) with the message
"Initialisation of record 0x31 left 4 bytes remaining still to be read" when
you open the workbook with
> Workbook wb = WorkbookFactory.create(new File("buzhengc.xls"));
If not, please include a stack trace and sample code so that we can reproduce
the problem.
What version of POI are you using?
Is there anything written to stderr or the POILogger, that would suggest why we
were 4 bytes short?
Does this file open without any errors in Microsoft Excel or other spreadsheet
application? If so, what version?
Thanks in advance for the info.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 60833] Initialisation of record 0x31 left 4 bytes remaining
still to be read.
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60833
--- Comment #9 from Tim Allison <ta...@mitre.org> ---
Whoa... and govdocs1/093/093996.xls has seven font records with an extra 1918
bytes!
No intelligible text (on a quick look)...
FONT NAME:MS Sans Serif : 13
0 : 149 :
1 : 129 :
2 : 95 : _
3 : 41 : )
4 : 59 : ;
5 : 95 : _
...
1893 : 0 :
1894 : 115 : s
1895 : 142 :
1896 : 78 : N
1897 : 0 :
1898 : 75 : K
1899 : 161 :
1900 : 78 : N
1901 : 0 :
1902 : 3 :
1903 : 180 :
1904 : 78 : N
1905 : 0 :
1906 : 227 :
1907 : 198 :
1908 : 78 : N
1909 : 0 :
1910 : 145 :
1911 : 214 :
1912 : 78 : N
1913 : 0 :
1914 : 48 : 0
1915 : 65 : A
1916 : 85 : U
1917 : 8 :
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 60833] Initialisation of record 0x31 left 4 bytes remaining still to be read.
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60833
--- Comment #13 from PJ Fanning <fa...@yahoo.com> ---
*** Bug 68854 has been marked as a duplicate of this bug. ***
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org