Php Excel Bar chart.

I want to change the color of each bar in my bar chart , the chart is like: There are four products product 1 product 2 product 3 product 4 There are two bars for each product, one is total value...

Id #20956 | Release: None | Updated: Wed at 11:33 AM by rajman | Created: Wed at 11:33 AM by rajman

PHPExcel reader and load fails to load the validations of the excel sheet properly

I have an excel sheet, which you can find in the attachments, that has some validations (mainly drop down validations list). I have to edit this excel sheet and then submit it. when I create a read...

Id #20955 | Release: None | Updated: Wed at 9:50 AM by ryadav13 | Created: Wed at 9:50 AM by ryadav13

PHPExcel CUMIPMT is giving different output than Excel CUMIPMT function

I am trying to calculate CUMIPMT using PHPExcel and I seem to be getting different output from MS Excel and PHPExcel In MS Excel if I enter the following formula =CUMIPMT(0.015,31.57,2000,1,31.57,...

Id #20954 | Release: None | Updated: Wed at 8:25 AM by shairyar | Created: Wed at 8:24 AM by shairyar

Segmentation fault

I'm getting a segmentation fault every single time I read an xls. i'm using 1.7.9, but i've same problem after upgrading to 1.8.0 How can I debug ?

Id #20953 | Release: None | Updated: Tue at 4:03 PM by realtebo | Created: Tue at 3:56 PM by realtebo

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 #20949 | Release: None | Updated: Mon at 2:07 PM by neha_mangla | Created: Mon at 8:52 AM by ryadav13

Preserving the cell validation when entering the new value in it.

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 #20948 | Release: None | Updated: Mon at 8:49 AM by ryadav13 | Created: Mon at 8:49 AM by ryadav13

countif issue

Hi, had a problem where the COUNTIF function counts the cells with no content (empty) in a comparison of lower than (<=) values​​. Ex. A1 = 10 A2 = 12 A3 = (empty) A4 = 15 A5 = 16 A6 = 11 A7 = =...

Id #20942 | Release: None | Updated: Sun at 6:11 AM by fsantiago72 | Created: Sun at 6:09 AM by fsantiago72

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: Apr 17 at 12:05 PM by ryadav13 | Created: Apr 17 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: Apr 17 at 10:37 AM by ryadav13 | Created: Apr 17 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: Apr 16 at 3:25 PM by ryadav13 | Created: Apr 16 at 3:25 PM by ryadav13