Cell Value is False

I am retrieving data from a database and creating an html table as well as an excel spreadsheet with the data. The problem is that the excel spreadsheet inserts FALSE into the Description column ...

Id #21814 | Release: None | Updated: Mon at 9:34 PM by abas12 | Created: Mon at 9:34 PM by abas12

Financial function issues

Hi Here is a piece of code giving strange result $objPHPExcel->getActiveSheet()->setCellValue('A1', '=date(2013,03,19)'); $objPHPExcel->getActiveSheet()->setCellValue('B1', '=date(2013,09,...

Id #21809 | Release: None | Updated: Thu at 2:16 PM by CaptainFantastic | Created: Thu at 2:16 PM by CaptainFantastic

exporting chart from import failed

I have a template (xlsx) including 2 charts (file have 4 datasheets, both column charts are on datasheet 1) and I just want to export this file again. Everything seems to work fine and the charts a...

Id #21807 | Release: None | Updated: Apr 15 at 11:29 AM by hanni | Created: Apr 15 at 11:29 AM by hanni

PHPExcel_RichText does not render in iPad Mail app attachment preview

// show the field value in bold $objRichText = new PHPExcel_RichText(); $objRichText->createText("Test Label : "); $objPayable = $objRichText->createTextRun("Test Value"); $objPa...

Id #21806 | Release: None | Updated: Apr 15 at 8:49 AM by kimanthonygroves | Created: Apr 15 at 8:49 AM by kimanthonygroves

Not loading .xlsx in PHP earlier than 5.2.11

In PHP earlier than 5.2.11, using Excel2007 reader to load a .xlsx file will just die and showing no error. It cause by @libxml_disable_entity_loader() in PHPExcel_Settings::setLibXmlLoaderOptions...

Id #21803 | Release: None | Updated: Apr 14 at 4:24 AM by tonywong240411 | Created: Apr 14 at 4:24 AM by tonywong240411

Phpexcel calling insertNewRowBefore more than once (multiple times) gives “Invalid cell coordinate i$1” exception

When I try PhpExcel insertNewRowBefore for the first time it runs flawlessly but whenever I need to call it more than once it gives me exception Invalid cell coordinate i$1 even I have used the sa...

Id #21802 | Release: None | Updated: Apr 14 at 5:47 AM by ahsansalal | Created: Apr 14 at 4:18 AM by ahsansalal

how to save excel raw data into DB

Hello, I have tried to save Raw Data into database but No luck Please let me know how to save raw data into mysql database. raw data means if i put style (bold, italic) in font...then i need to ...

Id #21796 | Release: None | Updated: Apr 6 at 5:34 AM by chetnath | Created: Apr 2 at 11:58 AM by chetnath

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