Merge Cell in column but keep all data?

[spyhunter88 <sp...@yahoo.com.vn>]

I want to merge some cell in a column and keep only upper-most data. 3 Cell
has the same value: 10000.
sheet.addMergedRegion(new CellRangeAddress(1, 3, 25, 25));

But in the result, when select the merged cell, Excel say: "*Average: 10000,
Total: 3, Sum: 30000*"

That cause my pivot (in other sheet) calculate wrong. I do want keep only
upper-most data value like manual merge in MS Excel Application.

Is there any options or this is bug?



--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Merge-Cell-in-column-but-keep-all-data-tp5714717.html
Sent from the POI - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org