Oracle Forms (MOSC)

MOSC Banner

Excel reading cell problem in Oracle Forms 11.1.2

edited May 9, 2018 5:02AM in Oracle Forms (MOSC) 5 commentsAnswered

Hello,

     I've an application that reads data from Excel.

This application is deployed in various applications servers depending on the client, for example:

  • OAS 10.1.2.3.0
  • Forms 11g (11.1.1) in Weblogic 10.3.3.0
  • Forms 11g (11.1.2) in Weblogic 10.3.6.0

For the interaction with Excel I use the Webutil library with the rigth version depending on the Forms version used:

  • OAS 10.1.2.3.0: jacob 1.0.6
  • Forms 11g (11.1.1) in Weblogic 10.3.3.0: jacob 1.10.1
  • Forms 11g (11.1.2) in Weblogic 10.3.6.0: jacob 1.14.3

In OAS 10.1.2.3.0 and Forms 11g (11.1.1) in Weblogic 10.3.3.0 the following instruction works fine

cell_value :=Client_OLE2.get_char_property(cell, 'Value');

But in Forms 11g (11.1.2) in Weblogic 10.3.6.0 if I read an integer value like 15 the read value is 15.0, where .0 is added to the end of the real value, whereas in the rest of application servers the read value is 15 which is the correct value.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center