formatting within strings?

[Ollie Jones]

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!

[jmcnamara]

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.
--

[Ollie Jones]

Thank you John.