Web Images Videos Maps News Shopping Gmail more »
Recently Visited Groups | Help | Sign in
Google Groups Home
formatting within strings?
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  3 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Ollie Jones  
View profile  
 More options Nov 6, 5:31 pm
From: Ollie Jones <olliejo...@gmail.com>
Date: Fri, 6 Nov 2009 14:31:11 -0800 (PST)
Local: Fri, Nov 6 2009 5:31 pm
Subject: formatting within strings?
Spreadsheet::WriteExcel is wonderful, thanks for the great work.

I've been asked to program something I don't think it can do, that is,
write text strings with intra-string formatting.

For example I'd like to put in text strings that are partly but not
completely underlined.  In HTML-speak this might be, for example

     <U>Note:</U> Percentages may not total to 100 due to rounding
error.

Excel itself (even the old Excel 2000 I use) can be persuaded to do
this. Can I get WriteExcel to it?

I don't believe I can switch to WriteExcelXML, because the readers of
the stuff I'm generating have older versions of Excel.  Correct me if
this isn't right.

Thanks for your wisdom!


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
jmcnamara  
View profile  
 More options Nov 10, 6:00 am
From: jmcnamara <jmcnam...@cpan.org>
Date: Tue, 10 Nov 2009 03:00:58 -0800 (PST)
Local: Tues, Nov 10 2009 6:00 am
Subject: Re: formatting within strings?

On Nov 6, 10:31 pm, Ollie Jones <olliejo...@gmail.com> wrote:

> Spreadsheet::WriteExcel is wonderful, thanks for the great work.
> ..
> I don't believe I can switch to WriteExcelXML, because the readers of
> the stuff I'm generating have older versions of Excel.  Correct me if
> this isn't right.

Hi,

You are correct. These type of "Rich Strings" (Excel's name for them)
aren't currently possible in S::WE. They are one of the higher
priority TODO items but I'm not getting any time to work on new
features at the moment.

The usual suggested workaround is WriteExcelXML but it looks like you
were already aware of that.

So, apologies, there is no current solution.

John.
--


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Ollie Jones  
View profile  
 More options Nov 11, 1:53 pm
From: Ollie Jones <olliejo...@gmail.com>
Date: Wed, 11 Nov 2009 10:53:49 -0800 (PST)
Local: Wed, Nov 11 2009 1:53 pm
Subject: Re: formatting within strings?
Thank you John.

    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google