Export Map qustion

[wilcohsu]

Index,Text,X,Z,Z
0,AX,0,1,1
1,AX1,0,2.1,2.1
2,BX,0,5,5
3,BX1,0,0,0


I can't find Y axis value,but Z axis value is duplicate.

[Version:2.0.2546.16099]

[Narcís]

Hi wilcohsu,

How are you exporting your series? It works fine for me here exporting the maps demo data into an excel spreadsheet.

Thanks in advance.

[wilcohsu]

Hi Narcis,

I use C:\Program Files\Steema Software\TeeChart for .NET v2\Examples\DemoProject\Series\Map_Series.cs
to add editor windows-->Steema.TeeChart.Editors.SeriesEditor.ShowEditor(map1);

Then I export all series data to excel.
Below is result.

Text X Z Z
A 0 0.339 0.339
B 0 0.768 0.768
C 0 0.693 0.693
D 0 0.948 0.948
E 0 0.119 0.119
F 0 0.55 0.55
G 0 0.828 0.828
H 0 0.26 0.26
I 0 0.815 0.815
J 0 0.298 0.298
K 0 0.016 0.016
L 0 0.609 0.609

[Narcís]

Hi wilcohsu,

Thanks for the information. I could reproduce the problem here and it seems to be an editor problem as it works fine for me here using something like this:

Code: Select all

		private void Form1_Load(object sender, EventArgs e)
		{
			tChart1.Export.Data.Excel.Save(@"c:\temp\MapExcel.xls");
		}

I've added the defect (TF02012010) to our bug list to be fixed for future releases.

[wilcohsu]

Hi Narcis,

I use tChart1.Export.Data.Excel.Save(@"c:\temp\MapExcel.xls");
in "C:\Program Files\Steema Software\TeeChart for .NET v2\Examples\DemoProject\Series\Map_Series.cs"
example.


Below is the result,but I can't understand what means of every column.


A 0 0.973 0.973
B 0 0.714 0.714
C 0 0.683 0.683
D 0 0.773 0.773
E 0 0.004 0.004
F 0 0.664 0.664
G 0 0.662 0.662
H 0 0.046 0.046
I 0 0.825 0.825
J 0 0.397 0.397
K 0 0.432 0.432
L 0 0.015 0.015


Best Regard!

[Narcís]

Hi wilcohsu,

Using this code:

Code: Select all

private void Form1_Load(object sender, EventArgs e)
{
tChart1.Aspect.View3D = false;

map1.FillSampleValues();

for (int i = 0; i < map1.ValuesLists.Count; i++)
{
listBox1.Items.Add(map1.ValuesLists[i].Name);
}

tChart1.Export.Data.Excel.Save(@"c:\temp\MapExcel.xls");
}

I don't get repeated Z column and ValueLists are named: X, Y and Z. Again, with this example and using the editor's Excel exporting option I get duplicated Z column and no Y column. I'm using our in house TeeChart for .NET v2 sources for those tests.

[wilcohsu]

Hi Narcis,

Map_Series.cs Sample is use AddShape to fill value, the result
seem wrong.

private void AddShape(int[] X, int[] Y, Color AColor, string Text) {
Polygon toAdd = new Polygon(map1.Shapes, tChart1.Chart);

for(int t=X.GetLowerBound(0); t <= X.GetUpperBound(0); ++t) {
toAdd.Add(X[t],Y[t]);
}


The Result:
A 0 0.973 0.973
B 0 0.714 0.714
C 0 0.683 0.683
D 0 0.773 0.773
E 0 0.004 0.004
F 0 0.664 0.664
G 0 0.662 0.662
H 0 0.046 0.046
I 0 0.825 0.825
J 0 0.397 0.397
K 0 0.432 0.432
L 0 0.015 0.015

int i = map1.Shapes.Add(toAdd);
map1.Shapes.ParentBrush=false;
map1.Shapes.Text = Text;
map1.Shapes.Color = AColor;
map1.Shapes.Z = rnd.Next(1000) / 1000.0;
}

[wilcohsu]

Hi Narcis,

You can set marks to visible,then speed is very slow.


Best Regards.

[Narcís]

Hi wilcohsu,

Have you checked this with the TeeMaps example I told you in your other messages?