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 2011/02/08 06:27:39 UTC
DO NOT REPLY [Bug 50728] New: file error about setting 255th column
width
https://issues.apache.org/bugzilla/show_bug.cgi?id=50728
Summary: file error about setting 255th column width
Product: POI
Version: 3.7
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: katsu.shoka@gmail.com
i setted the width of 255th column. i got a file error when i try to open the
Excel file.
Excel version: Microsoft Office Excel 2003 SP3
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=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
DO NOT REPLY [Bug 50728] file error about setting 255th column width
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50728
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #8 from Yegor Kozlov <ye...@dinom.ru> 2011-06-18 09:53:48 UTC ---
I still can't reproduce it. Setting size of 255th column in a new workbook
works OK. Below is my test code that produces output readable both by Excel
2003 and Excel 2010:
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet();
HSSFCell cell = sheet.createRow(0).createCell(255);
cell.setCellValue("xxxxxxxxxxx");
sheet.setColumnWidth(255, 76*256);
FileOutputStream fileOut = new FileOutputStream("bug-50728.xls");
wb.write(fileOut);
fileOut.close();
You sample code depends on "workbook1.xls", if it is required to reproduce the
bug then please attach this file too.
I'm using the latest build from trunk.
Yegor
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=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
DO NOT REPLY [Bug 50728] file error about setting 255th column width
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50728
--- Comment #1 from katsu <ka...@gmail.com> 2011-02-08 00:29:04 EST ---
Created an attachment (id=26618)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=26618)
java source
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=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
DO NOT REPLY [Bug 50728] file error about setting 255th column width
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50728
Nick Burch <ni...@alfresco.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #3 from Nick Burch <ni...@alfresco.com> 2011-02-08 07:24:06 EST ---
Does the problem happen if you size the 254th cell, or only the 255th? Do all
sizings produce the error on the 255th, or only some?
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=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
DO NOT REPLY [Bug 50728] file error about setting 255th column width
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50728
katsu <ka...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=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
DO NOT REPLY [Bug 50728] file error about setting 255th column width
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50728
--- Comment #7 from katsu <ka...@gmail.com> 2011-02-14 01:22:17 EST ---
i created a new workbook, and setted the width of 255th column.
please check the source code and the result .xls file that i attachmented on
2011-02-08.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=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
DO NOT REPLY [Bug 50728] file error about setting 255th column width
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50728
katsu <ka...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
--- Comment #4 from katsu <ka...@gmail.com> 2011-02-08 18:42:17 EST ---
The problem didn't happen when i sized the 254th column.i use the method of
setColumnWidth(int columnIndex, int width).if i do
sheet.setColumnWidth(255,...) that i always get an error.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=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
DO NOT REPLY [Bug 50728] file error about setting 255th column width
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50728
--- Comment #6 from katsu <ka...@gmail.com> 2011-02-14 01:22:02 EST ---
i created a new workbook, and setted the width of 255th column.
please check the source code and the result .xls file that i attachmented on
2011-02-08.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=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
DO NOT REPLY [Bug 50728] file error about setting 255th column width
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50728
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #5 from Yegor Kozlov <ye...@dinom.ru> 2011-02-10 08:26:15 EST ---
Setting width of 255th column works OK for new files. I tested trunk for both
HSSF and XSSF.
Please attach the input .xls file. I suspect it is the culprit.
Yegor
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=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
DO NOT REPLY [Bug 50728] file error about setting 255th column width
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50728
--- Comment #2 from katsu <ka...@gmail.com> 2011-02-08 00:30:56 EST ---
Created an attachment (id=26619)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=26619)
error file
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=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