Invalid cell coordinates with ! separator

I'm using PHPExcel to get calculated values from an Excel file, and a lot of the calculations involve VLOOKUPs from other sheets in the workbook. Every time I encounter an exclamation point followe...

Id #21949 | Release: None | Updated: Jul 23 at 1:32 PM by ChrisOlsen | Created: Jul 22 at 1:33 PM by ChrisOlsen

Date is changed while get cell value via xlsx file

Hi there, I am using PHPExcel version 1.7.8. Issue which i am facing is, In xls file one cell set as date and value is 1/26/2015. But while i get the value using PHPExcel then it is converting to...

Id #21929 | Release: None | Updated: Jun 30 at 12:24 PM by flynik53 | Created: Jun 30 at 12:24 PM by flynik53

Excel File Disappears

I am opening an existing excel file and adding form information to it. It works but when I add an image using PHPExcel_Worksheet_Drawing() the first time it will save and show up but the next time...

Id #21924 | Release: None | Updated: Jun 28 at 11:58 PM by HManhart | Created: Jun 28 at 11:58 PM by HManhart

Merged cells borders not working in pdf conversion.

I have created the pdf file via mdf6.0 and PHPExcel is used to create the excel with the images, merged cells using version 2.1. Everything is working as expected, except the borders. It's not disp...

Id #21919 | Release: None | Updated: Jun 25 at 2:04 PM by Poornimapriya | Created: Jun 25 at 2:04 PM by Poornimapriya

Accounting Formatted Cells

Please add the Accounting format for Excel 2007 and above: const FORMAT_ACCOUNTING = ‘_(“$”* #,##0.00_);_(“$”* (#,##0.00);_(“$”* “-“??_);(@)';

Id #21916 | Release: None | Updated: Jun 24 at 2:46 PM by M34Inc | Created: Jun 24 at 2:46 PM by M34Inc

Losing formula on editing/saving file

I use dropdowns and styling on a range of cells (eg: A3:A100). The export of this excel file is successful. After editing the file with records and saving it, the dropdown formulas and styling on...

Id #21898 | Release: None | Updated: Jun 5 at 12:24 PM by sankalpt | Created: Jun 5 at 12:24 PM by sankalpt

Problem with the format cells

When editing in line 674 PHPExcel/Style/NumberFormat.php use $value = preg_replace($number_regex, $value, $format); //, where: $number_regex = '/(0+)(\.?)(0*)/'; $value = '20,430.11' $format = '...

Id #21897 | Release: None | Updated: Jun 5 at 8:18 AM by anry | Created: Jun 5 at 8:18 AM by anry

Encrypt with Password

I want use this plugin do something that require a password to open this workbook. how to?

Id #21882 | Release: None | Updated: Jun 26 at 2:40 PM by M34Inc | Created: May 27 at 3:28 AM by ihlfo

PhpExcel crash php on solaris 10

I try to use the first sample of phpExcel (https://phpexcel.codeplex.com/wikipage?title=Examples&referringTitle=Home ) I have a Segmentation Fault when I try to use phpExcel. I have a version 5.27 ...

Id #21879 | Release: None | Updated: May 21 at 2:12 PM by fabrice_89 | Created: May 21 at 2:12 PM by fabrice_89

Clone throws error for sqlite3

Hi I'm trying to reduce the memory foot print for some reports that uses clone But i get this problems: From 06largescale-with-cellcaching-sqlite3.php // Add data for ($i = 2; $i <= 5000; $i++) { ...

Id #21864 | Release: None | Updated: May 18 at 3:38 PM by Hilding_76 | Created: May 18 at 3:32 PM by Hilding_76