/* ExportComposer.java

	Purpose:
		
	Description:
		
	History:
		November 05, 5:53:16 PM     2010, Created by Ashish Dasnurkar

Copyright (C) 2010 Potix Corporation. All Rights Reserved.
 */
package org.zkoss.zssessentials.export;

import java.io.*;
import java.util.Locale;

import org.zkoss.poi.ss.usermodel.ZssContext;
import org.zkoss.zk.ui.event.Event;
import org.zkoss.zk.ui.util.GenericForwardComposer;
import org.zkoss.zss.model.*;
import org.zkoss.zss.ui.Spreadsheet;
import org.zkoss.zss.ui.impl.Utils;
import org.zkoss.zul.*;

/**
 * @author hawk
 * 
 */
public class ExportToExcelComposer extends GenericForwardComposer {
	Spreadsheet spreadsheet;

	public ExportToExcelComposer(){
		ZssContext.setThreadLocal(new ZssContext(Locale.GERMAN,-1));
	}
	
	public void onClick$exportBtn(Event evt) throws IOException {
		Book wb = spreadsheet.getBook();
		Exporter c = Exporters.getExporter("excel");
		ByteArrayOutputStream baos = new ByteArrayOutputStream();
		c.export(wb, baos);
		Filedownload.save(baos.toByteArray(), "application/file",
				wb.getBookName());
	}
	
	public void onClick$setFormula(){
		//set local to Polish
		org.zkoss.poi.ss.usermodel.Cell cell = Utils.getOrCreateCell(spreadsheet.getSelectedSheet(), 1, 0);
		cell.setCellFormula("A1*0.8");
	}
	
	public void onClick$setFormulaWithRange(){
		Ranges.range(spreadsheet.getSelectedSheet(), 2,0).setEditText("=A1*0.8");
	}
}