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 2009/02/15 10:13:11 UTC
DO NOT REPLY [Bug 46714] New: method 'setRowSumsBelow(false)'
doesn't work fine
https://issues.apache.org/bugzilla/show_bug.cgi?id=46714
Summary: method 'setRowSumsBelow(false)' doesn't work fine
Product: POI
Version: 3.0
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: mxlong.nj@gmail.com
Created an attachment (id=23257)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=23257)
the result iamge
Hello
I use POI 3.0 to create a Excel file with outline. And I use the method
"setRowSumsBelow" to put detail below row summaries.
But when I open my file in MS EXCEL 2000 or Open Office, the row summaries
appear below detail in the outline even if I put true or false to the
method.
I hope you understand my problem.
------------------start------------------
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet("sheet1");
HSSFRow row;
HSSFCell cell;
sheet.setRowSumsBelow(false);
row = sheet.createRow(0);
cell = row.createCell(0);
cell.setCellValue("group");
for(int i=1;i<9;i++){
row = sheet.createRow(i);
cell = row.createCell(0);
cell.setCellValue("value"+i);
}
sheet.groupRow(1, 8);
try {
FileOutputStream fs = new FileOutputStream("./test.xls");
workbook.write(fs);
fs.close();
} catch (IOException e) {
e.printStackTrace();
}
------------------end------------------
result image is as 'result.bmp', but the wanted result is as 'wanted.bmp'.
atattched files: 'result.bmp' and 'wanted.bmp'.
if I want to get the result as 'wanted.bmp' image, how to code?
--
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 46714] method 'setRowSumsBelow(false)' doesn't
work fine
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46714
--- Comment #1 from Meng XiaoLong <mx...@gmail.com> 2009-02-15 01:14:32 PST ---
Created an attachment (id=23258)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=23258)
the result image
--
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 46714] method 'setRowSumsBelow(false)' doesn't
work fine
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46714
Meng XiaoLong <mx...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |mxlong.nj@gmail.com
--
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 46714] method 'setRowSumsBelow(false)' doesn't
work fine
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46714
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
--- Comment #4 from Yegor Kozlov <ye...@dinom.ru> 2009-04-18 02:12:05 PST ---
Fixed in r766273 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=766273 )
I changed sheet.setRowSumsBelow to propagate the boolean flag to
sheet.setAlternativeExpression. These two methods work in conjunction.
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 46714] method 'setRowSumsBelow(false)' doesn't
work fine
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46714
--- Comment #2 from Meng XiaoLong <mx...@gmail.com> 2009-02-15 01:15:29 PST ---
Created an attachment (id=23259)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=23259)
the weanted iamge
--
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 46714] method 'setRowSumsBelow(false)' doesn't
work fine
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46714
Meng XiaoLong <mx...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #23259|the weanted iamge |the wanted iamge
description| |
--
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 46714] method 'setRowSumsBelow(false)' doesn't
work fine
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46714
Adam <ak...@a9k.co.uk> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |ak.apache@a9k.co.uk
--- Comment #3 from Adam <ak...@a9k.co.uk> 2009-02-27 03:07:26 PST ---
I think this is a duplicate of
https://issues.apache.org/bugzilla/show_bug.cgi?id=30714
Try calling sheet.setAlternativeExpression(false); instead until it is fixed
properly
--
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