Mailing-List: contact users-help@cocoon.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@cocoon.apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Message-ID: <44689D65.8020709@javanet.info>
Date: Mon, 15 May 2006 17:25:25 +0200
From: es <es.xml@javanet.info>
User-Agent: Mozilla Thunderbird 1.0.7 (X11/20050923)
MIME-Version: 1.0
To: users@cocoon.apache.org
Subject: java bean 2 OO Calc Xcell binding anyone?
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 8bit

Greetings community! (when next get-together  ?)

I need help/advices to automatically bind beans populated by CForm and 
an OpenOffice  Calc spreadsheet.
The fields are a lot (150 or more) now I wonder if there is a more 
clever idea then to do ooCalcWrapper.setCellValue( "C15", bean.getC15()) 
for 150 different fields.
Since a lot these cells are simple cellranges like C15:C30 I'm sure 
there is a way (how?) I can iterate the cellranges horizzontaly or 
vertically and set/get the value and fill a Collection.
Then I can use reflection to discover the get/set method of the bean and 
doing a binding.

Another thing:
Looking at the samples I've see that they way CForm can build up a 
dropdown list is using Enum. I wonder how can I generate it dynamically 
and how can I set the selected option on loading, since I need to get it 
from the underlying spreadsheet.

Since I'm in great pressure because I have to deliver the whole web 
application in 15gg if someone is interested in developing this or other 
things in this cocoon+openoffice+svg solution and is ready to jump in I 
have some �$work$� for you ! contact me for details pm
thanks
Eli Mad

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org