Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Hi,
I am trying to get different format types within a single excel cell using Spreadsheet::WriteExcel. For example I would like to write the equivalent of this HTML within a single excel cell:

"This is Bold."

As far as I can tell, the format is per cell, and is invariant within a cell. So in theory I cannot have variable formats within a single cell ?

Many thanks in advance.
Phil

20050418 Janitored by Corion: Removed PRE tags, added formatting

  • Comment on SpreadSheet::WriteExcel formatting within a cell

Replies are listed 'Best First'.
Re: SpreadSheet::WriteExcel formatting within a cell
by jmcnamara (Monsignor) on Apr 18, 2005 at 14:14 UTC

    As far as I can tell, the format is per cell, and is invariant within a cell.

    This is correct. You cannot currently have more than one format in a cell.

    It is a planned feature for a future release.

    --
    John.

    See also: Spreadsheet::WriteExcel Google Group

      Thanks John.
      Phil