Borders and format cells

Jul 28, 2009 at 8:36 PM

I'm not sure if this is an issue with the latest source code release (28250), but just wanted to check.  I noticed that if I run the below code and open up the generated file in Excel 2003, if I go to the Format menu, then Cells for cells A1 and A2, nothing comes up, but it works fine for cells A3, B1, and all others.  It seems to be something specific to using a border style.  Also, running this same script in PHPExcel 1.6.7 works fine.  Is anyone else running into this issue?

$workbook = new PHPExcel;

$workbook->getActiveSheet()->getStyle('A2')->applyFromArray(
	array(
		'borders' => array(
			'top'     => array(
				'style' => PHPExcel_Style_Border::BORDER_THIN,
				'color' => array(
					'argb' => PHPExcel_Style_Color::COLOR_BLACK,
				)
			)
		),
	)
);

$writer = PHPExcel_IOFactory::createWriter($workbook, 'Excel5');
$writer->save('write.xls');

Thanks,
Ryan

Developer
Jul 28, 2009 at 10:09 PM

>> if I go to the Format menu, then Cells for cells A1 and A2, nothing comes up

Hmm... This is very weird. I can verify that this is also happening in MS Office Excel 2007. Found out that this bug is happening after this change:
http://phpexcel.codeplex.com/WorkItem/View.aspx?WorkItemId=10181

I have no idea what is causing this. As long as we don't know what is causing this, there is no other choice than re-opening that work item and revert the changes. Will do that.

Developer
Jul 28, 2009 at 10:17 PM

Things should be working againg with next source code release:

http://phpexcel.codeplex.com/SourceControl/ListDownloadableCommits.aspx

Aug 6, 2009 at 6:25 PM

But reverting it has broken this again: http://phpexcel.codeplex.com/Thread/View.aspx?ThreadId=60285 :(

Developer
Aug 6, 2009 at 11:32 PM


>> But reverting it has broken this again: http://phpexcel.codeplex.com/Thread/View.aspx?ThreadId=60285 :(

Ugg... I don't know which of the two bugs is worse. We should get this fixed.