| 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] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2011-09-29 14:05 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!