Page 1 of 1
Export Map qustion
Posted: Thu Jan 04, 2007 1:56 am
by 9643419
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]
Posted: Thu Jan 04, 2007 8:51 am
by narcis
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.
Posted: Fri Jan 05, 2007 1:32 am
by 9643419
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
Posted: Fri Jan 05, 2007 4:42 pm
by narcis
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.
Posted: Wed Jan 10, 2007 1:09 am
by 9643419
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!
Posted: Wed Jan 10, 2007 9:04 am
by narcis
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.
Posted: Wed Jan 10, 2007 11:28 pm
by 9643419
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;
}
Posted: Thu Jan 11, 2007 6:43 am
by 9643419
Hi Narcis,
You can set marks to visible,then speed is very slow.
Best Regards.
Posted: Thu Jan 11, 2007 9:44 am
by narcis
Hi wilcohsu,
Have you checked this with the TeeMaps example I told you in your other messages?