# Bug OP-5967 - Boolean CF with unset values are shown empty in export

Project: OpenProject
Status: closed
URL: https://community.openproject.org/work_packages/OP-5967

## Open points

_No work packages_

## Details

| Attribute | Value |
| --- | --- |
| Date |  |
| Priority | Medium |
| Module |  |
| Target versions | 10.0.0 |
| Observed in versions | 9.0.0 |
| Sprint | 10.0.0 |
| Backlog bucket |  |
| Bug found in version (deprecated) | 9.0.x |
| Found in mobile app version |  |
| Follow-up feedback e-mail |  |
| Requires doc change | No |
| Accessibility | No |
| Pull preview |  |
| List |  |
| Labels |  |

## People

| Attribute | Value |
| --- | --- |
| Assignee |  |
| Accountable |  |
| Product manager |  |
| Developers |  |
| Designer |  |
| Ordered by |  |
| Signed off by |  |
| Interest by |  |

## Planning

| Attribute | Value |
| --- | --- |
| Relevance |  |

## Costs

| Attribute | Value |
| --- | --- |
| Votes |  |
| Work |  |
| Labor costs |  |

## Description

### **Environment**:

OpenProject production (OP 9.0.2)

### **Steps to reproduce:**

1.  Create a Boolean custom field and add it to a work package type (type A) and activate it in a project.
2.  Go to the work package page in a project, add a work package of type A but do not set a value for the custom field.
3.  Add the Boolean custom field as a column to the work package list. -> When no value is set the CF is displayed as "no".
4.  Export the work package list as a XLS document.

### **Actual Behavior**

The value for the CF is empty which is inconsistent with the value displayed in OpenProject ("no").

### **Expected Behavior**

Quick solution: The value should be shown as "false" or "no".

Extensive solution: A third state (not set) should be added to custom fields of type Boolean. (The checkbox is however a useful representation which is frequently used - therefore the quick solution may be preferrable).