Bug 20048

Summary: [PATCH][RFE] Add a way to change the focused cell with usermodel API
Product: POI Reporter: Toshiaki Kamoshida <kamoshida.toshiaki>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED WONTFIX    
Severity: minor    
Priority: P3    
Version: 2.0-pre3   
Target Milestone: ---   
Hardware: Other   
OS: other   
Attachments: PATCH to do it.

Description Toshiaki Kamoshida 2003-05-20 04:53:10 UTC
I found a demand to change the focused cell at each sheets with usermodel API.
Please add a way to do it.
Comment 1 Toshiaki Kamoshida 2003-05-20 07:30:15 UTC
Created attachment 6418 [details]
PATCH to do it.
Comment 2 Toshiaki Kamoshida 2003-05-20 07:37:06 UTC
Please apply the patch and excect it and check "Test1.xls" and "Test2.xls"
with Excel Application.

import java.io.FileOutputStream;

import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class Test {

	public static void main(String[] args) throws Exception{
		HSSFWorkbook book = new HSSFWorkbook();
		HSSFSheet s1 = book.createSheet("Test1");
		book.write(new FileOutputStream("Test1.xls"));
		s1.setActiveCell(10,(short)10);
		book.write(new FileOutputStream("Test2.xls"));
	}
}
Comment 3 Andy Oliver 2003-07-24 16:35:50 UTC
have we done this yet?  I thought we did.
Comment 4 Avik Sengupta 2003-07-31 19:22:45 UTC
HSSFCell.setAsActiveCell()

Please reopen if that doesnot solve your problem. Thanks.