Article Details
Id:15729
Product:finPOWER Connect
Type:FIX
Version:3.01.10
Opened:17/12/2018
Closed:17/12/2018
Released:05/02/2019
Job: J021684

ExcelWorksheet.Cell; using ColumnName returns incorrect Column

Using the Business Layer function ISExcelWorksheet.Cell with a ColumnName returns the incorrect column.

For example; ExcelWorksheet.Cell("B",2) returns the cell "A2".

Note, the other Cell functions, by Cell Reference and Cell Indexes, i.e. ExcelWorksheet.Cell("B2") and ExcelWorksheet.Cell(2,2) work as expected.