Strange behavior in saving a big cell text !~~~~~!!

Topics: Developer Forum, User Forum
Oct 16, 2011 at 8:57 AM

hi all,

     while i trying to save a big text(a string more than 10K chars) into a cell, something happened.

the big cell have been saved successfully ,but other cells followed by  disappeared!!!!

the code:

		$one_desc = $the_big_data;    // this is the big cell value more than 10k chars
		$one_com = 'This is the sample data'; //other cell
		$cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_to_discISAM;  
		//create workbook & wooksheet
		$objPHPExcel = new PHPExcel();
		// Creating a worksheet
		$objPHPExcel->getActiveSheet()->SetCellValue('A1', $one_desc);
		$objPHPExcel->getActiveSheet()->SetCellValue('C1', $one_com);
		$objPHPExcel->getActiveSheet()->SetCellValue('A2', $one_com);
		$objPHPExcel->getActiveSheet()->SetCellValue('A5', $one_com);
 		$objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);
		if(!file_exists(APP . 'webroot/files/tmp/')) {
			mkdir(APP . 'webroot/files/tmp/');
		$tmpfname = tempnam(APP . 'webroot/files/tmp/', 'tapdtmp'.time());

the result is:
the value of A1 is the big data, but other cells disappeared!!!!!
anyone know this? is it a bug? or ....

Oct 17, 2011 at 3:21 AM

is my office's problem......