PHPExcel Kills data validation after editing the existing excel sheet

I have created an excel sheet and put some validations on it. Now I tried to edit this excel sheet through PHPExcel Library but when I edit it, all the validations that already exists in sheet are ...

Id #20936 | Release: None | Updated: Thu at 12:05 PM by ryadav13 | Created: Thu at 12:05 PM by ryadav13

Preserving the cell validations when entering the new value

I wan't to edit an excel sheet through PHPExcel, but when it set the value of the cell, the validation that already exists for that cell is killed. So can anybody tell me how to preserve the cells ...

Id #20934 | Release: None | Updated: Thu at 10:37 AM by ryadav13 | Created: Thu at 10:37 AM by ryadav13

Cell Validation failure on exceeding the "setFormula1()" argument length to 255 characters

I have to put the list validation on one field but when the drop down list options characters exceed to 255 character excel not open properly, it ask "Excel found unreadable content in (file name) ...

Id #20930 | Release: None | Updated: Wed at 3:25 PM by ryadav13 | Created: Wed at 3:25 PM by ryadav13

Issue with date validation after reading and saving an XLSX file

Hello, I have an Excel file that serves me as a template which I read with PHPExcel, add some data to a new sheet and export again. Several cells in this file have validation set up, one of them ...

Id #20910 | Release: None | Updated: Apr 10 at 2:19 PM by eperfa | Created: Apr 10 at 2:12 PM by eperfa

Read filter for ODS files is not working

Hi, First of all I want to thank you for your efforts in creating a very good library for reading and creating spreadsheet files. I noticed a problem and I want to inform you. The problem occur o...

Id #20907 | Release: None | Updated: Apr 10 at 7:49 AM by AndreiMiron | Created: Apr 10 at 7:49 AM by AndreiMiron

Php Excel run slower on Windows Server x64

Hello, We developed one of our aplication using PHPExcel to generate .xls file. First we use an Windows Server 2003 R2 x86 and everything was working fine. After one month we migrated the applicat...

Id #20901 | Release: None | Updated: Apr 9 at 1:20 PM by vladchiorpec88 | Created: Apr 9 at 1:20 PM by vladchiorpec88

PHPExcel removing lookup from excel sheet rows

I have been editing my excel sheet using PHPExcel. ITs editing perfectly except removing all the dropdown from rows and shifting them to first row. In actual, these dropdown should be on all rows e...

Id #20900 | Release: None | Updated: Apr 9 at 12:20 PM by MarkBaker | Created: Apr 9 at 11:13 AM by neha_mangla

Countifs() not working with multiple criterias

Countifs() does not work with multiple criterias / ranges

Id #20897 | Release: None | Updated: Apr 9 at 7:19 AM by iD0QS | Created: Apr 9 at 6:23 AM by iD0QS

Call to a member function detach() on a non-object

Fatal error: Call to a member function detach() on a non-object in /var/www/... /PHPExcel/CachedObjectStorage/PHPTemp.php on line 61 What could be the cause?

Id #20880 | Release: None | Updated: Apr 4 at 12:30 PM by realtebo | Created: Apr 4 at 12:30 PM by realtebo

Global named ranges are truncated

There are a couple of issues with named ranges. When extracting cells from a formula, it is breaking down a named range in error. See Test case. function testParseRange() { $formulaBlock = "=...

Id #20863 | Release: None | Updated: Mar 27 at 5:57 PM by frank_s | Created: Mar 27 at 5:54 PM by frank_s