﻿id	summary	reporter	owner	description	type	status	milestone	component	version	severity	resolution	keywords	cc
850	_ExcelReadSheetToArray doesn't work with German Excel 2003	Prog@…	Gary	"In _ExcelReadSheetToArray, the last-cell-string is Split by the character 'R' and 'C' for Row and Column. The problem is, Excel localizes this string, e.g. German: 'Z' (Zeile) instead of 'R' and 'S' (Spalte) instead of 'C'. So, the cell coordinates should be rad with a language-independant StringRegExp:
{{{
    Local $sLastCell = $oExcel.Application.Selection.SpecialCells($xlCellTypeLastCell).Address(True, True, $xlR1C1)
    
    ; Extract integer last row and col
    $sLastCell = StringRegExp($sLastCell,""\A[^0-9]*(\d+)[^0-9]*(\d+)\Z"",3)
    Local $iLastRow = $sLastCell[0]
    Local $iLastColumn = $sLastCell[1]
}}}"	Bug	closed	3.3.1.0	Standard UDFs	3.3.0.0	None	Fixed		
