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 2008/11/11 15:47:21 UTC
DO NOT REPLY [Bug 46186] New: method groupRow does not work
https://issues.apache.org/bugzilla/show_bug.cgi?id=46186
Summary: method groupRow does not work
Product: POI
Version: 3.2-FINAL
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: regression
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: dsmirnov@topsbi.ru
Created an attachment (id=22855)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=22855)
excel file
reroducing step:
1. I'm created src.xls file in Excel and after that
2. I'm create HSSFWorkbook on the basis of existing excel file
3. group some row
4. I'm open new dst.xls and group row id absent.
This is bug. src.xls in attach
simple code:
public class Test {
public static void main(String[] args) throws Exception {
HSSFWorkbook(StreamUtil.getInputStream("c:\\src.xls"));
HSSFSheet sheet = wb.getSheetAt(0);
sheet.groupRow(5,10); // <-- look here
final FileOutputStream out = new FileOutputStream(new
File("C:\\dst.xls"));
try {
wb.write(out);
} finally {
out.close();
}
}
}
--
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 46186] method groupRow does not work
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46186
Bob Stox <bs...@dkintl.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Version|3.5-dev |3.2-FINAL
--- Comment #4 from Bob Stox <bs...@dkintl.com> 2009-03-13 12:05:20 PST ---
The Problem was that in 3.2 a new variable was added to the Sheet class
_gutsRecord but it was never initialized when in the Sheet(RecordStream rs)
constructor. I just added the code to check for the GutsRecord.sid and the
assign the record to the variable
--
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 46186] method groupRow does not work
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46186
--- Comment #1 from Yegor Kozlov <ye...@dinom.ru> 2008-11-11 08:19:36 PST ---
Did it work with earlier versions of POI? I checked your code with 3.0.2 and it
doesn't work either. It seems to be not a regression, something is special with
your src.xls.
How was this file created? Using POI or manually in Excel? Which version?
groupRow() works fine when creating new sheets but somehow doesn't work for the
attached file.
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 46186] method groupRow does not work
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46186
--- Comment #2 from Dmitry Smirnov <ds...@topsbi.ru> 2008-11-11 08:32:22 PST ---
this is excel file was created in 2003 excel sp3 and save as microsoft excel
97...
Im tested it on poi 3.2 version.
For poi version 3.0.1 groupRow working fine.
sorry for bad test, this is better
public static void main(String[] args) throws Exception {
HSSFWorkbook wb = new HSSFWorkbook(new FileInputStream("c:\\src.xls"));
HSSFSheet sheet = wb.getSheetAt(0);
sheet.groupRow(5, 10); // <-- look here
final FileOutputStream out = new FileOutputStream(new
File("C:\\dst.xls"));
try {
wb.write(out);
} finally {
out.close();
}
}
--
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 46186] method groupRow does not work
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46186
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
--- Comment #5 from Yegor Kozlov <ye...@dinom.ru> 2009-04-18 02:09:38 PST ---
Fixed in r766273 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=766273 )
Regards,
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 46186] method groupRow does not work
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46186
Ralf Tossenberger <ra...@cool2work.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |ralf.tossenberger@cool2work.
| |com
Version|3.2-FINAL |3.5-dev
--- Comment #3 from Ralf Tossenberger <ra...@cool2work.com> 2008-12-20 07:42:21 PST ---
Same problem with 3.5 Beta 4, using Office 2003 (Windows) or Office 2007/8
(Mac)
If Workbook / Sheet was created new --> works
If Workbook / Sheet was loaded from file --> doesn't work
I tried the attached src.xls, tried a new one - fresh created with same data,
tried an empty one - created inside Windows explorer with create new Excel.
--
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