Bug 54768

Summary: [PATCH] Modify SheetDataWriter to allow writing spans attribute for each row
Product: POI Reporter: Kulbhushan Singhal <coolkulbhushan>
Component: SXSSFAssignee: POI Developers List <dev>
Status: NEEDINFO ---    
Severity: enhancement Keywords: PatchAvailable
Priority: P2    
Version: 3.9-FINAL   
Target Milestone: ---   
Hardware: All   
OS: All   
Attachments: Modifies SXSSFRow to accept start and end span properties. Also, modifies SheetDataWriter to write (if present) these properties to row tag.

Description Kulbhushan Singhal 2013-03-29 13:25:06 UTC
Created attachment 30118 [details]
Modifies SXSSFRow to accept start and end span properties. Also, modifies SheetDataWriter to write (if present) these properties to row tag.

Currently SXSSFRow does not allow to specify "spans" attribute for a row. Even though it is an optional attribute but excel uses it for optimization internally.

The patch allows SXSSFRow to accept start span and end span properties from the user (optional). If this property is specified SheetDataWriter.writeRow(int rownum, SXSSFRow row) will add this attribute while writing the row element.

Output:
<row r="8" spans="4:6"> (if spans are specified)
<row r="8"> (if spans are not specified)
Comment 1 Nick Burch 2014-08-07 13:56:35 UTC
Ideally, before applying this, we would some unit tests to verify it works correctly. The other concern is that it's SXSSF only, and something like this should probably be present for both SXSSF and XSSF, so ideally we'd want a patch that updates it for both