https://bugs.documentfoundation.org/show_bug.cgi?id=168169
--- Comment #3 from studog <[email protected]> --- (In reply to Mike Kaganski from comment #1) > 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. This is true, since the bug I reported was the failure-on-open. I tested and confirmed the fix for that. These are spreadsheets that Canadian dividend-/distribution-paying companies are required to file. I am not involved at all in the coding, I am merely a consumer. In general, I am not mucking around with the spreadsheet at all. I think just now I accidentally clicked on a cell. When I looked up the old bug my memory of it was "sheet worked" so I thought this was a regression. I'll fix the title if I can. > The following code shows it: > > Option VBASupport 1 > > Sub TestRanges > if Application.CountA(Range("D19:Q23,D25:Q39")) > 0 then MsgBox "?" > End Sub I'll leave this open then; sounds like a legit issue as long as LO is still doing "if it works in Excel it should work in Calc". -- You are receiving this mail because: You are the assignee for the bug.
