You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cocoon.apache.org by Ted Kaczmarek <te...@optonline.net> on 2003/01/01 00:12:23 UTC
Re: HSSFSerializer - Extensions?
I am fairly ignorant on xml, but the other day I wanted to be able to
color code a spreadsheet. My hope was to open up the gnumeric doc saved
as xml, look at the fields I color coded and do the rest of the changes
with %s/ in vi.Is their was for an xml doc generated by gnumeric to have
tags for colors?
Regards and Happy New Year to all.
--
Ted Kaczmarek <te...@optonline.net>
On Tue, 2002-12-31 at 11:14, Jody Goldberg wrote:
> We're amenable to extensions to the existing format. Moreover
> gnumeric is going to be making a jump to a new wrapper format
> shortly at which time I hope to make larger scale changes to
> the xml representation and would appreciate any feedback you have on
> limitations or irritations in the current schema.
>
> On Fri, Dec 27, 2002 at 02:39:05PM -0500, Andrew C. Oliver wrote:
> > My thought would be to make the changes acceptable but not required and
> > notify the gnumeric folks
> > (http://mail.gnome.org/mailman/listinfo/gnumeric-list) about the
> > extensions. They might be interested in
> > implementing them. For the actually SCHEMA, create a different schema
> > based on the original and mark
> > files which use the extensions as being compliant to that schema and not
> > the one hosted at/by gnumeric...
> >
> > -Andy
> >
> > Danny Mui wrote:
> >
> > >
> > >There are some features that HSSF supports that gnumeric does not, one
> > >instance is setting fonts for the header/footer (among others). This
> I'd be interested in a list of the others. Adding this would be
> simple and would give me some insight into what sorts of features
> real users are looking for.
>
> > >is currently a need for my project I'm working on and I'm wondering
> > >how I should go about implementing this.
> > >
> > >Should I extend the schema to accomodate these new features?
> > >
> > >I extended the schema to support a few things so far:
> > >1) Added an 'inches' unit designation to pass-through the values for
> > >margins since the 'in' unit requires conversion.
> Requires conversion by what ?
>
> > >2) Added a &[FILE] attribute for the header/footer since excel
> > >supports it but my version of gnumeric does not.
> I just added it in about 10 seconds. The extension will be in
> 1.1.15, and is trivial enough that I could back port it to be in the
> next stable release 1.0.12.
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list@gnome.org
> http://mail.gnome.org/mailman/listinfo/gnumeric-list
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org
Re: HSSFSerializer - Extensions?
Posted by Ted Kaczmarek <te...@optonline.net>.
At work I have been doing application profiling, I took my data captures
statistics and exported them to csv. The sheet was then sorted by
application flows and clients.
In this data capture their were 10 clients connecting to N servers
generating anywhere from 80-120 flows. I was hoping to be able to color
code the clients names and the applications names in the spreadsheet.
Regards,
Wishing everyone a splendid New Year!!!!!
Ted
On Wed, 2003-01-01 at 02:48, Jody Goldberg wrote:
> On Tue, Dec 31, 2002 at 06:12:23PM -0500, Ted Kaczmarek wrote:
> > I am fairly ignorant on xml, but the other day I wanted to be able to
> > color code a spreadsheet. My hope was to open up the gnumeric doc saved
> > as xml, look at the fields I color coded and do the rest of the changes
> > with %s/ in vi.Is their was for an xml doc generated by gnumeric to have
> > tags for colors?
>
> So you want to tag the cells from within gnumeric then use the tags
> to do the modifications directly in the xml ? Hmm. Its doable, but
> certainly not simple. The StyleRegions are a level of indirection
> between individual cells and formats. The cell with the content you
> want to change will not have a simple text editor mapping back to
> the style region. You'd need to parse the xml. What are you trying
> to do ? Search and Replace within gnumeric should give you a fair
> amount of power. Please file an enhancement request for this in
> bugzilla.gnome.org It would be fairly simple to extend the style
> specification to add 'Custom xml tag', or something like it, for the
> next version.
>
> Hope that helps
> Jody
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list@gnome.org
> http://mail.gnome.org/mailman/listinfo/gnumeric-list
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org
Re: HSSFSerializer - Extensions?
Posted by Jody Goldberg <jo...@gnome.org>.
On Tue, Dec 31, 2002 at 06:12:23PM -0500, Ted Kaczmarek wrote:
> I am fairly ignorant on xml, but the other day I wanted to be able to
> color code a spreadsheet. My hope was to open up the gnumeric doc saved
> as xml, look at the fields I color coded and do the rest of the changes
> with %s/ in vi.Is their was for an xml doc generated by gnumeric to have
> tags for colors?
So you want to tag the cells from within gnumeric then use the tags
to do the modifications directly in the xml ? Hmm. Its doable, but
certainly not simple. The StyleRegions are a level of indirection
between individual cells and formats. The cell with the content you
want to change will not have a simple text editor mapping back to
the style region. You'd need to parse the xml. What are you trying
to do ? Search and Replace within gnumeric should give you a fair
amount of power. Please file an enhancement request for this in
bugzilla.gnome.org It would be fairly simple to extend the style
specification to add 'Custom xml tag', or something like it, for the
next version.
Hope that helps
Jody
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org
Re: HSSFSerializer - Extensions?
Posted by "Andrew C. Oliver" <ac...@apache.org>.
Ted Kaczmarek wrote:
>I am fairly ignorant on xml, but the other day I wanted to be able to
>color code a spreadsheet. My hope was to open up the gnumeric doc saved
>as xml, look at the fields I color coded and do the rest of the changes
>with %s/ in vi.Is their was for an xml doc generated by gnumeric to have
>tags for colors?
>
>Regards and Happy New Year to all.
>
>
>
Thats the style region. Colors are assigned to style regions..
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org