[Libreoffice-bugs] [Bug 139995] New: Conditional filters list is missing Cell value “is empty” and “is not empty” options

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 139995
           Summary: Conditional filters list is missing Cell value “is
                    empty” and “is not empty” options
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: nagy.tibor2 at nisz.hu, nemeth at numbertext.org
            Blocks: 87351

Created attachment 169264
  --> https://bugs.documentfoundation.org/attachment.cgi?id=169264&action=edit
Example file from Excel with conditions “empty” and “not empty”

In Excel it is possible to conditionally format cells that are empty or not
empty. Attached file demonstrates that.
Calc however does not offer this option on the Conditional Formatting dialog in
the “Cell value” condition list.
So this is a feature request to extend the list of supported conditions.

Steps to reproduce:
    1. Open attached file in Calc
    2. Go to Format – Conditional – Manage.

Actual results:
The list displays two “Formula is” type conditional formatting.

Expected results:
The conditions list should have “Cell value” entries of “is empty” and “is not
empty” so that these conditions in XLSX files can be mapped properly.
These may be useful on their own too :).
It might be necessary to extend ODF as well to accommodate for these.

LibreOffice details:
Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 7eb289c49cc7245ef3001a39be0c15d06bbe875b
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: CL


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=87351
[Bug 87351] [META] Conditional formatting bugs and enhancements
-- 
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/20210129/e2aa9f00/attachment-0001.htm>