All,
It is about poi for Excel spreadsheet generation. Basically my question is whether it
is possible to put a rectangle shape into a cell using the gnumeric transformation
sheet. If it is not doable, can I generate the same thing by directly using Java code
to write a servlet?
Please your thoughts are appreciated!!
Charlene
-Original Message-
From: Yan, Charlene
Sent: Monday, June 09, 2003 11:13 AM
To: [EMAIL PROTECTED]
Subject: How is rectangle interpreted in gnumeric style sheet??? Help
Please!
Jody,
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:
Regards,
Charlene
-Original Message-
From: Jody Goldberg [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 10:56 PM
To: Yan, Charlene
Cc: [EMAIL PROTECTED]
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
> http://www.superlinksoftware.com/gnumeric-xml.pdf. 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
Jody
-
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]
