Problem with cell formating with Excel 2013 and 365

Hi, I used PHPExcel to generate a very complicated Excel, and worked good for Excel 2010 and Earlier. See Image named 2010-earlier. Howerver, I updated my Excel to 2013, and major cell formating de...

Id #21978 | Release: None | Updated: Aug 17 at 9:03 PM by descormiers | Created: Aug 17 at 9:03 PM by descormiers

chart formula problem

I have an excel sheet with a chart on and the data formula is =(all!$C$4,all!$C$11,all!$C$18,all!$C$25,all!$C$32,all!$C$39,all!$C$46,all!$C$53,all!$C$60,all!$C$67,all!$C$74,all!$C$81) I am gettin...

Id #21966 | Release: None | Updated: Aug 10 at 6:57 AM by shaunie1970 | Created: Aug 10 at 6:57 AM by shaunie1970

Unknown codepage: 10017

Error while reading excel file. I has created a patch to add this codepage and some number of other mac codepages. Patch number: 17729 Index: Classes/PHPExcel/Shared/CodePage.php ==================...

Id #21961 | Release: None | Updated: Aug 5 at 9:52 AM by atz | Created: Aug 5 at 9:51 AM by atz

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