Merge problem

I'm creating a spreadsheet where I want to merge 2 cells,
and align
the result cell left.

When I use set_align('left'), and then set_merge() the cell
is merged,
but aligned center. When I use set_merge() and then
set_align('left'),
the cell get's is not merged, but is aligned left. What I'm
I doing
wrong?

The code is:

$header_textonbb = $workbook->addformat(,
                                          bold    => 0,,
                                          italic  => 0,,
                                          color   =>
'black',
                                          size    => 9,,
                                          font    =>
'Arial',
                                          );
$header_textonbb->set_border(1);
$header_textonbb->set_align('left');   ***
$header_textonbb->set_merge();  ***

$worksheet->write(",linha - 1,",3,'Dias
uteis:',$header_textonbb);
$worksheet->write_blank(",linha -
1,",4,$header_textonbb);

The 2 lines with the *** at the end are the lines I was
talking about...

Regards

Roger Jochem

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Spreadsheet::WriteExcel" group.
To post to this group, send email to
spreadsheet-writeexcelgooglegroups.com
To unsubscribe from this group, send email to
spreadsheet-writeexcel-unsubscribegooglegroups.com
For more options, visit this group at http://groups.google.com/group/spreadsheet-writeexcel
?hl=en
-~----------~----~----~----~------~----~------~--~---

On Aug 14, 3:02 pm, "Roger Jochem"
<roger.joc...gmail.com> wrote:
> I'm creating a spreadsheet where I want to merge 2
cells, and align
> the result cell left.
>
> When I use set_align('left'), and then set_merge() the
cell is merged,
> but aligned center. When I use set_merge() and then
set_align('left'),
> the cell get's is not merged, but is aligned left. What
I'm I doing


Hi Roger,

That merge is the Excel file merger which is really just a
"center
across" format. That is mutually exclusive with other
horizontal
alignment.

Try the merge_range() method instead. See in particular
merge example
4 in the distro:

http://search.cpan.org/src/JM
CNAMARA/Spreadsheet-WriteExcel-2.18/examples/merge4.pl


John.
--


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Spreadsheet::WriteExcel" group.
To post to this group, send email to
spreadsheet-writeexcelgooglegroups.com
To unsubscribe from this group, send email to
spreadsheet-writeexcel-unsubscribegooglegroups.com
For more options, visit this group at http://groups.google.com/group/spreadsheet-writeexcel
?hl=en
-~----------~----~----~----~------~----~------~--~---

I just tryead that, and really worked. Thanks...

Another question, any Idea when the .bmp files would be
visible in
openoffice too?

Regards

Roger Jochem

2007/8/14, jmcnamara <jmcnamaracpan.org>:
>
>
>
> On Aug 14, 3:02 pm, "Roger Jochem"
<roger.joc...gmail.com> wrote:
> > I'm creating a spreadsheet where I want to merge 2
cells, and align
> > the result cell left.
> >
> > When I use set_align('left'), and then set_merge()
the cell is merged,
> > but aligned center. When I use set_merge() and
then set_align('left'),
> > the cell get's is not merged, but is aligned left.
What I'm I doing
>
>
> Hi Roger,
>
> That merge is the Excel file merger which is really
just a "center
> across" format. That is mutually exclusive with
other horizontal
> alignment.
>
> Try the merge_range() method instead. See in particular
merge example
> 4 in the distro:
>
> http://search.cpan.org/src/JM
CNAMARA/Spreadsheet-WriteExcel-2.18/examples/merge4.pl
>
>
> John.
> --
>
>
> >
>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Spreadsheet::WriteExcel" group.
To post to this group, send email to
spreadsheet-writeexcelgooglegroups.com
To unsubscribe from this group, send email to
spreadsheet-writeexcel-unsubscribegooglegroups.com
For more options, visit this group at http://groups.google.com/group/spreadsheet-writeexcel
?hl=en
-~----------~----~----~----~------~----~------~--~---

On Aug 14, 9:00 pm, "Roger Jochem"
<roger.joc...gmail.com> wrote:
> I just tryead that, and really worked. Thanks...
>
> Another question, any Idea when the .bmp files would be
visible in
> openoffice too?

Hi Roger,

There is a pre-release of the next version available that
supports PNG
images that are visible in OpenOffice. See the following:

http://groups.google.
com/group/spreadsheet-writeexcel/browse_thread/thread/e3f037
3051ce35f4

John.
--



--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Spreadsheet::WriteExcel" group.
To post to this group, send email to
spreadsheet-writeexcelgooglegroups.com
To unsubscribe from this group, send email to
spreadsheet-writeexcel-unsubscribegooglegroups.com
For more options, visit this group at http://groups.google.com/group/spreadsheet-writeexcel
?hl=en
-~----------~----~----~----~------~----~------~--~---

Thanks!

I will take a look...

Regards

Roger Jochem

----- Original Message ----- 
From: "jmcnamara" <jmcnamaracpan.org>
To: "Spreadsheet::WriteExcel"
<spreadsheet-writeexcelgooglegroups.com>
Sent: Tuesday, August 14, 2007 7:55 PM
Subject: Re: Merge problem


>
>
>
> On Aug 14, 9:00 pm, "Roger Jochem"
<roger.joc...gmail.com> wrote:
>> I just tryead that, and really worked. Thanks...
>>
>> Another question, any Idea when the .bmp files
would be visible in
>> openoffice too?
>
> Hi Roger,
>
> There is a pre-release of the next version available
that supports PNG
> images that are visible in OpenOffice. See the
following:
>
> http://groups.google.
com/group/spreadsheet-writeexcel/browse_thread/thread/e3f037
3051ce35f4
>
> John.
> --
>
>
>
> > 


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Spreadsheet::WriteExcel" group.
To post to this group, send email to
spreadsheet-writeexcelgooglegroups.com
To unsubscribe from this group, send email to
spreadsheet-writeexcel-unsubscribegooglegroups.com
For more options, visit this group at http://groups.google.com/group/spreadsheet-writeexcel
?hl=en
-~----------~----~----~----~------~----~------~--~---