Gephi forums

Re: Data export problem

2010-05-29T02:07:48+01:00

Ahhhhh.....OK!!!
And than InDegree + OutDegree= Degree!!!!! Cool!

Excel: But when I change to numbers.....I get.....

.....mhhhhhh ?????

Greetings,
D-lam

Statistics:Posted by d-lam — 29 May 2010 02:07

Re: Data export problem

2010-05-29T00:17:51+01:00

Is it a problem by Gephi or Excel???

That is Excel problem. Excel has a data format for each cell, and find out its a data though it's a number.
If you right click on your cells, select "cell format" and force it to "Number".

And how can I get the degree values to Excel???

Run the In/Out Degree statistics to have in and out degree columns.

Statistics:Posted by mbastian — 29 May 2010 00:17

Data export problem

2010-05-29T00:03:35+01:00

Hi,

when I export the Data-column from Gephi to Excel (Ctrl+A & Ctrl+c & Ctrl+v)......Excel can't handle the values!

I have this Data-column in Gephi....

...and I get that Excel-chart (check closeness)....

Excel shows me dates.....so if closeness is 1.8....Excel shows me 1.august!
Is it a problem by Gephi or Excel???
Maybe because the . (point) between 1 & 8....Excels needs a , (comma)?????
Maybe somebody know how to fix (in Excel)?

And how can I get the degree values to Excel??? Or is there only the screenshot???

Thanks & Greetings,
D-lam

Statistics:Posted by d-lam — 29 May 2010 00:03