Skip Menu | You are currently an anonymous guest. | Login | Return to Main | About rt.cpan.org
 

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.

X Report information
X The Basics
Id: 14094
Status: resolved
Left: 0 min
Priority: 0/0
Queue: Spreadsheet-WriteExcel
X People
Owner: JMCNAMARA <jmcnamara [...] cpan.org>
Requestors: m.brodbelt [...] acu.ac.uk
Cc:
AdminCc:
X Bug Information
Severity: Normal
Broken in: 2.14
Fixed in: (no value)

X History Display mode: Brief headers — Full headers
#   Wed Aug 10 11:40:00 2005 guest - Ticket created  
Subject: Module generates Excel files with multiple active WINDOW2 records
[text/plain 591b]
I've been generating files with two worksheets with Spreadsheet::WriteExcel - they work fine in Excel, but when opened with OpenOffice 2.0 betas, the worksheets are both selected, so when you delete a cell from one, the corresponding cell on the other worksheet also disappears.

I filed this as a bug with OpenOffice, and the developer who commented has fixed it, but claims that the Excel file generated is technically invalid, as is contains several WINDOW2 records with the active flag set.

Reference the OpenOffice bug report at:-
http://www.openoffice.org/issues/show_bug.cgi?id=52955
#   Wed Aug 10 12:33:52 2005 JMCNAMARA - Taken  
#   Wed Aug 10 12:40:22 2005 JMCNAMARA - Correspondence added  
[text/plain 315b]
[guest - Wed Aug 10 11:40:00 2005]:


> I filed this as a bug with OpenOffice

I actually saw you bug report the other day. :-)

> Reference the OpenOffice bug report at:-
> http://www.openoffice.org/issues/show_bug.cgi?id=52955

Okay, thanks for that. I'll look into it and fix it in the next release.

John.
--


#   Mon Sep 19 07:26:41 2005 JMCNAMARA - Correspondence added  
[text/plain 123b]

This should now be fixed in version 2.15 of the Spreadsheet::WriteExcel.
Let me know if it fixes the problem.

John.
--


#   Mon Jan 09 08:56:19 2006 JMCNAMARA - Status changed from 'new' to 'resolved'