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:
| Updated: Aug 17 at 9:03 PM by descormiers | Created: Aug 17 at 9:03 PM by descormiers
I have an excel sheet with a chart on and the data formula is
I am gettin...
Id #21966 | Release:
| Updated: Aug 10 at 6:57 AM by shaunie1970 | Created: Aug 10 at 6:57 AM by shaunie1970
Error while reading excel file.
I has created a patch to add this codepage and some number of other mac codepages.
Patch number: 17729
Id #21961 | Release:
| Updated: Aug 5 at 9:52 AM by atz | Created: Aug 5 at 9:51 AM by atz
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:
| Updated: Jul 23 at 1:32 PM by ChrisOlsen | Created: Jul 22 at 1:33 PM by ChrisOlsen
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:
| Updated: Jun 30 at 12:24 PM by flynik53 | Created: Jun 30 at 12:24 PM by flynik53
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:
| Updated: Jun 28 at 11:58 PM by HManhart | Created: Jun 28 at 11:58 PM by HManhart
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:
| Updated: Jun 25 at 2:04 PM by Poornimapriya | Created: Jun 25 at 2:04 PM by Poornimapriya
Please add the Accounting format for Excel 2007 and above:
const FORMAT_ACCOUNTING = ‘_(“$”* #,##0.00_);_(“$”* (#,##0.00);_(“$”* “-“??_);(@)';
Id #21916 | Release:
| Updated: Jun 24 at 2:46 PM by M34Inc | Created: Jun 24 at 2:46 PM by M34Inc
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:
| Updated: Jun 5 at 12:24 PM by sankalpt | Created: Jun 5 at 12:24 PM by sankalpt
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:
| Updated: Jun 5 at 8:18 AM by anry | Created: Jun 5 at 8:18 AM by anry