External formula with double quotes(") and semicolon(;)

Hello, I am trying to write a formula into excel that it isnt excel formula but it is external formula. The output is empty. The formula is like this "=ASD("SN@CBBT corp";"AVG";" INTERVAL=1m";)" ...

Id #21779 | Release: None | Updated: Mar 16 at 10:03 PM by midall | Created: Mar 16 at 8:49 PM by midall

Fill Colour Issue

Hi, I have used the following code many times in many projects. $objPHPExcel->getActiveSheet()->getStyle('A6:I6')->getFill() ->setFillType(PHPExcel_Style_Fill::FILL_SOLID) ->getStartColor()->setRG...

Id #21760 | Release: None | Updated: Mar 9 at 10:41 AM by MarkBaker | Created: Mar 9 at 10:01 AM by xand49

XLSX file unable to upload

When i try to upload xlsx or xls file into server it's show Blank page.......and stop uploading i assume that file is unable to load here is my code $jinput = JFactory::getApplication()->input; ...

Id #21759 | Release: None | Updated: Mar 10 at 1:40 PM by MarkBaker | Created: Mar 9 at 9:30 AM by chetnath

phpexcel objWriter->save out of memory

I'm using v1.8 of PHPexcel and php5.3 on debian squeez. My spreadsheet is containing 32000 lines x 15 fields - no formatting. Using sqlite cell caching the job requires about 44Mb of memory. He...

Id #21752 | Release: None | Updated: Mar 5 at 2:28 PM by Cugar | Created: Mar 5 at 2:28 PM by Cugar

To capture chart in pdf

Hi, I need expert support on the following issue. I generate CHART as per following code(only the last lines) which work absolutely fine- ...................... $objWorksheet->addChart($chart); ...

Id #21741 | Release: None | Updated: Mar 3 at 4:36 PM by anoop31 | Created: Feb 27 at 4:46 AM by anoop31

not working when uploaded

it is already working in the localhost but when i uploaded the whole stuff it won't work.. is there anything that i have to configure? thanks in advance

Id #21738 | Release: None | Updated: Feb 25 at 6:18 AM by wilsonchico | Created: Feb 25 at 6:18 AM by wilsonchico

PHPExcel Prerequisites

I experience a strange situation: 1) environment on unix with a old PHP installation (version: 5.1.2) and none of the extensions mentioned as prerequisites, where PHPExcel works well (I can run e...

Id #21721 | Release: None | Updated: Feb 13 at 3:23 PM by gabrielc2002 | Created: Feb 13 at 3:23 PM by gabrielc2002

PHPExcel_Shared_Drawing::pixelsToPoints uses wrong ratio

PHPExcel_Shared_Drawing::pixelsToPoints and PHPExcel_Shared_Drawing::pointsToPixels are inconsistent. It looks, PHPExcel_Shared_Drawing::pointsToPixels uses correct ration 1.333333333 Then ratio f...

Id #21718 | Release: None | Updated: Feb 12 at 12:55 PM by Priqut | Created: Feb 10 at 7:33 PM by gorbunovav

Adding \n (newline) to text duplicates the cell contents

If you add text to a cell using $text = "Foo \n Bar"; $objPHPExcel->getActiveSheet()->setCellValue('B2', $text); the result in the cell will be Foo Bar Foo Bar

Id #21703 | Release: None | Updated: Feb 1 at 10:22 AM by MarkBaker | Created: Feb 1 at 8:39 AM by Blurp2000

Fatal error: Uncaught exception 'PHPExcel_Exception' with message 'Invalid cell coordinate IV7)'

i got this error: Fatal error: Uncaught exception 'PHPExcel_Exception' with message 'Invalid cell coordinate IV7)' Stack: PHPExcel_Exception: Invalid cell coordinate IV7) in I:_htdocs\shop_punkt...

Id #21696 | Release: None | Updated: Jan 29 at 1:12 PM by jav666 | Created: Jan 29 at 1:12 PM by jav666