To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=52955
Issue #:|52955
Summary:|Excel files generated by Perl module import badly
Component:|Spreadsheet
Version:|680m118
Platform:|PC
URL:|
OS/Version:|All
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|open-import
Assigned to:|spreadsheet
Reported by:|sauron11
------- Additional comments from [EMAIL PROTECTED] Fri Aug 5 07:50:05 -0700
2005 -------
I use a perl module from CPAN to dynamically generate Excel files on a webserver
- users click a link and can download stuff in Excel format. When you try and
open these files in OpenOffice, they display fine, but cell contents on
different worksheets are "linked", so deleting the contents of cell A2 on
worksheet 2 also deletes the contents of the cell on worksheet 1. This makes
users cranky...
To reproduce this bug, put the following perl code in the cgi-bin directory of a
web server with the Spreadsheet::WriteExcel module installed:-
#!/usr/bin/perl
use Spreadsheet::WriteExcel;
print "Content-type: application/vnd.ms-excel\n";
print "Content-disposition: attachment; filename=test.xls\n";
print "\n";
$workbook = Spreadsheet::WriteExcel->new('-');
$worksheet1 = $workbook->addworksheet();
$worksheet2 = $workbook->addworksheet();
@one = qw(Fred Joe Bill);
@two = qw(Mary Jill Sue);
$worksheet1->write_row(0, 0, [EMAIL PROTECTED]);
$worksheet2->write_row(0, 0, [EMAIL PROTECTED]);
$workbook->close();
Browse to the appropriate URL, and download the spreadsheet into Calc. Go to the
second worksheet, and delete "Jill". Notice that "Joe" also vanishes without
trace from the first worksheet.
As this works perfectly in all the versions of Excel that I've tested it on, I'm
assuming it's a bug with the Excel import filter.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
