Content
View differences
Updated by Niels Lindenthal 8 months ago
### Steps to reproduce
1. Export a work package this query with "Work" column as XLS.
2. Open the exported file in Excel or Calc.
3. In Excel or Calc: Sum the column "Work".
### 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 -> h
2. Example Project List: Budget -> €
2. * It is not possible to create a sum for the columns, e.g. "Work" or "Budget". Work column.
* Assumptions: the work cells is not formatted correctly as float
<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> <img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/788878/content">
### at What is the expected behavior?
1. The unit of the cells are cell is shown correctly (Work, Remaining Work, Spent time etc.). correctly.
<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">
###
1. Export a work package
2. Open the exported file in Excel or Calc.
3. In Excel or Calc: Sum the column "Work".
### 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 -> h
2. Example Project List: Budget -> €
2.
* Assumptions: the work cells is not formatted correctly as float
<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
1. The unit of the cells are
<img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/788874/content">
###