Custom Query (3933 matches)

Fix EventLog.au3. Buffer sizes need to be dynamic instead of fixed.

Ref: Forum post 649304​http://www.autoitscript.com/forum/index.php?s=&showtopic=89906&view=findpost&p=649304

Request a standard and universally declared variable be included in the AutoIt environment (like $CmdLine and $CmdLineRaw) intended to hold the handle to the current COM Error Handler. Something like $oCOMError or $AutoItCOMErr.

Different UDFs using different naming conventions for the handler, leading to conflicts in proper handling. In the topic of the referenced post above, the error handlers for the _XMLDOMWrapper.au3 and IE.au3 UDFs collide.

If the AutoIt interpreter can cause something like $oAutoItCOMError to always reference the current error handler, like a ByRef, that would be great.

But if that is not feasible then perhaps just updating the documentation and putting the word out that every UDF should use the same variable name by convention would do it.

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]