I downloaded the excel version of the monthly time sheet report. When trying to sum the totals, Excel does not recognise the numbers as such and shows a 0 total.
Date
Votes
2 comments
-
PPO Development We have discussed this with our technical team and unfortunately at this stage we do not have a quick solution. The reason why it does not calculate is because there is a "special character" behind the number which then does not allow it to calculate (looks like a space behind it).
The problem is that the Excel view is actually the same as the normal view, i.e. we stream the output and just change it so that it opens the HTML in Excel. It is in fact not a space behind the number but rather a special character that we use to ensure that it shows correctly in the normal view.
This problem is not limited to only this one report, but probably most reports that contain numbers. For example financial reports will also contain currency symbols and spaces.
As a work around, rather use the detail report or, if you still want to use the Monthly Time sheet report, copy the character from one of the cells and do a search and replace.
-
PPO Development Excel views (other than Data Sheet) are no longer supported as a result of formatting and other issues as described above. We will therefore not be doing any further development related to Excel reports.
Please sign in to leave a comment.