Numbers in computations
Exponential representation of numbers is used for Double data type (15 significant digits, so called mantissa, and E-part, so called exponent).
Let's see your example 15525.22352000e25. It is converted to Double because it is greater than the biggest integer data type Long (values from -2,147,483,648 to 2,147,483,647)
There is ...
Your issue is that the Object Repository has learned this object with a title or caption including the number (95) which increments.
The solution is to change the property in the Object Repository to a regular expression which will allow the title/caption to match on the parts which are static, so if you have
"Fax Order No. 95"
As your Title property for ...
If you want to delete a column/columns:
Delete "CatNo" cloumn from "cats info" sheet.
datatable.GetSheet("cats info").DeleteParameter "CatNo"
As far as I know you can always open it with Excel and to it "manualy".
There are several ways you can do this, depending on the nature of your application. Some suggestions:
If status changes based on time since creation and you have access to the database, part of your setup is to set the database object creation timestamp to 47:00:59 before now, then wait one second and check the object.
If there is a configurable wait time ...
bmshort will work for positive numbers but may give wrong output for negative numbers with your example.
Use Fix instead of Int which should work for both positive and negative numbers
Dim x : x = 1252.225522658695
Dim y : y = 8
print Fix (x * 10 ^ y)/10 ^ y
Try to change x to -1252.225522658695, output would be -1252.22552265
The next code solves the problem:
Set cellRender = jTableObj.Object.getCellRenderer(0,1)
' background color '
' returns: "javax.swing.plaf.ColorUIResource[r=255,g=255,b=255]" '
' font color '
' returns: "java.awt.Color[r=255,g=255,b=180]" '
' font name, style, size '
Ctrl key is used to temporary disable spying, so one could perform preparatory operations.
So you sould do the next steps:
Click the Object Spy button
Hold Ctrl key
Expand the menu
Release the Ctrl key
Then you can check here how to code select action for drop-down menu in UFT.