Bug 46719 - ShiftRows(...) will change unrelated rows' height
Summary: ShiftRows(...) will change unrelated rows' height
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.5-dev
Hardware: PC Windows XP
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-02-17 00:26 UTC by Matthew
Modified: 2009-02-25 11:13 UTC (History)
0 users



Attachments
input file for testing (14.08 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2009-02-17 00:26 UTC, Matthew
Details
output.xlsx, the first row's height is changed (11.09 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2009-02-17 00:27 UTC, Matthew
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Matthew 2009-02-17 00:26:45 UTC
Created attachment 23265 [details]
input file for testing

I run following codes which only shift 1 row (start from row number 15). But the output file first row's height is changed (which is reset to same as other rows height).

Please use the attached "input.xlsx" for testing.
"output.xlsx" is the output file.

--

Workbook wb = new XSSFWorkbook("input.xlsx");
Sheet sheet = wb.getSheet("CommericalInvoice");
sheet.shiftRows(15, sheet.getLastRowNum(), 1, true, true);		
wb.write(new FileOutputStream("output.xlsx"));
Comment 1 Matthew 2009-02-17 00:27:27 UTC
Created attachment 23266 [details]
output.xlsx, the first row's height is changed
Comment 2 Yegor Kozlov 2009-02-25 11:13:36 UTC
Fixed in r747894

Yegor