General format in Time spent column in Excel export
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 (11)
-
-
reporter I mean format of cells in Excel. User said it was Number in past but now it is General.
-
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? -
reporter Yes, I remove this part in the head and it seems to be ok.
-
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.
-
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.
-
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.
-
reporter Yes, now it works! Thanks a lot. I didn't know about this settings.
-
Great, I've just also realized that this might be determined automatically. I will take of it. Thank you for your collaboration!
-
- changed status to resolved
resolve Issue
#491(follow up on Issue#468): specify locale default decimalSeparator in excel header or one set in configuration options→ <<cset ef3492c8fb03>>
-
Version 2.7.8 with automatic determining decimalSeparator is released.
- Log in to comment
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.