Return #N/A error when use partial vlookup

I used PhpExcel to write a Excel2007 file. In cell F9, I used partial Vlookup and get value in column F (CalculatedValue), current sheet is 'draft', when I open Excel file, everything is ok. but ...

Id #21474 | Release: None | Updated: Tue at 10:05 AM by duc152 | Created: Tue at 10:02 AM by duc152

Excel reader reads in freeze pains wrong

When I use the Excel read 2007 and read in a file with a freeze pain in it, the output seems to move the pain. Code: $objPHPExcel = PHPExcel_IOFactory::createReader('Excel2007'); $objPHPExcel = $o...

Id #21471 | Release: None | Updated: Tue at 12:24 AM by menger | Created: Tue at 12:24 AM by menger

What would the gethighestrow() ouput if i echoed it.

If i echo the variable consisting of the gethighestrow(), will it echo the last row no. given in the first column of the excel sheet when it is opened... Im asking this because in my case, the num...

Id #21469 | Release: None | Updated: Mon at 9:47 AM by akshebs | Created: Mon at 9:47 AM by akshebs

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: Oct 18 at 8:42 AM by akshebs | Created: Oct 17 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: Oct 15 at 4:34 PM by wiseloren | Created: Oct 15 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