getHighestRow() not working properly

Hello , I was trying to use getHighestRow() to get the last row of my excel sheet but it appears to pick up some row slightly above it. Is there a limit to the no. of rows this command can browse....

Id #21462 | Release: None | Updated: Sat at 8:42 AM by akshebs | Created: Fri at 5:12 PM by akshebs

"no impact" to formats on Conditional Formatting Broken

At the very least for number format, but I think for a number of the other formats. The no impact formatting is not working properly. (See https://phpexcel.codeplex.com/discussions/261155 for not...

Id #21454 | Release: None | Updated: Wed at 4:34 PM by wiseloren | Created: Wed at 4:28 PM by wiseloren

xls reader after writer with Dropdown color showing white and not working

Hello, I am using php-excel library for multipurpose use . I am reading xls file using below code $objPHPExcel = new PHPExcel(); $objReader = PHPExcel_IOFactory::createReader('Excel5'); $objPHPEx...

Id #21450 | Release: None | Updated: Oct 14 at 9:29 AM by alpeshkasodariya | Created: Oct 14 at 5:04 AM by alpeshkasodariya

Inaccurate data about getHighestRow()

i am trying to get the last row that contains data in an excel workbook the problem is in some sheets i get the correct data but in other sheets i don't , i tried to change my code by using getHigh...

Id #21415 | Release: None | Updated: Oct 6 at 8:11 AM by amashety | Created: Oct 6 at 8:11 AM by amashety

Error evaluating formula

I've found an error evaluating a formula: VLOOKUP($E$4;$korslistor.$B$36:$P$54;H9;0) I'm referencing a range in the sheet 'korslistor' as $korslistor.$B$36:$P$54, so in Calculation.php line 3327 $...

Id #21409 | Release: None | Updated: Oct 3 at 7:24 AM by MarkBaker | Created: Oct 2 at 1:28 PM by Angelon

column sum=0, until "Enable Editing" button is clicked

I calculate the sum for a column, all okay, except the sum always equals 0. When I select the "Enable Editing" button the accurate value is displayed. code excerpt: include ('../classes/PHPExcel....

Id #21388 | Release: None | Updated: Sep 26 at 5:21 PM by tewhite0723 | Created: Sep 26 at 5:21 PM by tewhite0723

net::ERR_CONNECTION_RESET

When I try to run the example:Examples/07reader.php, it always gets this error. The special thing of myself is that my test site is not using default port 80, but use 8010. http://127.0.0.1:8010/...

Id #21363 | Release: None | Updated: Sep 22 at 1:29 PM by ch_feng | Created: Sep 22 at 1:29 PM by ch_feng

Multiple duplicateStyle() calls applying to previous cells

I have the following code: $output = $objOutputExcel->getActiveSheet(); $template = $objTemplateExcel->getActiveSheet(); $output->duplicateStyle($template->getStyle('A1'), 'A1'); $output->du...

Id #21346 | Release: None | Updated: Sep 19 at 6:29 PM by Fluffydough | Created: Sep 19 at 6:22 PM by Fluffydough

CHIDIST problem

Hi, I compared PHPExcel's CHIDIST output with that of other online applications and PHP code: http://www.danielsoper.com/statcalc3/calc.aspx?id=11 http://graphpad.com/quickcalcs/PValue1.cfm PHP ...

Id #21291 | Release: None | Updated: Sep 10 at 10:11 AM by MarkBaker | Created: Sep 10 at 9:28 AM by oferu

removerow does not remove the formatting

So I have a table with the following format: A "row" of data is merged three rows in A, B and D while C is divided into three rows (A is name, B is ID, C is the three components, D is the date). ...

Id #21281 | Release: None | Updated: Sep 9 at 2:14 AM by phponrails | Created: Sep 9 at 2:14 AM by phponrails