You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Avik Sengupta <av...@apache.org> on 2003/11/04 14:15:52 UTC
RC1 Testing
Now that RC1 is out for your testing pleasure, it will be very nice if
as many people as possible give it a whirl, to ensure that we dont have
any nasty regressions hidden in it.
Regards
-
Avik
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
More documents and records decoded [was: RC1 Testing]
Posted by Jean-Pierre Paris <jp...@waidan.com>.
Hello!
Here is a rapid sketch of my goal and of the state of my work as
asked by Avik.
I started to work on poi 1.5.1: my goal is to have an xls template,
add some data in it (say several sheets) and write the xls result.
Unfortunatly, in some case I must include VBA code in the xls
template, and my test cases fail with 1.5.1.
As it is mandatory for me to cope with VBA, I downloaded 1.5.1 src
and started to dig into. First, I have adapted BiffViewer so that it
print information for all Documents found in the xls file (that is
for example Ctls, ?CompObj, ?SummaryInformation,
?DocumentSummaryInformation, Workbook, and for VBA the following
rirectory structure
VBA_PROJECT_CUR
PROJECT
PROJECTwm
VBA
__SRP_1
__SRP_3
__SRP_2
__SRP_0
_VBA_PROJECT
ThisWorkbook
Feuil1
dir)
For Document with unknown structure, I dump hex values flow using
HexDump.
After, that I have decoded the structure of some Document or records,
but I only used them in the BiffViewer context (I have not used or
tested the serialize method):
1. Ctls Document. classical record format: sid (16), len (16),
value... I wrote the following records, without any interpretation
of the content. For me it is just a byte flow, but it could be a
good start for someone who wants to figure out the semantic of
each byte.
ComboBoxRecord (0x1D30
CommandButtonRecord (0x3240)
CtlXtraRecord (0x200): already extists in Workbook (Dimension),
but seems not to be relaoted to
ListBoxRecord (0x1D20)
2. Workbook. No need to elaborate about the structure!
I added those records, but as sayd previously, I can't figure out
the semantic, those are only bytes flows.
ControlsRecord (0xEB), ControlsXtraRecord (0xEC)
Both records contains hierarchical records that mimic the
classical format but in 32 bits: sid is stored in 4 bytes as
length does. I have coded 2 records, one for intermediate nodes
and one for terminal ones.
ControlsInfoRecord (0x5D)
This record contains a set of record in the classical 16 bits
format. I handled those records as UnknownRecord
3. VBA_PROJECT_CUR.PROJECT. This document contains a set of Dos
strings (8 bits 0x0D 0x0A terminated). I coded the DosLineRecord,
but have no clue about the actual content
4. VBA_PROJECT_CUR.PROJECTwm. This document contains a set of null
terminated utf8 or utf16 strings. I coded the String8 and
String16.
I have developped all that code OUTSIDE the poi tree and without unit
tests and javadocs. What I have to do before I can publish that for
the community is:
1. Integrate in the poi src tree, and by the way understand how to
use Ant as I use make for the moment! Check for compatibility with RC1
my code is based on 1.5.1
2. Add JUnit tests. To do that, I have some questions: for example,
what is the definition of getRecordSize return value. I suppose
I'll find the answer if I dig into the record test cases
3. Write down some javadocs
As it is a work I don't like a lot ;-), I'm willing to do that only if
it is usefull to someone around there. As asked by Avik, I'm also ready
to "stay" in the project as a contributor. I have several ideas of what
I can contribute, but that's another story...
Hope this help to undestand what I have done (apologies for my
English, which IMHO is not quite as good as I wanted!)
Regards and again, thanks to all for making poi/hssf working!
bye
jp
--
Jean-Pierre Paris - Waidan, 300 route des crêtes, 06902 Sophia Antipolis
Tel: (+33)4 93 00 60 43, Fax (+33)4 93 00 60 46
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org
RE: RC1 Testing
Posted by av...@itellix.com.
What exactly does your code do? If its useful, its certainly welcome, with a
couple of proviso's. We've gotten wary of code without testcases; also we like
if the code contributor sticks around and works with us, rather than throw and run.
Having said that, you may want to describe what you have on the list, and attach
a patch into bugzilla.
Quoting Jean-Pierre Paris <jp...@waidan.com>:
> Hello!
>
> I was working since a while poi 1.5.1 so that to improve hssf managment of
> VBA code (that is reading xls changing some cells and writing it back, not
> producing VBA from hssf!). I have decoded some Records, but I am a bit stuck
> now.
>
> However, I downloaded the CVS head yesterday, and, my test case works
> perfectly! Thanks to everyone for that great job! I want to know if I should
> submit my partial work if for example VBA support is in the future plans.
>
> Please let me know! I don't want to post unused code, but I would really
> pleased to contribute as POI hssf will save me a lot of pain!
>
> bye
> jp
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-dev-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org
RE: RC1 Testing
Posted by Jean-Pierre Paris <jp...@waidan.com>.
Hello!
I was working since a while poi 1.5.1 so that to improve hssf managment of
VBA code (that is reading xls changing some cells and writing it back, not
producing VBA from hssf!). I have decoded some Records, but I am a bit stuck
now.
However, I downloaded the CVS head yesterday, and, my test case works
perfectly! Thanks to everyone for that great job! I want to know if I should
submit my partial work if for example VBA support is in the future plans.
Please let me know! I don't want to post unused code, but I would really
pleased to contribute as POI hssf will save me a lot of pain!
bye
jp
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org