Page 1 of 1

semicolon has to be escaped within a literal text

Posted: 21 Aug 2017, 03:23
by toralf
Don't realy know if this is a bug. But since it is against my expectation, I post in this forum section.

A semicolon has to be escaped within a literal text when a space or tab is to it's left.

Code: Select all

Column = C
Excel("=WENN(ISTLEER(B4) ; " . Column . "3 ; B4)")      ; AHK is throwing Error: Missing close-quote
Excel("=WENN(ISTLEER(B4) `; " . Column . "3 `; B4)")      ; This works, but is not very intuitive that a semicolon has to be escaped within a literal text
Return

Excel(f){
  MsgBox %f%
}
It seems that the Parser doesn't understand the code right.

Re: semicolon has to be escaped within a literal text

Posted: 21 Aug 2017, 03:34
by just me