cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yan, Charlene" <>
Subject How is rectangle interpreted in gnumeric style sheet??? Help Please!
Date Mon, 09 Jun 2003 15:13:16 GMT

Thank you very much for taking the time to explain it to me.  The style color is working.
 However, I have a new problem I'm wondering whether you can help.  I need to put a rectangle
in one of the cells.  In Excel, I add the rectangle to a cell by first clicking the rectangle
of the drawing toolbar, and then clicking anywhere on the active spreadsheet, and then resizing
it to fit into a cell.  The following is the only infomation I found in the gnumeric file
format specs that may match what I need to do.  Here are my questions.  Is rectangle considered
as an object?  If so, what is the syntax to put it in a cell?  Any information is highly appreciated!!!

3.13 Objects
This section records details about any objects that have been added to the
worksheet. Cell comments are represented as objects:
<gmr:CellComment Author="" Text="" ObjectBound="D4"
ObjectOffset="0 0 0 0" ObjectAnchorType="33 32 33 32"/>


-----Original Message-----
From: Jody Goldberg []
Sent: Thursday, June 05, 2003 10:56 PM
To: Yan, Charlene
Subject: Re: style color does not show up in Excel, Is it working with
Excel or the feature only in Gnumeric????

On Thu, Jun 05, 2003 at 01:47:08PM -0400, Yan, Charlene wrote:
> Jody,
> Thank you, thank you and thank you!!!  Changing the shade value
> works.  Do you know where I can find more documentation on gmr
> stylesheet specs?  I only have The Gmumeric File Format from
>  Should I go
> ahead and download gnumeric to learn more?

I'm sorry to say that we've never written any.  The entire story is
muddles somewhat in that you're writing xml in gnumeric format that
is being interpretted by an application other than Gnumeric, which
then stores the result in an obscure binary blob (aka xls).  

Reading our source code makes it trivially clear what the format is
doing (gnumeric/src/xml-io.c).  However, how that maps out to xls is
over in an entirely different area.  gnumeric/plugins/excel

We've tried hard to make our lives easier by maintaining a fairly
simple mapping between xls attributes and .gnumeric.  However, as we
delve deeper into the mysteries of MS Excel things get more obscure.

This list is the right place to ask questions about our intent, but
I may not be able to say much once things start depending on actual
implementations.  If you're operating in a unix environment you
could probably use gnumeric to do the conversion directly.  I could
be alot more helpful there.

Good Luck

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message