Wed Jan 12 22:58:54 2011jvprosser [...] gmail.com - Ticket created
Subject:
Excel::Template merged cells and preserving CRLFs
Date:
Wed, 12 Jan 2011 22:58:46 -0500
To:
bug-Excel-Template [...] rt.cpan.org
From:
Joe Prosser <jvprosser [...] gmail.com>
Hi Maintainers,
If I use text_wrap="1" in a format around a single cell, and add
content to that cell that contains '\n's, they are displayed in the
cell appropriately (as if I hit alt-enter)
If I do this in a merged cell, I lose all the crlfs.
Thanks!
-Joe Prosser
Sun Apr 29 12:09:51 2012rbo [...] cpan.org - Correspondence added
In the master branch, I can not verify the problem, unfortunately. My example is attached.
The only problem I have is that: the height is not adjusted for merged cells.
Subject:
rt#64726.pl
#!/usr/bin/env perl
use warnings;
use strict;
use lib 'lib/';
use Excel::Template;
my $object = Excel::Template->new(file => \*DATA);
$object->write_file( $0 . ".xls" );
__DATA__
<workbook>
<worksheet>
<row>
<cell ref="foo"/>
<cell ref="foo"/>
<cell ref="foo"/>
<format text_wrap='1'>
<merge_range ref="foo">Text
to
insert
into
merged
range
</merge_range>
</format>
</row>
<row>
<format text_wrap='1'>
<cell>Text
to
insert
into
merged
range
</cell>
</format>
</row>
</worksheet>
</workbook>
Sun Apr 29 12:09:52 2012The RT System itself - Status changed from 'new' to 'open'
Sun Apr 29 12:09:52 2012rbo [...] cpan.org - Given to rbo
Sun Apr 29 13:02:51 2012rbo [...] cpan.org - Correspondence added
On Sun Apr 29 18:09:51 2012, rbo wrote:
Show quoted text
> The only problem I have is that: the height is not adjusted for merged
> cells.
I think this is a problem of Spreadsheet::WriteExcel, I have created an RT ticket: #76883
Sun Apr 29 13:02:52 2012rbo [...] cpan.org - Status changed from 'open' to 'stalled'
Sat May 05 03:46:06 2012rbo [...] cpan.org - Correspondence added
On Sun Apr 29 19:02:51 2012, rbo wrote:
Show quoted text
> On Sun Apr 29 18:09:51 2012, rbo wrote:
> > The only problem I have is that: the height is not adjusted for
> merged
> > cells.
> I think this is a problem of Spreadsheet::WriteExcel, I have created
> an RT ticket: #76883
OK, that is an Excel problem. #76883 -> Resolved.
Please reopen the ticket if the problem still exist.
Sat May 05 03:46:08 2012The RT System itself - Status changed from 'stalled' to 'open'
Sat May 05 03:46:08 2012rbo [...] cpan.org - Status changed from 'open' to 'resolved'
RT for rt.cpan.org