FAQ
Edit report at http://pear.php.net/bugs/bug.php?id=6309&edit=1

ID: 6309
Updated by: daniel.oconnor@gmail.com
Reported By: jon dot bertsch at ucop dot edu
Summary: Output with mergeCells crashes Mac Excel
-Status: Feedback
+Status: No Feedback
Type: Bug
Package: Spreadsheet_Excel_Writer
Operating System: Linux SUSE 9.2
Package Version: 0.9
PHP Version: 5.0.4
Assigned To: progi1984
Roadmap Versions:
New Comment:

-Status: Feedback
+Status: No Feedback



Previous Comments:
------------------------------------------------------------------------

[2009-08-12 08:54:44] progi1984

-Status: Open
+Status: Feedback
-Package Version:
+Package Version: 0.9
-Assigned To:
+Assigned To: progi1984
We are unable to reproduce the bug as reported.
Please provide a simple script (10 lines or less)
or a link to an external script that can be used
to reproduce the bug.

If you can provide the script, feel free to add it
to this bug and change the status back to "Open".

Thank you for your interest in PEAR.


Hello, could you give us a complete code ?

Because with these two tests code, I haven't got any problem.

Thanks you for advance.

------------------------------------------------------------------------

[2005-12-20 18:44:33] jon dot bertsch at ucop dot edu

Description:
------------
Mac OS 10.4.3
Excel: 2003
Pear: 1.4.5
Excel_Spreadsheet_Writer: 0.9

If you use mergeCells you must leave a blank line between the
merge cell line and a previous line that contains data or the
output file opens but then crashes.

Now this may be related to the bug #6118 and #1239 but it
happens whether or not you actually write any data to the
merged cells and it's only 8 columns across.



Test script:
---------------
On my system the following crashes excel:

$worksheet-> write($row, 3, "Data:", $format['boldRight']);
$worksheet-> write($row, 4, "Data", $format['alignLeft']);
$worksheet-> write($row, 7, "Data:", $format['boldRight']);
$worksheet-> write($row, 8, "Data", $format['alignRight']);

$row++;


$worksheet->mergeCells($row, 1, $row, 9);
$worksheet-> write($row, 5, "Schedule");

But adding an extra row is fine:

$worksheet-> write($row, 3, "Data:", $format['boldRight']);
$worksheet-> write($row, 4, "Data", $format['alignLeft']);
$worksheet-> write($row, 7, "Data:", $format['boldRight']);
$worksheet-> write($row, 8, "Data", $format['alignRight']);

$row++;
$row++;

$worksheet->mergeCells($row, 1, $row, 9);
$worksheet-> write($row, 5, "Schedule");

------------------------------------------------------------------------

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppear-bugs @
categoriesphp
postedSep 29, '11 at 8:04a
activeSep 29, '11 at 8:04a
posts1
users1
websitepear.php.net

1 user in discussion

Daniel Oconnor: 1 post

People

Translate

site design / logo © 2022 Grokbase