From: "Dr.Ruud" <rvtol+use...@isolution.nl> > On 15/05/2013 21:35, David Precious wrote: > > On Wed, 15 May 2013 10:34:02 +0100 > > Gary Stainburn <gary.stainb...@ringways.co.uk> wrote: > > >> Is it possible to write text cells where part of the string is > >> highlighted in red? If so, how can I do it? > > > > I'm fairly sure the format of a cell applies to the whole content of > > that cell - can you do what you're asking for in Excel or similar > > yourself? If not, then I very much doubt you can do it via > > Spreadsheet::WriteExcel. > > There is cell formatting and there is text formatting. > Each character can basically have its own background-color, > foreground-color, font, font-weight, etc. > > And beyond that, each cell can contain an object, like a Word-document. > But you don't need to go there to achieve what you want. > > First find out how you would do it in its internal language (VB?), > and then port that.
Knowing how it's done in "VB For Applications" would help if he was controlling an instance of excel via Win32::OLE. Then there would be a way to port that code to Perl. When using Spreadsheet::WriteExcel, the capabilities of whatever Excel he happens to have installed are at most an upper bound of features. Not something that could be taken for granted. If something is not possible via Excel, it most probably will not be possinble using S::WE, but the fact that Excel can do something doesn't say anything about S::WE. Jenda ===== je...@krynicky.cz === http://Jenda.Krynicky.cz ===== When it comes to wine, women and song, wizards are allowed to get drunk and croon as much as they like. -- Terry Pratchett in Sourcery -- To unsubscribe, e-mail: beginners-unsubscr...@perl.org For additional commands, e-mail: beginners-h...@perl.org http://learn.perl.org/
