Re: writing excel files with merge and coloured cells
In reply to: http://marc.theaimsgroup.com/?l=xml-cocoon-users&m=104725042020751&w=2 Although gnumeric xml allows any colour to be specified, excel only has a 56 colour palette. This page shows excel's default palette (some details depend on the version): http://www.mvps.org/dmcritchie/excel/colors.htm If you choose a colour that isn't in the palette I think you get white. All the colours I've tried from this palette have worked except no. 45: #FF9900. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: AW: writing excel files with merge and coloured cells
Thats single threaded btw. See what happens if a few people hit it at once.
Gerald Michalitz wrote:
I am using the bsf (bean scripting framework) in with I use vb and
object rexx to create excel and use existing excel files
with this you can use ole objects like excel to work with
a little sample code:
xml-file
number CDATA #REQUIRED
]>
XSL-Transformation of a XML-file to a HTML-file or to a
PDF-file
This is an example:
xls file
with object rexx or vb or js you can do all what excel/word can do
gerald
-Ursprüngliche Nachricht-
*Von:* Rapcewicz, Chris [mailto:[EMAIL PROTECTED]
*Gesendet:* Donnerstag, 6. März 2003 21:28
*An:* '[EMAIL PROTECTED]'
*Betreff:* writing excel files with merge and coloured cells
Hi,
I am currently running Cocoon 2.0.4 on Tomcat 4.1 and I am
interested in creating excel files which have coloured cells and
also cells that are merged. I tried generating an xml from
gnumeric and using this, but found that neither the coloured cells
nor the merged cells were present.
Before I start trying to debug, I was wondering if this
functionality is supported?
Thanks,
Chris.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: writing excel files with merge and coloured cells
Yes the colors work. I do not think I ever implemented merged cells at the serializer level. -Andy Rapcewicz, Chris wrote: Hi, I am currently running Cocoon 2.0.4 on Tomcat 4.1 and I am interested in creating excel files which have coloured cells and also cells that are merged. I tried generating an xml from gnumeric and using this, but found that neither the coloured cells nor the merged cells were present. Before I start trying to debug, I was wondering if this functionality is supported? Thanks, Chris. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
AW: writing excel files with merge and coloured cells
Title: writing excel files with merge and coloured cells I am using the bsf (bean scripting framework) in with I use vb and object rexx to create excel and use existing excel files with this you can use ole objects like excel to work with a little sample code: xml-file account (#PCDATA)> account number CDATA #REQUIRED > ]> <page> <title>XSL-Transformation of a XML-file to a HTML-file or to a PDF-filetitle> <content> <para>This is an example:para> <account number="27"/> content> page> xls file <lxslt:component prefix="my-ext" functions="something"> <lxslt:script lang="rexx"> lxslt:script> lxslt:component> <xsl:template match="account"> <xsl:value-of select="my-ext:something(string(@account))"/> xsl:template> xsl:stylesheet> with object rexx or vb or js you can do all what excel/word can do gerald -Ursprüngliche Nachricht-Von: Rapcewicz, Chris [mailto:[EMAIL PROTECTED]Gesendet: Donnerstag, 6. März 2003 21:28An: '[EMAIL PROTECTED]'Betreff: writing excel files with merge and coloured cells Hi, I am currently running Cocoon 2.0.4 on Tomcat 4.1 and I am interested in creating excel files which have coloured cells and also cells that are merged. I tried generating an xml from gnumeric and using this, but found that neither the coloured cells nor the merged cells were present. Before I start trying to debug, I was wondering if this functionality is supported? Thanks, Chris.
writing excel files with merge and coloured cells
Title: writing excel files with merge and coloured cells Hi, I am currently running Cocoon 2.0.4 on Tomcat 4.1 and I am interested in creating excel files which have coloured cells and also cells that are merged. I tried generating an xml from gnumeric and using this, but found that neither the coloured cells nor the merged cells were present. Before I start trying to debug, I was wondering if this functionality is supported? Thanks, Chris. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
