Custom Query (3931 matches)

AutoIT throws the following error when trying to read an the Excel comment if it is empty Local $sStr = $oExcel.Cells($i, "I").Comment.Text Local $sStr = $oExcel.Cells($i, "I").Comment ^ERROR

If the comment is not empty, the comment text is returned.

I am using version 3.3.14.1 & Excel 2003. The error is not present in the previous release version of AutoIT. The problem may be related to an error already reported, but I could not find anything specific

I found a nice script here: ​http://www.autoitscript.com/forum/topic/141103-barcode-udf/page-2#entry1117722

I was trying to use it and I had HardCrash.

It happen on production and latest beta AutoIt

you can get ActiveX: OcvitaBarcode.ocx here: ​http://ocvita.ru/content/view/90/35/

exactly : ​http://ocvita.ru/downloads/ocvitabarcode.php

Here is my smalest reproduction script with comment:

Global $oBCode, $oBCodeGUI


$GUI = GUICreate("OCVITA_BARCODE by AutoIt3, Valery Ivanov, 19 September, 2013", 400, 400, -1, -1)
$oBCode = ObjCreate("Ocvita.Barcode")
$oBCode.symbology = 1
$oBCodeGUI = GUICtrlCreateObj($oBCode, 10, 110, 380, 280)
GUISetState()

ConsoleWrite('!' & @ScriptLineNumber & @CRLF)
; check - if step 1 is OK
$oBCode.AboutBox()

ConsoleWrite('!' & @ScriptLineNumber & @CRLF)
CRASH_IS_HERE_RefreshBCode(2)

; check - if step 2 is OK
$oBCode.AboutBox()

Func CRASH_IS_HERE_RefreshBCode($NewSymIndex)

	; Crash only if this ObjCreate is used - comment them to avoid crash
	$oBCode = ObjCreate("Ocvita.Barcode")
	ConsoleWrite('!' & @ScriptLineNumber & @CRLF)
	$oBCode.symbology = $NewSymIndex
	ConsoleWrite('!' & @ScriptLineNumber & @CRLF)

	; !!!!!!!!! EXACTLY HERE
	$oBCodeGUI = GUICtrlCreateObj($oBCode, 10, 110, 380, 280)
	ConsoleWrite('!' & @ScriptLineNumber & @CRLF)
EndFunc   ;==>CRASH_IS_HERE_RefreshBCode

And I want to ask: if you can add some @error chcecking to: ObjCreate() and GUICtrlCreateObj()

mLipok