Not too wise to takc this post onto a completely unrelated thread as most of the people reading the list are likely to have completely missed it just as I did.
Having said that, I think you are labouring under a missaphrehension about the CellRangeAddress class. These objects are not intended to support a cut and paste operation at all, rather they are used to identify a range of cells that are to be merged (merged cells are treated as a single cell) or named. If you want to cut and paste cells between sheets, you will have to write the code to support this process. Yours Mark B Zachary Mitchell, BCIS wrote: > > - How do I use CellRangeAddress objects to copy/cut and paste > an area of cells from an HSSFSheet to another? > > removeMergedRegion(int index); //cut > getMergedRegion(int index); //copy > > in HSSFSheet, > > Using these in fonjuction with CellRangeAddress? > > I believe I understand what to do, > > but the api documentation for these POI classesdoesn't tell me > > what the above int indexes should be? > > Do I assume they start from 1? > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscr...@poi.apache.org > For additional commands, e-mail: user-h...@poi.apache.org > > > -- View this message in context: http://old.nabble.com/POI-XSSF-API-how-do-I-lock-specific-Excel-sheet-features--tp27332341p27611301.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
