Bug 139995

Summary:	Conditional filters list is missing Cell value “is empty” and “is not empty” options
Product:	LibreOffice	Reporter:	NISZ LibreOffice Team <libreoffice>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	enhancement	CC:	buzea.bogdan, miguelangelrv, nemeth, tibor.nagy.extern
Priority:	medium
Version:	Inherited From OOo
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	87351
Attachments:	Example file from Excel with conditions “empty” and “not empty” Screenshot of the original document side by side in Excel and Calc

Description NISZ LibreOffice Team 2021-01-29 11:34:23 UTC

Created attachment 169264 [details]
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

Comment 1 NISZ LibreOffice Team 2021-01-29 11:34:39 UTC

Created attachment 169265 [details]
Screenshot of the original document side by side in Excel and Calc

Comment 2 m_a_riosv 2021-01-29 18:21:56 UTC

'Is equal to' ""
'Is not equal to' ""

Seems to work fine, but sure having 'empty' and 'not empty' would be fine.

+1