Article Details
Id: | 20194 |
Product: | finPOWER Connect |
Type: | FIX |
Version: | 4.00.02 |
Opened: | 19/04/2023 |
Closed: | 19/04/2023 |
Released: | 27/06/2023 |
Job: | J030937 |
ISExcelCell; added Get and Set functions for Long values
The ISExcelCell class now includes functions to Get and Set Long values. Previously only Integer values were supported.
The following new functions are available:
- GetLong
- Will return 0 if the value is not numeric or outside the limits noted below.
- SetLong
- Will attempt to set the Cell to the Long value provided.
The following limits are applicable:
- Integer
- -2,147,483,648 through 2,147,483,647
- Long
- -9,223,372,036,854,775,808 through 9,223,372,036,854,775,807
Therefore, Long supports a greater range of numbers.
NOTE: If calling GetInteger and GetLong and the cell's value is outside the permitted range, 0 is returned. Trying to use SetInteger with a long value will fail with a compile error, so are easier to spot.