New year and new resolutions (Excel-like javabean for Oracle Forms)

Posted on January 8th, 2010.

Fortunately, 2009 is now gone. Really bad year as far as I am concerned. I lost my father in October after an illness. That does not justify the lack of posts or the updates on the various forms components I have here. The mood was not there unfortunately.

However, I did manage to squeeze out a nice Excel-like javabean that can be connected to Oracle data sources from Forms. While that works, I am totaly at a loss of what can be done with it since I am not really a spreadsheet expert.

So, if you have in mind some nice business scenarios for such a bean, please let me know. That would include for example one or more tables and simple usage scenario for a spreadsheet usage within Oracle Forms. Send them to info [at] degenio.com

The one I have done was just to import the data from the table and from there do some charting within the Excel bean. It would be interesting to get some financial usage scenarios.

Similar Posts:

Make a Comment

Make A Comment: ( 18 so far )

blockquote and a tags work here.

18 Responses to “New year and new resolutions (Excel-like javabean for Oracle Forms)”

RSS Feed for Oracle Developer Tools and Thoughts Comments RSS Feed

Hello Hafed,
Write the Bean, and be sure that someone will find a good application of it ;-)
Francois

Francois
January 19th, 2010

Yes, that’s true Francois. However, I am interested in getting at least one case study to use as a showcase.

Hafed
January 19th, 2010

Maybe a kind of invoice with crossed calculation (line + coluum) ?

Francois
January 19th, 2010

I would be more than happy to work with you on this, I have long been in search of something such as this. I would like to be able to have a dynamic interface to sort, rearrange and customize columns based on user specs that is easily implemented.
Scott

Scott
February 7th, 2010

@Scott: That’s interesting. I will be sending you the bean for testing. Thanks.

Hafed
February 8th, 2010

Thats great, thanks.

Scott
February 11th, 2010

hi,
Please send me the sample. I have the requirement, that most of the
reports, we use view to display in forms. Many of the fields are very
lengthy and it is not fit in the screen, so if i get a bean which
have the flexibility like increase/decrease width, sort colum, etc.
will be very helpful.
thank you
Daniel

Saji Daniel
February 16th, 2010

If you could send through the bean/code I’d be interesed in trying it out/trying to make use of it. I can see some interesting possiblities in using this sort of bean for suppling budgeting/forecasting functionality.

Rich

Richard
February 17th, 2010

Just wondered if you still wanted some help/input on this?
If so could you send the bean to me ?
Thanks
Richard

Richard
March 25th, 2010

Hi I’m also looking for an excel like java-bean with high functionality.
- switching of columns, sorting, exporting of data, changing of size, highliting of changes, filter.

could you please send the example bean?
I already tested the excel-like java-bean on Mr. Francois Degrelle’s blog, but i neeed something that has more functionality. Thanks in advance

Jerry
March 31st, 2010

Hello Hafed,
I am writing an application which shows 360 degree item views and would like to use the excel bean like filters which will make the item views more usable and provide great visibility. If you could send the bean to me, that will be great.

Mani Shankar Choudhary
April 15th, 2010

So, Hafed, what’s new with this bean ?

Francois
April 21st, 2010

@Francois: same thing is happening while developping Frite. I can’t find the time to polish the bean.
Nevertheless, I am trying to get it out before june 2010.

Hafed
April 21st, 2010

Hi. I recently came upon your blog and have an Oracle Forms question.
I have a situation whereby I am using a Pashto (Afganhistan ) keyboard and various Pashto characters are not being echoed within an input text field, but do indeed save to the DB; a standard Java Swing appl does echo all of the Pashto characters.
Question: is there a way to implement a PJC to sit “on top” of the actual input text field and do the I/O itself right there, and then place the data back in the text field ?

Thanks.
Channeld

Art
May 12th, 2010

@art: You are looking here at a PJC. You can implement it very easily. I saw something similar over at Sheikh Yerbouti website (Francois Degrelle). See http://forms.pjc.bean.over-blog.com/

Hafed
May 12th, 2010

hi,

what about using this to emulate the grids from .net? with something like this we could have some column swapping, column resizing/hiding and sorting.
Do you think is it possible to develop something like this?
thx

Miguel Lima
May 21st, 2010

Hafed,
Have you managed to make any more progress on this bean ?

Ricky

ricky
August 6th, 2010

@ricky: no unfortunately. While it has been coded almost in full (java), I am still left with the Forms integration. However, I really want to get it out before this Fall.

Hafed
August 6th, 2010

Where's The Comment Form?

About

Enterprise IT Tools and Thoughts, dealing mainly with Oracle Developer tools (Forms & Reports)

By Hafed Benteftifa

Recent Comments

RSS

Subscribe Via RSS

  • Subscribe with Bloglines
  • Add your feed to Newsburst from CNET News.com
  • Subscribe in Google Reader
  • Add to My Yahoo!
  • The latest comments to all posts in RSS