# Bug OP-17986 - Wrong cell format in XLS export do not allow for calculations

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

## Open points

_No work packages_

## Details

| Attribute | Value |
| --- | --- |
| Date |  |
| Priority | Medium |
| Module |  |
| Target versions | 16.5.1 |
| Observed in versions |  |
| Sprint | 16.5.1 |
| Backlog bucket |  |
| Bug found in version (deprecated) |  |
| 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 | Jens Ulferts |
| Product manager |  |
| Developers | Attila Dombi |
| Designer |  |
| Ordered by |  |
| Signed off by |  |
| Interest by |  |

## Planning

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

## Costs

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

## Description

### Steps to reproduce

1.  Export a work package query with &quot;Work&quot; column as XLS.
    
2.  Open the exported file in Excel or Calc.
    
3.  In Excel or Calc: Sum the column &quot;Work&quot;.
    

### What is the buggy behavior?

1.  In the Excel export the cells do not have the correct format and unit.
    
    1.  Example Work Package List: Work, Remaining work -&gt; h
        
    2.  Example Project List: Budget -&gt; €
        
2.  It is not possible to create a sum for the columns, e.g. &quot;Work&quot; or &quot;Budget&quot;.&nbsp;
    

<figure class="image op-uc-figure"><div class="op-uc-figure--content"><img class="op-uc-image" src="/api/v3/attachments/788878/content"></div></figure>

### at is the expected behavior?

1.  The unit of the cells are shown correctly (Work, Remaining Work, Spent time etc.).
    

<img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/788874/content"> <img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/788875/content">

###
