Different colors in same cell

[Ervin Hegedüs]

Hello All,

I would like to know is there any way to put a text to a cell with
different colours?

For example (as html):
<font style="color: red;">This is the lead part</font> <font
style="color: black;">of full text</font>

In other way: which "object" has color in XLS: the text or a cell?

Thank you:

airween

[Chris Withers]

Ervin Hegedüs wrote:
> For example (as html):
> <font style="color: red;">This is the lead part</font> <font
> style="color: black;">of full text</font>
>
> In other way: which "object" has color in XLS: the text or a cell?

Currently he xl* libraries in python only support cell colours.
What you're after is rich text in cells, and unfortunately that will
require either patches or funding.

cheers,

Chris

--
Simplistix - Content Management, Batch Processing & Python Consulting
- http://www.simplistix.co.uk

[Ervin Hegedüs]

Hello Chris,

thanks for the reply,

>> For example (as html):
>> <font style="color: red;">This is the lead part</font> <font
>> style="color: black;">of full text</font>
>>
>> In other way: which "object" has color in XLS: the text or a cell?
>
> Currently he xl* libraries in python only support cell colours.
> What you're after is rich text in cells, and unfortunately that will
> require either patches or funding.

right, is that patch exists? If yes, where can I find?

thanks:

a.

[Chris Withers]

Ervin Hegedüs wrote:
>>> In other way: which "object" has color in XLS: the text or a cell?
>> Currently he xl* libraries in python only support cell colours.
>> What you're after is rich text in cells, and unfortunately that will
>> require either patches or funding.
>
> right, is that patch exists? If yes, where can I find?

I'm sure myself and John have clarified before, but just for the hard of
thinking:

If we say something needs patching, unless we say otherwise, it means
someone needs to write the patch.

The "funding" bit means that if you don't want to or aren't capable of
providing a patch, you will need to pay someone to write the
functionality you want.

That will usually be John, or in very rare cases, me.

[John Machin]

On 4/12/2009 11:13 PM, Chris Withers wrote:
> Ervin Hegedüs wrote:
>>>> In other way: which "object" has color in XLS: the text or a cell?
>>> Currently he xl* libraries in python only support cell colours.
>>> What you're after is rich text in cells, and unfortunately that will
>>> require either patches or funding.
>> right, is that patch exists? If yes, where can I find?
>
> I'm sure myself and John have clarified before, but just for the hard of
> thinking:
>
> If we say something needs patching, unless we say otherwise, it means
> someone needs to write the patch.
>
> The "funding" bit means that if you don't want to or aren't capable of
> providing a patch, you will need to pay someone to write the
> functionality you want.

In this case, we do have a patch, provided by Rob Burton -- se the
thread titled "Multiple formats in a cell" around early March 2009. Note
that a patch is a diff file to apply to the xlwt source. That's not all
that's required; it needs (a) documentation [more than most, because one
would go nuts deriving the docs from the diff] and (b) very solid
testing because it messes with the shared string table which is a
crucial component and a fragile one thanks to MS' hilarious attitude to
data structure design. It needs some "red team" code to bash on the SST
to see if it will break.

Ervin, are you up for volunteering to rough out some docs (starting from
the example I gave in that thread, which is what Rob implemented) and to
test it on a large real application [I'll do the try-to-break-it code
separately]?

BTW the functionality that Excel provides is to have multiple "fonts" in
a cell, not formats or colours. Note that in Excel parlance a "font" is
not merely a named collection of glyphs like "Arial" or "Times New
Roman"; it includes the height, escapement, bold, underline, italic,
etc. Also it only works with string constants.

Cheers,
John

[Ervin Hegedüs]

Hello John,

> In this case, we do have a patch, provided by Rob Burton -- se the
> thread titled "Multiple formats in a cell" around early March 2009. Note
> that a patch is a diff file to apply to the xlwt source.

that's great, it's no problem to apply a patch...

> That's not all
> that's required; it needs (a) documentation [more than most, because one
> would go nuts deriving the docs from the diff] and (b) very solid
> testing because it messes with the shared string table which is a
> crucial component and a fragile one thanks to MS' hilarious attitude to
> data structure design. It needs some "red team" code to bash on the SST
> to see if it will break.

so, I think I understand these above,

> Ervin, are you up for volunteering to rough out some docs (starting from
> the example I gave in that thread, which is what Rob implemented) and to
> test it on a large real application [I'll do the try-to-break-it code
> separately]?

yes, I'm pleased to help you - at next week I hope we will end our project at
my work, I try to allocate some freetime in holiday.

> BTW the functionality that Excel provides is to have multiple "fonts" in
> a cell, not formats or colours. Note that in Excel parlance a "font" is
> not merely a named collection of glyphs like "Arial" or "Times New
> Roman"; it includes the height, escapement, bold, underline, italic,
> etc. Also it only works with string constants.

it's clear, thank you.

I'll check out that thread.

Cheers:

a.

[Ervin Hegedüs]

Hello John,

I've found that thread which you wrote, but I didn't found the patch -
could you explain the location of that source?

Sorry and thank you:



a.

> --~--~---------~--~----~------------~-------~--~----~
> You received this message because you are subscribed to the Google Groups "python-excel" group.
>  To post to this group, send email to python...@googlegroups.com
>  To unsubscribe from this group, send email to python-excel...@googlegroups.com
>  For more options, visit this group at http://groups.google.com/group/python-excel?hl=en-GB
> -~----------~----~----~----~------~----~------~--~---
>
>

[John Machin]

On 14/12/2009 11:56 PM, Ervin Heged�s wrote:
> Hello John,
>
> I've found that thread which you wrote, but I didn't found the patch -
> could you explain the location of that source?
>
> Sorry and thank you:

Hi Ervin,

I'm sorry:
(1) I overlooked this message
(2) The patch from Robert Burton was in a private e-mail message.

If you are still up for working on it as discussed earlier in this
thread, I can send it to you ... perhaps better: if Robert is listening,
he could send both of us a patch against the current SVN source.

>
> On Fri, Dec 4, 2009 at 3:54 PM, John Machin <sjma...@lexicon.net> wrote:
>> On 4/12/2009 11:13 PM, Chris Withers wrote:

[Ervin Hegedüs]

Hello John,

no problem, thank you for your reply.

Yes, I'm still would be happy to help you, I hope Robert read the list
- anyway, if he doesn't send the patch at this week, I will notice
you.

thanks:

a.

On Wed, Jan 6, 2010 at 1:43 PM, John Machin <sjma...@lexicon.net> wrote:

> --

> You received this message because you are subscribed to the Google Groups
> "python-excel" group.

> To post to this group, send an email to python...@googlegroups.com.

> To unsubscribe from this group, send email to

> python-excel...@googlegroups.com.

> For more options, visit this group at

> http://groups.google.com/group/python-excel?hl=en-GB.
>
>
>
>