Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Exporting Staffing Profile To Excel

SOLVED
Go to solution
Highlighted
Sevilay
Collector

Exporting Staffing Profile To Excel

Hello,

i encountered an interesting thing while i was exporting the staffing profile to excel.All the lines except period total in the excel file are correct and shows the exact numbers seen at the screen.But the period total line ,i think ,is formatted as datetime and therefore figures at this line are interpreted as if they are datetime values.
Did anyone else encounter such a problem and help me?
Thanks in advance.
5 REPLIES
Sascha Mohr_1
Esteemed Contributor

Re: Exporting Staffing Profile To Excel

Hi.
I like the first one, is it October 64th?
should be related to the locale settings in PPM and Windows. Are you using PPM release 8 already?
Sevilay
Collector

Re: Exporting Staffing Profile To Excel

Hi Sascha,

yes it is October 64th :)
We are using PPM 7.5 with SP6 .

What should i do in order to set the correct settings?

Thanks for your interest.
Sascha Mohr_1
Esteemed Contributor
Solution

Re: Exporting Staffing Profile To Excel

If I remember correctly dates and numbers were not consistently rendered in the older releases. Some locations used the locale of the user some the one of the server.
You should probably open a ticket with HP support.
Sevilay
Collector

Re: Exporting Staffing Profile To Excel

Hi again,

i think we solved the problem :)
it is related to internet explorer options.
when we changed the langauge options from turkish to english(United States)[en-US] the problem is solved.

Thanks again.

Sevilay
Collector

Re: Exporting Staffing Profile To Excel

we changed the internet explorer language setting from Turkish to Engilis(United States)[en-US] and the problem is solved.

//Add this to "OnDomLoad" event