| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 0.9.4 |
| Bug #6309 | Output with mergeCells crashes Mac Excel | ||
|---|---|---|---|
| Submitted: | 2005-12-20 23:44 UTC | ||
| From: | jon dot bertsch at ucop dot edu | Assigned: | progi1984 |
| Status: | No Feedback | Package: | Spreadsheet_Excel_Writer (version 0.9) |
| PHP Version: | 5.0.4 | OS: | Linux SUSE 9.2 |
| Roadmaps: | (Not assigned) | ||
[2005-12-20 23:44 UTC] 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");
Comments
[2009-08-12 12:54 UTC] progi1984
(Franck Lefevre)
-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.