Excel reading cell problem in Oracle Forms 11.1.2
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.