Bug 20048 - [PATCH][RFE] Add a way to change the focused cell with usermodel API
Summary: [PATCH][RFE] Add a way to change the focused cell with usermodel API
Status: RESOLVED WONTFIX
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 2.0-pre3
Hardware: Other other
: P3 minor (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-05-20 04:53 UTC by Toshiaki Kamoshida
Modified: 2004-11-16 19:05 UTC (History)
0 users



Attachments
PATCH to do it. (546 bytes, patch)
2003-05-20 07:30 UTC, Toshiaki Kamoshida
Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
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.