Content
View differences
Updated by Andrej Sandorf 10 months ago
### Steps to reproduce
_Please write down the steps to reproduce. Try to write down all necessary preconditions (what permissions do you have, are other users involved?)._
1. Login as a user
user
2. Go to Time and Costs
3. Set up a report so you have data including the column "Date (spent)"
4. Click Export XLS
5. Open the XLS and see the date cannot be formatted as a Date field in Excel.
Excel.
I see there is a superfluous ' at the beginning of the date field that would prevent Excel from identifying it as a Date.
###
###
### Environment information
_Please check and fill out the following details to help us identify in what versions and distributions of OpenProject the error occurs_
**OpenProject installation type**
* [ ] Hosted cloud edition
* [ ] Packaged installation
* What distribution?
* [ ] Docker All-in-one container
* [ ] Docker-compose installation
* [x] Other: Other (please specify) - My own Community edition version
**OpenProject version**
_If you're not running on the cloud edition, please specify the version of OpenProject you're running. Example: v12.1.4_
**Browser**
* [x] Chrome
* [x] Firefox
* [ ] Safari
* [ ] Mobile Safari
* [ ] Other (please specify)
**Language**
English
###
###
* [ ] Hosted cloud edition
* [ ] Packaged installation
* What distribution?
* [ ] Docker-compose installation
* [x] Other:
**OpenProject version**
_If you're not running on the cloud edition, please specify the version of OpenProject you're running. Example: v12.1.4_
**Browser**
* [x] Chrome
* [x] Firefox
* [ ] Safari
* [ ] Mobile Safari
* [ ] Other (please specify)
**Language**
English