Force recalculation of entire worksheet

Is there a method to force the recalculation of an entire worksheet? I've been through all of the documentation and haven't found anything. What appears to be my issue, is I have a very complex w...

Id #21177 | Release: None | Updated: Thu at 9:59 PM by MarkBaker | Created: Thu at 6:13 PM by bahoover

Excell 2003 file not in the proper Microsoft Excel 2003 XLS format

I'm generating a Excell 2003 using this code: $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('toUploadFtp.xls'); And I can read the file with MS E...

Id #21171 | Release: None | Updated: Thu at 9:17 AM by jokiruiz | Created: Wed at 1:37 PM by jokiruiz

Xls created opens in excel but not in other programs

I have a hospital managment system and I need to create xls from web forms, I've done the work and everything seems to work fine, but the file says "wrong file format" when I try to import it. If I...

Id #21154 | Release: None | Updated: Jul 16 at 7:40 PM by MarkBaker | Created: Jul 16 at 6:59 PM by erandipiti

How to enable outlining/group column with sheet protection in phpexcel?

I want to protect whole sheet and some cells are unprotected. But When I group/outline column, it prevent collapse/expand column. How to use below code in php? Private Sub Workbook_Open() Dim ...

Id #21149 | Release: None | Updated: Jul 16 at 6:28 AM by jalpakothari | Created: Jul 16 at 6:28 AM by jalpakothari

Error opening sheet open and save files in the same

hi there, 'm opening a sheet which already has a formula and information from previous days, I add in new data in the cell and close the document to open the document in ms office excel.   a ze...

Id #21144 | Release: None | Updated: Jul 14 at 9:19 PM by felipezc | Created: Jul 14 at 9:17 PM by felipezc

Fatal error when saving xlsx to xls without editing

Hello! I try to read xlsx file and save it to xls using php code: $objPHPexcel = PHPExcel_IOFactory::load($uploaded_file); $objWriter = PHPExcel_IOFactory::createWriter($objPHPexcel, 'Excel5'); $ob...

Id #21142 | Release: None | Updated: Jul 13 at 7:08 PM by chokochokomail | Created: Jul 13 at 7:08 PM by chokochokomail

Error in reading date value

I am getting problem in reading date value. In my excel file, I have the value as 03-07-2014 (dd-mm-yyyy) format. but when I read this, I get the value as 07-03-14 & when I store this value to da...

Id #21129 | Release: None | Updated: Jul 7 at 2:19 PM by nitin_cdac | Created: Jul 7 at 2:19 PM by nitin_cdac

objReader -> Load not working

I am trying to access and load a .xlsx file (that is generated by me) but the load function is not working.. PHP code: if($_POST['machineList'] == 'OK) { echo 'Under maintenance<br/>'; $filenam...

Id #21128 | Release: None | Updated: Jul 7 at 1:08 PM by viktor92 | Created: Jul 7 at 1:08 PM by viktor92

PHPExcel_Shared_Date::PHPToExcel - timezone

Hello, I've noticed that params $adjustToTimezone = FALSE, $timezone = NULL aren't used in scope of that function. In order for function to function properly you could implement following solutio...

Id #21127 | Release: None | Updated: Jul 7 at 1:01 PM by czeslav87 | Created: Jul 7 at 12:52 PM by czeslav87

1.8.0 cann't get images from xlsx generated by Google Docs

If I save Google Sheet with images as XLSX, I can get only text data from workbook by PHPExcel. When I open this XLSX file by MS Excel and save it without any changes, I'll can get images. After r...

Id #21117 | Release: None | Updated: Jul 3 at 5:06 AM by baxsmaxbax | Created: Jul 3 at 5:06 AM by baxsmaxbax