Mailing-List: contact poi-dev-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Developers List" <poi-dev@jakarta.apache.org>
Message-ID: <01d801c3faae$c760cfd0$5cc8a8c0@unicarte.trade2b.ro>
From: "Dragos Buleandra" <dragos.buleandra@trade2b.ro>
To: <poi-dev@jakarta.apache.org>
Subject: HSSF contributions
Date: Tue, 24 Feb 2004 10:18:27 +0200
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_01D5_01C3FABF.8AE273E0"

------=_NextPart_000_01D5_01C3FABF.8AE273E0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi ,

    My name is Dragos Buleandra . I'm a Romanian developer and I work =
for a German software company ( www.trade2b.com ).
    In our currently project, in the past 2-3 month ,  I'm in charge =
with exporting/importing data to/from Excel files .
    Because we were looking for Java Open source solutions , I searched =
on Internet and I found Jakarta Apache Poi project .
    I forgot to say that I'm a Java developer , with 4 years experience =
in this beautiful programming language .
    By working with POI and because the clients needed features =
unsupported by POI , I started to add new features into this library :

           1) - I fully implemented the entire "Data validation" Excel's =
mechanism - by implementing DV and DVAL records ( documented into=20
                  OpenOffice.org Excel's documentation ) . Of course , I =
created a method for easily usage of this mechanism .
                 All features available in Excel regarding this =
mechanism are supported ( Lists ..... , prompt and error boxes and so on =
) .
           2) - Fixed a bug occurred when cloning sheets which contains =
"Autofiltering"=20
           3) - Add 3 methods for easily group/outline rows in a sheet ( =
grouping/outlining columns is my current task , but in 2 days will be =
finished ) .
                 By implementing these methods , I fixed a bug into =
"WSBool" record , where fields "field_1_wsbool" and "field_2_wsbool" =
where filled/serialized=20
                 in the wrong order .
           4) - I also implemented a way to insert images ( in .bmp =
format ) . This feature use IMDATA and OBJ records . I found this =
solution into a Perl module ,
                  without having a documentation for this two Excel =
records , that's why I don't intend to post this patch .

     I saw on your forum that many people are expecting  Data =
validation" Excel's mechanism , in order to be able to generate Lists in =
Excel .
     If no one solved this problem , I'll be glad to do it myself .=20
     I'll be very happy if you can give me an answer ! After I'll finish =
to implement the methods required by grouping/outlining columns I want=20
    to post all my patches , that's why I need  to know if they aren't =
already implemented .

     Anyway , POI is a very nice project and very well written from the =
beginning . Congratulations !
     I'll be happy to become a contributor to this project !

Regards ,
    Dragos

------=_NextPart_000_01D5_01C3FABF.8AE273E0--