1. Tempo Avatar Tempo
  2. Prime
  3. cloudtimesheet
  4. Issues

General format in Time spent column in Excel export

Issue #491 resolved
Jakub Faltýnek created an issue

I received information from one user that excel export from Timesheet report has set General format in Time spent column. He said there was Number format in past. I don't know if is true but if it is would it be possible to move back previous format settings?

Comments (12)

  1. Andriy Zhdanov

    Hi Jakub,

    I'm not sure what you mean by general format. Could you please check Issue#482, it has added HH:MM, i.e. full date and time information. Is it what you are asking against?

    Thank you.

  2. Jakub Faltýnek reporter

    I mean format of cells in Excel. User said it was Number in past but now it is General.

  3. Andriy Zhdanov

    Well, then may be this is caused by Issue#468, could you please check it for details and let me know if it could make problem for you?

  5. Andriy Zhdanov

    Sorry, at this moment I don't know how to help. Reverting the change is not an option. And the problem is not very clear to me. Removing the header does not change anything for me in LibreOfice Calc. And also, you might see, there is Total row, with Sum by hours, so this column works as a number.

    Please let me know if you have any suggestions.

    Thank you.

  6. Jakub Faltýnek reporter

    I'm correcting my previous report of the issue. I consulted it with user and the problem isn't with the General format of the column Time spent.

    Problem is that there is error in each cell with decimal number: "Number saved as a text". These cells are not counted in Total row so than the Sum is wrong.

  7. Andriy Zhdanov

    Oh, then it looks like decimal separator is not working properly for you. Could you please check if you have Decimal Separator set in Administration - Add Ons - Timesheet Configuration? If it not set, please try to set it to what is applicable for you, I guess comma (,).

    Thank you.

  9. Andriy Zhdanov

    Great, I've just also realized that this might be determined automatically. I will take of it. Thank you for your collaboration!

  13. Log in to comment
Assignee
Type
bug
Priority
minor
Status
resolved
Component
–
Version
–
Votes
0
Watchers
2