https://bugs.documentfoundation.org/show_bug.cgi?id=168169
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Ever confirmed|0 |1 OS|Linux (All) |All Summary|[Regression] Spreadsheet |Spreadsheet produces BASIC |produces BASIC runtime |runtime error 380 |error 380 | Version|25.2.5.2 release |Inherited From OOo Status|UNCONFIRMED |NEW --- Comment #1 from Mike Kaganski <[email protected]> --- No this is not a regression. Unfortunately, it seems that the confirmation in bug 149157 comment 8 didn't involve actually testing that code works - only that opening the file doesn't immediately fires a compilation error. Because already in 7.4.0, clicking any cell gives the same error, caused by evaluation on COUNTA in the complex condition pointed to in the error. The problematic code is in ScFunctionAccess::callFunction, where sheet::XSheetCellRanges or container::XEnumerationAccess variant is not checked / handled, while the object passed there is ScCellRangesObj. It is reproducible already in OOo 3.2.0. The following code shows it: Option VBASupport 1 Sub TestRanges if Application.CountA(Range("D19:Q23,D25:Q39")) > 0 then MsgBox "?" End Sub -- You are receiving this mail because: You are the assignee for the bug.
