https://issues.apache.org/ooo/show_bug.cgi?id=124828
--- Comment #5 from mroe <[email protected]> --- (In reply to lvanderwall from comment #4) > The constraint "<>''" works just fine in both Excel and AOO - so long as you > do not use it on combined empty cells. Another constraint from Excels help > file to detect empty cells ("<>"&"*") returned the same result in Excel, > supporting your theory that Excels ZÄHLENWENN() does count every cell of the > range, even when it contains combined cells. Maybe for Excel there is no empty cell? Please test it with =C18 or something similar. -- You are receiving this mail because: You are the assignee for the issue. You are watching all issue changes.
