[Libreoffice-bugs] [Bug 93510] Automatically find column and row labels may determine a row label instead of column label.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=93510

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |erack at redhat.com
            Summary|Regular expressions do not  |Automatically find column
                   |works when enabled          |and row labels may
                   |automatically find columns  |determine a row label
                   |and rows labels             |instead of column label.

--- Comment #4 from Eike Rathke <erack at redhat.com> ---
Regular expressions are not the culprit here, adjusting summary. The problem is
that in B11
=SUMIF('Product';".*Pencil.*";'Number')
the 'Product' auto-label name from A1 is compiled as a row label instead of
column label, the resulting reference is B1, which of course does not match.

In ScCompiler::IsColRowName() near the end the distinction is made whether
another string cell is below or above the label cell, usually labels are used
with numeric data if in columns. An additional check whether the label is
actually the top or bottom of a filled cell range would indicate a more likely
column label, but not solve this case of a corner cell.

Those auto-labels should be deprecated anyway as they may fail in other ways
when data varies, the proper solution is to use defined labels instead.
Sheet -> Named Ranges and Expressions -> Labels...

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200114/639b0dd5/attachment-0001.htm>