Discussion guidelines

General discussion/questions/...

Please post general discussion in the topic "General discussion".
Specific questions can be posted in a separate thread.

Having problems?

Create a new post. Maybe it's a bug, we can identify this using the discussions.

Found a bug? Have a feature request?

Create a new post or post an item in the issue tracker. Please FIRST review past work items, and ensure your bug/feature has not been posted before.

File uploads

Here at CodePlex we don't have the ability to upload files in discussion posts. It is difficult for users to send us files, but we often need users to open this or that Excel file as part of debugging.

Uploading files can be done in the issue tracker: http://phpexcel.codeplex.com/WorkItem/View.aspx?WorkItemId=10749. This can be used for sharing files with the PHPExcel team.

Some ground rules for file uploads:

  • When uploading a file to this issue, give it a clear name
  • Add a comment to the issue tracker, stating file <name> is related to discussion post <link>

Whatever you do...

...always mention your PHP version, PHPExcel version and operating system and be as detailed as possible. "It's not working!" may be correct, but does not provide us the required information to make it work.

How to remove default 'black' for text color

first post: realtebo wrote: When you create from scratch an excel with MsExcel every cell ha a ...

IF formula not working with parenthesis

first post: hebele wrote: There is a problem with parenthesis in formulas. =IF(A1="GOLD" , ...

latest post: MarkBaker wrote: Unable to replicate any problem ```php $workbook = new PHPExcel(); ...

How to set default rowalignment?

first post: realtebo wrote: How can I set that my sheet keeps values vertically centered?

How can I set parts of the text font bold in one cell with loop within a loop

first post: dcotta wrote: I have an error with PHPExcel Rich Text, when I have a loop and var...

latest post: dcotta wrote: on image I put $objBold = $objRichText->createTextRun('sprintf("%s"...

New line in rich text cell prior to variable not working

first post: xand49 wrote: Hi There, I'm having issues forcing a new line in rich text as be...

Highest Row

first post: pippuccio7 wrote: Hi sorry for english , i have a sheet with about 1900 rows . I cr...

latest post: pippuccio7 wrote: getHighestDataRow() return 85 .....

MultiSheet Import with INSERT values coming from different sheets

first post: jhh87 wrote: Hello All, With all the searching I have done, I cant seem to fin...

latest post: jhh87 wrote: After a lot of lost sleep and feeling as if i was just so close - I...

setCellValue of Stirng returns a number

first post: ontheroadagain wrote: Hi, I've a string as "2015." (finished by a dot). When I use of ...

latest post: MarkBaker wrote: I find that difficult to believe: unless you've found a major bug i...

App using PHPExcel ... the Excel writer/ export (.xls extension) gives Excel 2013 error (file extensions don't match). How to solve?

first post: pparker220 wrote: Hello there-- I'm using an application online that uses PHPExcel ...

latest post: MarkBaker wrote: A BIFF-format Excel file (.xls) bears no resemblance to a CSV file:...

Problem while reading large size .xls and .xlsx file

first post: alexlewis wrote: Hey, I am having problem while reading 3Mb data .xlsx file and same...