This queue is for tickets about the Spreadsheet-WriteExcel CPAN distribution.
Maintainer(s)' notes
If you are reporting a bug in Spreadsheet::WriteExcel here are some pointers
1) State the issues as clearly and as concisely as possible. A simple program or Excel test file (see below) will often explain the issue better than a lot of text.
2) Provide information on your system, version of perl and module versions. The following program will generate everything that is required. Put this information in your bug report.
#!/usr/bin/perl -w
print "\n Perl version : $]";
print "\n OS name : $^O";
print "\n Module versions: (not all are required)\n";
my @modules = qw(
Spreadsheet::WriteExcel
Parse::RecDescent
File::Temp
OLE::Storage_Lite
IO::Stringy
Spreadsheet::ParseExcel
Scalar::Util
Unicode::Map
);
for my $module (@modules) {
my $version;
eval "require $module";
if (not $@) {
$version = $module->VERSION;
$version = '(unknown)' if not defined $version;
}
else {
$version = '(not installed)';
}
printf "%21s%-24s\t%s\n", "", $module, $version;
}
__END__
3) Upgrade to the latest version of Spreadsheet::WriteExcel (or at least test on a system with an upgraded version). The issue you are reporting may already have been fixed.
4) Create a small but complete example program that demonstrates your problem. The program should be as small as possible. At the same time it should be a complete program that generates an Excel file. If the Spreadsheet::WriteExcel section is part of a much larger program then simplify it down to the essentials. Simulate any DB reads with an array.
5) Say if you tested with Excel, OpenOffice, Gnumeric or something else. Say which version of that application you used.
6) If you are submitting a patch you should check with the author whether the issue has already been patched or if a fix is in the works. Patches should be accompanied by test cases.
Asking a question
If you would like to ask a more general question there is the Spreadsheet::WriteExcel Google Group.
| Owner: |
Nobody in particular
|
| Requestors: |
joerg [...] Magma-DA.COM
|
| Cc: |
|
| AdminCc: |
|
|
| Severity: |
(no value)
|
| Broken in: |
(no value)
|
| Fixed in: |
(no value)
|
|
Mon Jul 14 10:52:47 2008
joerg [...] Magma-DA.COM - Ticket created
Hi,
I am using the perl module Spreadsheet-WriteExcel-2.21 to automate the
generation of reports in xls-format.
Unfortunately MS Office 2003-SP3 can no longer read the resulting xls-file
correctly, while 2003-SP2 worked fine.
You can use OpenOffice as a converter, but that is an inconvenient
workaround, since I use this for an automated process.
Are you aware of similar problems?
Please let me know if you need more detailed information, I could send parts
of the code, that generates the excel sheet as well as a sample sheet if
needed.
Thanks
Jörg
+---------------------------------------------------------------+
| MAGMA Design Automation GmbH |
| |
| Magma: The Fastest Path from RTL to Silicon |
| |
|
http://www.magma-da.com <
http://www.magma-da.com/>
|
| mailto:joerg@magma-da.com |
| |
| Jörg Schweden Applications Engineer |
| Unterhachinger Str. 75 Tel: ++ 49 +89 206091 624 |
| 81737 Muenchen Fax: ++ 49 +89 206091 699 |
| Germany Mobile: ++ 49 +173 6643 382 |
| Hotline: ++ 49 +89 206091 600 |
+---------------------------------------------------------------+
| Sitz: München. AG HRB 127142 |
| Geschäftsführer: Richard Henderson, Roy E. Jewell, |
|Rajeev Madhavan, Peter Teshima, Gregory Wagenhoffer, Gary Wong |
+---------------------------------------------------------------+
| PGP Fingerprints |
| A0C4 28D3 D81C 30D7 467A 9426 5558 BED9 E265 C071 |
| 90 9F 6E 42 41 A0 9A 5A C4 8D 11 CB 41 D6 0E 61 |
+---------------------------------------------------------------+
CONFIDENTIALITY NOTICE:
This e-mail may contain information that is confidential and proprietary to
Magma, and
Magma hereby designates the information in this e-mail as confidential. The
information is
intended only for the use of the individual or entity named above. If you
are not the
intended recipient, you are hereby notified that any disclosure, copying,
distribution
or use of any of the information contained in this transmission is strictly
prohibited
and that you should immediately destroy this e-mail and its contents and
notify Magma.
Message body is not shown because it is too large.
Mon Jul 14 13:35:33 2008
jmcnamara [...] cpan.org - Correspondence added
On Mon Jul 14 10:52:47 2008, joerg@Magma-DA.COM wrote:
Show quoted text> Hi,
>
>
>
> I am using the perl module Spreadsheet-WriteExcel-2.21 to automate the
> generation of reports in xls-format.
>
> Unfortunately MS Office 2003-SP3 can no longer read the resulting xls-file
> correctly, while 2003-SP2 worked fine.
Hi,
There is one known issue in relation to SP3.
See here: WARNING: Spreadsheet::WriteExcel and Office Service Pack 3
http://groups.google.com/group/spreadsheet-writeexcel/browse_thread/thread/3dcea40e6620af3a
Read the first 2 posts and see if they relate to your problem. Try the
duplicate finding program on the file that is giving problems.
If the problem persists then let me know.
JOhn.
--
Mon Jul 14 13:35:39 2008
The RT System itself - Status changed from 'new' to 'open'
Tue Jul 15 07:40:26 2008
joerg [...] Magma-DA.COM - Correspondence added
Hi,
Thanks for your helpful answer, the description exactly addresses my
problem.
I write different data to the same cell more than once and using the
compatibility mode solves the problem.
Regards,
Jörg
Show quoted text-----Original Message-----
From: John McNamara via RT [mailto:bug-Spreadsheet-WriteExcel@rt.cpan.org]
Sent: Monday, July 14, 2008 7:36 PM
To: joerg@Magma-DA.COM
Subject: [rt.cpan.org #37674] Office2003-SP3 cannot read the xls files
generated with Spreadsheet-WriteExcel-2.21 anymore
<URL:
http://rt.cpan.org/Ticket/Display.html?id=37674 >
On Mon Jul 14 10:52:47 2008, joerg@Magma-DA.COM wrote:
> Hi,
>
>
>
> I am using the perl module Spreadsheet-WriteExcel-2.21 to automate the
> generation of reports in xls-format.
>
> Unfortunately MS Office 2003-SP3 can no longer read the resulting xls-file
> correctly, while 2003-SP2 worked fine.
Hi,
There is one known issue in relation to SP3.
See here: WARNING: Spreadsheet::WriteExcel and Office Service Pack 3
http://groups.google.com/group/spreadsheet-writeexcel/browse_thread/thread/3
dcea40e6620af3a
Read the first 2 posts and see if they relate to your problem. Try the
duplicate finding program on the file that is giving problems.
If the problem persists then let me know.
JOhn.
--
Sat Jul 19 09:30:44 2008
jmcnamara13 [...] gmail.com - Correspondence added
On Tue, Jul 15, 2008 at 12:40 PM, Jörg Schweden via RT <
bug-Spreadsheet-WriteExcel@rt.cpan.org> wrote:
Show quoted text> Queue: Spreadsheet-WriteExcel
> Ticket <URL:
http://rt.cpan.org/Ticket/Display.html?id=37674 >
>
> Hi,
>
> Thanks for your helpful answer, the description exactly addresses my
> problem.
> I write different data to the same cell more than once and using the
> compatibility mode solves the problem.
Hi Jorg,
That is good. :-)
I've put some information about this in the next release of the
Spreadsheet::WriteExcel documentation. When that comes out I'll close your
RT issue.
Regards,
John.
--
Wed Jul 29 12:05:29 2009
jmcnamara [...] cpan.org - Status changed from 'open' to 'resolved'
