You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by Andreas Engel <ma...@a-engel.de> on 2005/06/13 20:14:14 UTC
are xml model definitions mandatory for further development?
hy everybody, it's me again ... the one asking stupid questions :)
first i wanted to ask whats going on about the xml model definition files ...
are they mandatory? do i have to create such one first? (are all record
classes generated by such definitions?)
a second question i have to throw in is about the string conversion:
i ran into some deserialization problems for doper (autofilter) strings.
my attempt to reengineer the autofilter record completely fails when it comes
to the reserved fields of the autofilter structure related to strings. can
someone give me a hint if the referred book "Excel 97 Developer's Kit'
explains especially the undocumented reserved sections of biff records?
have a nice day
andreas
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
comments about usability of book 'excel 97 developers kit'
Posted by Andreas Engel <ma...@a-engel.de>.
hello list, hello andy - thanks for your reply
sorry for wrong subject, here again my former questions:
> i don't know anything about NDAs. i never got in direct touch with such
> stuff. in my earlier days (must be about 8 or 9 years back) i used to use
> some products from MS. currently i'm only oppressed by licenses like GPL,
> LGPL, MPL and similar ones;)
>
> the documentation i'm refering to, thats the only and just slightly helpful
> documentation about biff 7/8 formats is the one at
> http://www.zuhl.com/~mikez/Info/ExcelFmt/index.html
> as far as i could recherche this IS a excerpt from the 'excel 97 developers
> kit' ... but maybe there is a lot more detailed information available in
> some other chapters!? what i'm looking for is the description of the bytes
> marked as '(reserved)' of the doper structures mentioned at the bottom of
> http://www.zuhl.com/~mikez/Info/ExcelFmt/s59d58.htm (especially the string
> doper reserved fields).
> don't want to waste money for a product/company thats definitely useless.
> so if someone of you could check for existence of the missing puzzle parts
> it would eventually help me to save money and the time for waiting for the
> book:)
i just added a class PhoneticRecord to the autofilter issue on poi bugzilla
http://issues.apache.org/bugzilla/show_bug.cgi?id=35125
this record is far away from your actual battle fields, of course. since the
phonetic record seems to be written mistakenly by genuine excel applications
(as described on website posted above) it can be safely suppressed during
deserialization. but if (only) added to biffviewer it helps at least to get a
better point of view about whats going on inside an excel file (meaning: one
more record which can be identified safely and so does not appear as unknown
record).
maybe you can use this code snippet.
i also started examining the cell comment issue since it seems to be highest
rated and in my todo list on nearly same level than autofilter is.
after some dump-inspections i argue to be in need for further documentation as
i'am in the case of the autofilter implementation. so if someone could point
me wether the excel developers kit is able to give me more detailed insight i
could go on faster.
>
> thanks in advance and a nice evening
> andreas
p.s. sorry for my english, yoda my teacher was ;)
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
Re: are xml model definitions mandatory for further development?
Posted by Andreas Engel <ma...@a-engel.de>.
hello list, hello andy - thanks for your reply
i don't know anything about NDAs. i never got in direct touch with such stuff.
in my earlier days (must be about 8 or 9 years back) i used to use some
products from MS. currently i'm only oppressed by licenses like GPL, LGPL,
MPL and similar ones;)
the documentation i'm refering to, thats the only and just slightly helpful
documentation about biff 7/8 formats is the one at
http://www.zuhl.com/~mikez/Info/ExcelFmt/index.html
as far as i could recherche this IS a excerpt from the 'excel 97 developers
kit' ... but maybe there is a lot more detailed information available in some
other chapters!? what i'm looking for is the description of the bytes marked
as '(reserved)' of the doper structures mentioned at the bottom of
http://www.zuhl.com/~mikez/Info/ExcelFmt/s59d58.htm (especially the string
doper reserved fields).
don't want to waste money for a product/company thats definitely useless. so
if someone of you could check for existence of the missing puzzle parts it
would eventually help me to save money and the time for waiting for the
book:)
thanks in advance and a nice evening
andreas
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
Re: are xml model definitions mandatory for further development?
Posted by ac...@apache.org.
No, but unit tests ARE more or less mandatory (well only if you want us
to commit it).
Describe what documentation they are "undocumented" in? The Excel 97
Developer's kit is the general definitive place were something is either
"documented" or "undocumented" in. U/f I'm not at home near my copy so
I can't say ATM. Be careful about entanglements (we ask a lot of
questions about new code sometimes to make sure no one has signed an NDA
with MS).
-Andy
Andreas Engel wrote:
> hy everybody, it's me again ... the one asking stupid questions :)
>
> first i wanted to ask whats going on about the xml model definition files ...
> are they mandatory? do i have to create such one first? (are all record
> classes generated by such definitions?)
>
>
> a second question i have to throw in is about the string conversion:
> i ran into some deserialization problems for doper (autofilter) strings.
> my attempt to reengineer the autofilter record completely fails when it comes
> to the reserved fields of the autofilter structure related to strings. can
> someone give me a hint if the referred book "Excel 97 Developer's Kit'
> explains especially the undocumented reserved sections of biff records?
>
> have a nice day
> andreas
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
>
--
Andrew C. Oliver
SuperLink Software, Inc.
Java to Excel using POI
http://www.superlinksoftware.com/services/poi
Commercial support including features added/implemented, bugs fixed.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/