“Style 'Currency' not found” When trying to format a column from a file created with phpexcel / yii / eexcelview

Topics: Developer Forum
Aug 12, 2013 at 1:30 PM
Edited Aug 12, 2013 at 1:36 PM
0 down vote favorite


I am using PHPExcel 1.7.9 to create an excel file with no issues. However when I want to format a column in excel, I highlight it and click the "$" icon in the toolbar and the error: "Style 'Currency' not found" pops up. Same happens for "%" and "," , however if I take the long way "right click" -> Format Cell -> select style, it works fine.

I found these articles about the issue, but I don't know how to solve:
[1] http://www.office-archive.com/4-excel/10a63209c2ca163d.htm
[2] https://groups.google.com/forum/#!topic/microsoft.public.excel.worksheet.functions/5PvrI8yCm60

I am using Yii to generate the xls with the "eexcelview" extension

(This post is the same as: http://stackoverflow.com/questions/18175101/style-currency-not-found-when-trying-to-format-a-column-from-a-file-created I figured I might get more responses here.

Here is a sample file with this problem: https://www.codeplex.com/Download/AttachmentDownload.ashx?ProjectName=phpexcel&WorkItemId=10749&FileAttachmentId=7105