611162 – dev-php/PEAR-OLE causes corruption with PEAR-Spreadsheet_Excel_Writer

Bug 611162 - dev-php/PEAR-OLE causes corruption with PEAR-Spreadsheet_Excel_Writer

Summary: dev-php/PEAR-OLE causes corruption with PEAR-Spreadsheet_Excel_Writer

Status:	RESOLVED FIXED

Alias:	None

Product:	Gentoo Linux
Classification:	Unclassified
Component:	Current packages (show other bugs)
Hardware:	All Linux

Importance:	Normal normal (vote)
Assignee:	PHP Bugs

URL:
Whiteboard:
Keywords:

Depends on:
Blocks:

Reported:	2017-02-28 03:39 UTC by lou
Modified:	2017-02-28 14:02 UTC (History)
CC List:	0 users

See Also:
Package list:
Runtime testing required:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description lou 2017-02-28 03:39:01 UTC

Updated dev-php/PEAR-OLE to dev-php/PEAR-OLE-1.0.0_rc2-r1. After that, calls to PEAR-Spreadsheet_Excel_Writer results in corrupted file. Excel reads - 'Excel found unreadable content'

If found this page with the fix...
 http://www.nikhils.in/2013/12/php-spreadsheetexcelwriter-breaks.html

"The solution is change in Root.php \ line 623 :
fwrite($FILE, pack("V", 1));
to
 fwrite($FILE, pack("V", $num_sb_blocks));
 to be consistent with prévious RC : Root.php \ line 256 : .
pack("V", $iSBDcnt)"
Reference :  http://pear.php.net/bugs/bug.php?id=19284&edit=3

Applying that change to Root.php fixed the problem for me.

Comment 1 Brian Evans (RETIRED) gentoo-dev

2017-02-28 14:02:36 UTC

Fixed with PEAR-OLE-1.0.0_rc2-r2