willimjian / php-excel

Automatically exported from code.google.com/p/php-excel
MIT License
0 stars 0 forks source link

Worksheet::removeColumn() not handling the last row of the worksheet? #15

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
I have a script that's sole purpose is to remove a few columns from a
spreadsheet that is passed to it.  The total work w/ PHPExcel is:

$xl = PHPExcel_IOFactory::load($filename);
$ws = $xl->getSheet();
$ws->removeColumn('C', 7);
$writer = PHPExcel_IOFactory::createWriter($xl, 'Excel5');
$writer->save($outputfile);

After running the xls through the script, the final row still has the
columns that should be removed and I have to remove the data from those
cells manually.

What is the expected output? What do you see instead?
I would expect that the columns removed would be removed throughout the
entire worksheet.

What version of the product are you using? On what operating system?
PHP 5.2.9
Initially used PHPExcel 1.1
Most recent test using PHPExcel svn pull on 1/21/2010

Please provide any additional information below.

Original issue reported on code.google.com by slacker...@gmail.com on 22 Jan 2010 at 4:28