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 2012/04/25 09:05:55 UTC
DO NOT REPLY [Bug 53144] New: First comment not cloned after
cloneSheet()
https://issues.apache.org/bugzilla/show_bug.cgi?id=53144
Bug #: 53144
Summary: First comment not cloned after cloneSheet()
Product: POI
Version: 3.8
Platform: PC
OS/Version: Windows Vista
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: ishii@infoteria.com
Classification: Unclassified
Created attachment 28674
--> https://issues.apache.org/bugzilla/attachment.cgi?id=28674
Test output file. res.xls
A cell's comment is not cloned.
The comment is a comment processed by the 1st.（May be）
public static void test() {
try {
InputStream is= new FileInputStream("test.xls");
Workbook workbook = WorkbookFactory.create(is);
is.close();
Sheet sheet = workbook.cloneSheet(workbook.getSheetIndex("TEST1"));
workbook.setSheetName(workbook.getSheetIndex(sheet), "TEST2");
FileOutputStream os = new FileOutputStream("res.xls");
workbook.write(os);
os.close();
} catch (Exception e) {
e.printStackTrace();
}
}
[res.xls : attachment]
A sheet(TEST1) has 2 cells(A1,B1) that has comment.
A cell(A1) on sheet(TEST2) has not comment.
TEST2 cloned from TEST1.
--
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
[Bug 53144] First comment not cloned after cloneSheet()
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53144
--- Comment #6 from Evgeniy Berlog <su...@gmail.com> ---
Hi Arimitsu
Source file you've attached contains 2 comments for cell B1. However Excel
correctly reads this file. Can you please explain me, how did you create such
file using Excel or POI tools, so I will understand whether this file is
corrupted and you should only create new file or consider this situation more
detailed.
Regards, Evgeniy
--
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 53144] First comment not cloned after cloneSheet()
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53144
--- Comment #2 from Arimitsu <is...@infoteria.com> ---
I get source files from SVN trunk,and Test on 20 august.
Exception at [workbook.write(os);]
java.lang.IllegalStateException: found multiple cell comments for cell $B$1
at
org.apache.poi.hssf.usermodel.HSSFPatriarch.preSerialize(HSSFPatriarch.java:110)
at org.apache.poi.hssf.usermodel.HSSFSheet.preSerialize(HSSFSheet.java:144)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.getBytes(HSSFWorkbook.java:1248)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:1167)
--
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 53144] First comment not cloned after cloneSheet()
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53144
--- Comment #5 from Arimitsu <is...@infoteria.com> ---
Test source code is the same as before.
The Excel file(test.xls) used for the test attached at 2012-08-27 02:33.
Regards,
--
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 53144] First comment not cloned after cloneSheet()
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53144
--- Comment #4 from Arimitsu <is...@infoteria.com> ---
Created attachment 29282
--> https://issues.apache.org/bugzilla/attachment.cgi?id=29282&action=edit
A file for test input
--
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 53144] First comment not cloned after cloneSheet()
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53144
Evgeniy Berlog <su...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |FIXED
--- Comment #1 from Evgeniy Berlog <su...@gmail.com> ---
This problem should be fixed in trunk.
Please try with a nightly build - see download links on http://poi.apache.org/
or build yourself from SVN trunk, see http://poi.apache.org/subversion.html
--
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 53144] First comment not cloned after cloneSheet()
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53144
--- Comment #7 from Arimitsu <is...@infoteria.com> ---
Hi
I should have checked again using other files.
I'm sorry.
I have forgotten how the old test file was created.
I created test file newly and checked that a clone of the first comment was
performed.
Regards,
--
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 53144] First comment not cloned after cloneSheet()
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53144
--- Comment #3 from Evgeniy Berlog <su...@gmail.com> ---
According to the exception one of your sheets contains two or more comments for
single cell. Please attach to this ticket source code and input file to
reproduce this exception.
Regards, Evgeniy
--
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