Rows in DataSheet disappear

[Guest]

Hi,

I'm building a PP presentation in C#,
working with "VS2003" and "PowerPoint 11 Object Library".
When i double click a chart in a slide in the built presentation,
The DataSheet start at the third row,
and it is not possible to see the first and second rows in the data sheet.
Another problem is that when I have negative values in the data sheet,
Sometimes the order of the rows in the datasheet that display in the chart
are
Mixed (an row named “excellent†appears beneath a row named “very goodâ€).

thanks

 

[Steve Rindsberg]

Hi,

I'm building a PP presentation in C#,
working with "VS2003" and "PowerPoint 11 Object Library".
When i double click a chart in a slide in the built presentation,
The DataSheet start at the third row,
and it is not possible to see the first and second rows in the data sheet.

Without seeing your code it's hard to say what the problem is.

But keep in mind that the first row and column in the data sheet are reserved for
column/row names, not data. And while I don't remember offhand, I *think* that the
datasheet is effectivly a 1-based not 0-based array.

In other words:

Cell(1,1) is the cell at top left that's always blank
Cell(1,2) is the first column title
cell(2,2) is the first cell that actually contains data

Another problem is that when I have negative values in the data sheet,
Sometimes the order of the rows in the datasheet that display in the chart
are
Mixed (an row named “excellent†appears beneath a row named “very goodâ€).

The rows don't sort themselves; your code would have to sort them in the order you
want before putting the data into the cells of the data sheet.

 

[Guest]

Without seeing your code it's hard to say what the problem is.

I’m aware of the 1-based array, and I’ve being working with PP automation
for a long time.
The code is basically –

oChart.Application.DataSheet.Cells["0" + Convert.ToString(optionCounter +
2), CCReportsGlobals.ABC[abcCounter]] = freqValidPercentageStr;
and at the end of all the data insertion –
oChart.Application.Update();

The problem is that when double clicking the chart slide,
in the done presentation, the DataSheet start at a row numbered “3â€(instead
of number 1).
It looks like this:

A B C
colHeaderA colHeaderB colHeaderC
3 rowHeader3 valueA3
4 rowHeader4 valueA4

As you can see rows that have the numbers 1 and 2 (and I know these rows are
at location of rows 3 and 4 in the datasheet)
are not accessible through the DataSheet,
but these rows are shown in the chart object as bars.
Just to make thing clearer the DataSheet should looks like this according to
what is shown in the chart object –

A B C
colHeaderA colHeaderB colHeaderC
1 rowHeader1 valueA1
2 rowHeader2 valueA2
3 rowHeader3 valueA3
4 rowHeader4 valueA4

Why are rows numbered “1†and “2†not accessible?

But keep in mind that the first row and column in the data sheet are reserved for
column/row names, not data. And while I don't remember offhand, I *think* that the
datasheet is effectivly a 1-based not 0-based array.

In other words:

Cell(1,1) is the cell at top left that's always blank
Cell(1,2) is the first column title
cell(2,2) is the first cell that actually contains data


The rows don't sort themselves; your code would have to sort them in the order you
want before putting the data into the cells of the data sheet.

I checked the code in Debug mode and the insertion of the data to the chart
is in the right order,
but the chart displays them in the wrong order.
If I had access to the first 2 rows in the datasheet then it would look like
this –

A B C
colHeaderA colHeaderB colHeaderC
1 rowHeader2 valueA2
2 rowHeader1 valueA1
3 rowHeader3 valueA3
4 rowHeader4 valueA4

But because of the problem of inaccessibility to the first two rows,
I can only see this:

A B C
colHeaderA colHeaderB colHeaderC
3 rowHeader3 valueA3
4 rowHeader4 valueA4

 

[Steve Rindsberg]

Any chance you could email me an example chart that exhibits this behavior?
Dummy data's fine, of course.

steve at-sign pptools dot com

Without seeing your code it's hard to say what the problem is.

I’m aware of the 1-based array, and I’ve being working with PP automation
for a long time.
The code is basically –

oChart.Application.DataSheet.Cells["0" + Convert.ToString(optionCounter +
2), CCReportsGlobals.ABC[abcCounter]] = freqValidPercentageStr;
and at the end of all the data insertion –
oChart.Application.Update();

The problem is that when double clicking the chart slide,
in the done presentation, the DataSheet start at a row numbered “3â€(instead
of number 1).
It looks like this:

A B C
colHeaderA colHeaderB colHeaderC
3 rowHeader3 valueA3
4 rowHeader4 valueA4

As you can see rows that have the numbers 1 and 2 (and I know these rows are
at location of rows 3 and 4 in the datasheet)
are not accessible through the DataSheet,
but these rows are shown in the chart object as bars.
Just to make thing clearer the DataSheet should looks like this according to
what is shown in the chart object –

A B C
colHeaderA colHeaderB colHeaderC
1 rowHeader1 valueA1
2 rowHeader2 valueA2
3 rowHeader3 valueA3
4 rowHeader4 valueA4

Why are rows numbered “1†and “2†not accessible?

But keep in mind that the first row and column in the data sheet are reserved for
column/row names, not data. And while I don't remember offhand, I *think* that the
datasheet is effectivly a 1-based not 0-based array.

In other words:

Cell(1,1) is the cell at top left that's always blank
Cell(1,2) is the first column title
cell(2,2) is the first cell that actually contains data


The rows don't sort themselves; your code would have to sort them in the order you
want before putting the data into the cells of the data sheet.

I checked the code in Debug mode and the insertion of the data to the chart
is in the right order,
but the chart displays them in the wrong order.
If I had access to the first 2 rows in the datasheet then it would look like
this –

A B C
colHeaderA colHeaderB colHeaderC
1 rowHeader2 valueA2
2 rowHeader1 valueA1
3 rowHeader3 valueA3
4 rowHeader4 valueA4

But because of the problem of inaccessibility to the first two rows,
I can only see this:

A B C
colHeaderA colHeaderB colHeaderC
3 rowHeader3 valueA3
4 rowHeader4 valueA4

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

 

[Guest]

I’ve sent you the PP presentation, did you get it? Thanks.

Any chance you could email me an example chart that exhibits this behavior?
Dummy data's fine, of course.

steve at-sign pptools dot com

Hi,

I'm building a PP presentation in C#,
working with "VS2003" and "PowerPoint 11 Object Library".
When I double click a chart in a slide in the built presentation,
The DataSheet start at the third row,
and it is not possible to see the first and second rows in the data sheet.

Without seeing your code it's hard to say what the problem is.

I’m aware of the 1-based array, and I’ve being working with PP automation
for a long time.
The code is basically –

oChart.Application.DataSheet.Cells["0" + Convert.ToString(optionCounter +
2), CCReportsGlobals.ABC[abcCounter]] = freqValidPercentageStr;
and at the end of all the data insertion –
oChart.Application.Update();

The problem is that when double clicking the chart slide,
in the done presentation, the DataSheet start at a row numbered “3â€Â(instead
of number 1).
It looks like this:

A B C
colHeaderA colHeaderB colHeaderC
3 rowHeader3 valueA3
4 rowHeader4 valueA4

As you can see rows that have the numbers 1 and 2 (and I know these rows are
at location of rows 3 and 4 in the datasheet)
are not accessible through the DataSheet,
but these rows are shown in the chart object as bars.
Just to make thing clearer the DataSheet should looks like this according to
what is shown in the chart object –

A B C
colHeaderA colHeaderB colHeaderC
1 rowHeader1 valueA1
2 rowHeader2 valueA2
3 rowHeader3 valueA3
4 rowHeader4 valueA4

Why are rows numbered “1†and “2†not accessible?

But keep in mind that the first row and column in the data sheet are reserved for
column/row names, not data. And while I don't remember offhand, I *think* that the
datasheet is effectivly a 1-based not 0-based array.

In other words:

Cell(1,1) is the cell at top left that's always blank
Cell(1,2) is the first column title
cell(2,2) is the first cell that actually contains data

Another problem is that when I have negative values in the data sheet,
Sometimes the order of the rows in the datasheet that display in the chart
are
Mixed (an row named “excellent†appears beneath a row named “very goodâ€ÂÂ).

The rows don't sort themselves; your code would have to sort them in the order you
want before putting the data into the cells of the data sheet.

I checked the code in Debug mode and the insertion of the data to the chart
is in the right order,
but the chart displays them in the wrong order.
If I had access to the first 2 rows in the datasheet then it would look like
this –

A B C
colHeaderA colHeaderB colHeaderC
1 rowHeader2 valueA2
2 rowHeader1 valueA1
3 rowHeader3 valueA3
4 rowHeader4 valueA4

But because of the problem of inaccessibility to the first two rows,
I can only see this:

A B C
colHeaderA colHeaderB colHeaderC
3 rowHeader3 valueA3
4 rowHeader4 valueA4

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

 

[Steve Rindsberg]

I’ve sent you the PP presentation, did you get it? Thanks.

Not that I can see (and it hasn't fallen into the bin with the investment opportunities,
pharmaco-anatomical improbabilities and Department of Phisheries either.)

Give it another ry if you would ... thanks.

Any chance you could email me an example chart that exhibits this behavior?
Dummy data's fine, of course.

steve at-sign pptools dot com

:

Hi,

I'm building a PP presentation in C#,
working with "VS2003" and "PowerPoint 11 Object Library".
When I double click a chart in a slide in the built presentation,
The DataSheet start at the third row,
and it is not possible to see the first and second rows in the data sheet.

Without seeing your code it's hard to say what the problem is.

I’m aware of the 1-based array, and I’ve being working with PP automation
for a long time.
The code is basically –

oChart.Application.DataSheet.Cells["0" + Convert.ToString(optionCounter +
2), CCReportsGlobals.ABC[abcCounter]] = freqValidPercentageStr;
and at the end of all the data insertion –
oChart.Application.Update();

The problem is that when double clicking the chart slide,
in the done presentation, the DataSheet start at a row numbered “3â€Â(instead
of number 1).
It looks like this:

A B C
colHeaderA colHeaderB colHeaderC
3 rowHeader3 valueA3
4 rowHeader4 valueA4

As you can see rows that have the numbers 1 and 2 (and I know these rows are
at location of rows 3 and 4 in the datasheet)
are not accessible through the DataSheet,
but these rows are shown in the chart object as bars.
Just to make thing clearer the DataSheet should looks like this according to
what is shown in the chart object –

A B C
colHeaderA colHeaderB colHeaderC
1 rowHeader1 valueA1
2 rowHeader2 valueA2
3 rowHeader3 valueA3
4 rowHeader4 valueA4

Why are rows numbered “1†and “2†not accessible?


But keep in mind that the first row and column in the data sheet are reserved for
column/row names, not data. And while I don't remember offhand, I *think* that the
datasheet is effectivly a 1-based not 0-based array.

In other words:

Cell(1,1) is the cell at top left that's always blank
Cell(1,2) is the first column title
cell(2,2) is the first cell that actually contains data

Another problem is that when I have negative values in the data sheet,
Sometimes the order of the rows in the datasheet that display in the chart
are
Mixed (an row named “excellent†appears beneath a row named “very goodâ€ÂÂ).

The rows don't sort themselves; your code would have to sort them in the order you
want before putting the data into the cells of the data sheet.

I checked the code in Debug mode and the insertion of the data to the chart
is in the right order,
but the chart displays them in the wrong order.
If I had access to the first 2 rows in the datasheet then it would look like
this –

A B C
colHeaderA colHeaderB colHeaderC
1 rowHeader2 valueA2
2 rowHeader1 valueA1
3 rowHeader3 valueA3
4 rowHeader4 valueA4

But because of the problem of inaccessibility to the first two rows,
I can only see this:

A B C
colHeaderA colHeaderB colHeaderC
3 rowHeader3 valueA3
4 rowHeader4 valueA4



-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

 

[Guest]

I’ve send it again.

I’ve sent you the PP presentation, did you get it? Thanks.

Not that I can see (and it hasn't fallen into the bin with the investment opportunities,
pharmaco-anatomical improbabilities and Department of Phisheries either.)

Give it another ry if you would ... thanks.

Any chance you could email me an example chart that exhibits this behavior?
Dummy data's fine, of course.

steve at-sign pptools dot com

:

Hi,

I'm building a PP presentation in C#,
working with "VS2003" and "PowerPoint 11 Object Library".
When I double click a chart in a slide in the built presentation,
The DataSheet start at the third row,
and it is not possible to see the first and second rows in the data sheet.

Without seeing your code it's hard to say what the problem is.

I’m aware of the 1-based array, and I’ve being working with PP automation
for a long time.
The code is basically –

oChart.Application.DataSheet.Cells["0" + Convert.ToString(optionCounter +
2), CCReportsGlobals.ABC[abcCounter]] = freqValidPercentageStr;
and at the end of all the data insertion –
oChart.Application.Update();

The problem is that when double clicking the chart slide,
in the done presentation, the DataSheet start at a row numbered “3â€ÂÂ(instead
of number 1).
It looks like this:

A B C
colHeaderA colHeaderB colHeaderC
3 rowHeader3 valueA3
4 rowHeader4 valueA4

As you can see rows that have the numbers 1 and 2 (and I know these rows are
at location of rows 3 and 4 in the datasheet)
are not accessible through the DataSheet,
but these rows are shown in the chart object as bars.
Just to make thing clearer the DataSheet should looks like this according to
what is shown in the chart object –

A B C
colHeaderA colHeaderB colHeaderC
1 rowHeader1 valueA1
2 rowHeader2 valueA2
3 rowHeader3 valueA3
4 rowHeader4 valueA4

Why are rows numbered “1†and “2†not accessible?


But keep in mind that the first row and column in the data sheet are reserved for
column/row names, not data. And while I don't remember offhand, I *think* that the
datasheet is effectivly a 1-based not 0-based array.

In other words:

Cell(1,1) is the cell at top left that's always blank
Cell(1,2) is the first column title
cell(2,2) is the first cell that actually contains data

Another problem is that when I have negative values in the data sheet,
Sometimes the order of the rows in the datasheet that display in the chart
are
Mixed (an row named “excellent†appears beneath a row named “very goodâ€ÂÂÂ).

The rows don't sort themselves; your code would have to sort them in the order you
want before putting the data into the cells of the data sheet.

I checked the code in Debug mode and the insertion of the data to the chart
is in the right order,
but the chart displays them in the wrong order.
If I had access to the first 2 rows in the datasheet then it would look like
this –

A B C
colHeaderA colHeaderB colHeaderC
1 rowHeader2 valueA2
2 rowHeader1 valueA1
3 rowHeader3 valueA3
4 rowHeader4 valueA4

But because of the problem of inaccessibility to the first two rows,
I can only see this:

A B C
colHeaderA colHeaderB colHeaderC
3 rowHeader3 valueA3
4 rowHeader4 valueA4



-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================





-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

 

[Steve Rindsberg]

I’ve send it again.

Still no luck. You're sending it to steve at-sign pptools dot com (making the obvious
conversion to an email address) and not just hitting reply by email, right?

I’ve sent you the PP presentation, did you get it? Thanks.

Not that I can see (and it hasn't fallen into the bin with the investment opportunities,
pharmaco-anatomical improbabilities and Department of Phisheries either.)

Give it another ry if you would ... thanks.

:


Any chance you could email me an example chart that exhibits this behavior?
Dummy data's fine, of course.

steve at-sign pptools dot com

:

Hi,

I'm building a PP presentation in C#,
working with "VS2003" and "PowerPoint 11 Object Library".
When I double click a chart in a slide in the built presentation,
The DataSheet start at the third row,
and it is not possible to see the first and second rows in the data sheet.

Without seeing your code it's hard to say what the problem is.

I’m aware of the 1-based array, and I’ve being working with PP automation
for a long time.
The code is basically –

oChart.Application.DataSheet.Cells["0" + Convert.ToString(optionCounter +
2), CCReportsGlobals.ABC[abcCounter]] = freqValidPercentageStr;
and at the end of all the data insertion –
oChart.Application.Update();

The problem is that when double clicking the chart slide,
in the done presentation, the DataSheet start at a row numbered “3â€ÂÂ(instead
of number 1).
It looks like this:

A B C
colHeaderA colHeaderB colHeaderC
3 rowHeader3 valueA3
4 rowHeader4 valueA4

As you can see rows that have the numbers 1 and 2 (and I know these rows are
at location of rows 3 and 4 in the datasheet)
are not accessible through the DataSheet,
but these rows are shown in the chart object as bars.
Just to make thing clearer the DataSheet should looks like this according to
what is shown in the chart object –

A B C
colHeaderA colHeaderB colHeaderC
1 rowHeader1 valueA1
2 rowHeader2 valueA2
3 rowHeader3 valueA3
4 rowHeader4 valueA4

Why are rows numbered “1†and “2†not accessible?


But keep in mind that the first row and column in the data sheet are reserved for
column/row names, not data. And while I don't remember offhand, I *think* that the
datasheet is effectivly a 1-based not 0-based array.

In other words:

Cell(1,1) is the cell at top left that's always blank
Cell(1,2) is the first column title
cell(2,2) is the first cell that actually contains data

Another problem is that when I have negative values in the data sheet,
Sometimes the order of the rows in the datasheet that display in the chart
are
Mixed (an row named

“excellent†appears beneath a
row

 

[Guest]

I've tried to send it to steve pptools dot com, but my smtp won't send it as
the address is wrong. Thanks

I’ve send it again.

Still no luck. You're sending it to steve at-sign pptools dot com (making the obvious
conversion to an email address) and not just hitting reply by email, right?

I’ve sent you the PP presentation, did you get it? Thanks.

Not that I can see (and it hasn't fallen into the bin with the investment opportunities,
pharmaco-anatomical improbabilities and Department of Phisheries either.)

Give it another ry if you would ... thanks.


:


Any chance you could email me an example chart that exhibits this behavior?
Dummy data's fine, of course.

steve at-sign pptools dot com

:

Hi,

I'm building a PP presentation in C#,
working with "VS2003" and "PowerPoint 11 Object Library".
When I double click a chart in a slide in the built presentation,
The DataSheet start at the third row,
and it is not possible to see the first and second rows in the data sheet.

Without seeing your code it's hard to say what the problem is.

I’m aware of the 1-based array, and I’ve being working with PP automation
for a long time.
The code is basically –

oChart.Application.DataSheet.Cells["0" + Convert.ToString(optionCounter +
2), CCReportsGlobals.ABC[abcCounter]] = freqValidPercentageStr;
and at the end of all the data insertion –
oChart.Application.Update();

The problem is that when double clicking the chart slide,
in the done presentation, the DataSheet start at a row numbered “3â€ÂÂÂ(instead
of number 1).
It looks like this:

A B C
colHeaderA colHeaderB colHeaderC
3 rowHeader3 valueA3
4 rowHeader4 valueA4

As you can see rows that have the numbers 1 and 2 (and I know these rows are
at location of rows 3 and 4 in the datasheet)
are not accessible through the DataSheet,
but these rows are shown in the chart object as bars.
Just to make thing clearer the DataSheet should looks like this according to
what is shown in the chart object –

A B C
colHeaderA colHeaderB colHeaderC
1 rowHeader1 valueA1
2 rowHeader2 valueA2
3 rowHeader3 valueA3
4 rowHeader4 valueA4

Why are rows numbered “1†and “2†not accessible?


But keep in mind that the first row and column in the data sheet are reserved for
column/row names, not data. And while I don't remember offhand, I *think* that the
datasheet is effectivly a 1-based not 0-based array.

In other words:

Cell(1,1) is the cell at top left that's always blank
Cell(1,2) is the first column title
cell(2,2) is the first cell that actually contains data

Another problem is that when I have negative values in the data sheet,
Sometimes the order of the rows in the datasheet that display in the chart
are
Mixed (an row named

“excellent†appears beneath a
row
-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

 

[Steve Rindsberg]

I've tried to send it to steve pptools dot com, but my smtp won't send it as
the address is wrong. Thanks

The address is deliberately obfuscated to prevent spam.
substitute @ for at-sign and . for dot and remove the spaces.

I’ve send it again.

Still no luck. You're sending it to steve at-sign pptools dot com (making the obvious
conversion to an email address) and not just hitting reply by email, right?

:

I’ve sent you the PP presentation, did you get it? Thanks.

Not that I can see (and it hasn't fallen into the bin with the investment opportunities,
pharmaco-anatomical improbabilities and Department of Phisheries either.)

Give it another ry if you would ... thanks.


:


Any chance you could email me an example chart that exhibits this behavior?
Dummy data's fine, of course.

steve at-sign pptools dot com

:

Hi,

I'm building a PP presentation in C#,
working with "VS2003" and "PowerPoint 11 Object Library".
When I double click a chart in a slide in the built presentation,
The DataSheet start at the third row,
and it is not possible to see the first and second rows in the data sheet.

Without seeing your code it's hard to say what the problem is.

I’m aware of the 1-based array, and I’ve being working with PP automation
for a long time.
The code is basically –

oChart.Application.DataSheet.Cells["0" + Convert.ToString(optionCounter +
2), CCReportsGlobals.ABC[abcCounter]] = freqValidPercentageStr;
and at the end of all the data insertion –
oChart.Application.Update();

The problem is that when double clicking the chart slide,
in the done presentation, the DataSheet start at a row numbered “3â€ÂÂÂ(instead
of number 1).
It looks like this:

A B C
colHeaderA colHeaderB colHeaderC
3 rowHeader3 valueA3
4 rowHeader4 valueA4

As you can see rows that have the numbers 1 and 2 (and I know these rows are
at location of rows 3 and 4 in the datasheet)
are not accessible through the DataSheet,
but these rows are shown in the chart object as bars.
Just to make thing clearer the DataSheet should looks like this according to
what is shown in the chart object –

A B C
colHeaderA colHeaderB colHeaderC
1 rowHeader1 valueA1
2 rowHeader2 valueA2
3 rowHeader3 valueA3
4 rowHeader4 valueA4

Why are rows numbered “1†and

“2†not accessible?

But keep in mind that the first row and column in the data sheet are reserved for
column/row names, not data. And while I don't remember offhand, I *think* that the
datasheet is effectivly a 1-based not 0-based array.

In other words:

Cell(1,1) is the cell at top left that's always blank
Cell(1,2) is the first column title
cell(2,2) is the first cell that actually contains data

Another problem is that when I have negative values in the data sheet,
Sometimes the order of the rows in the datasheet that display in the chart
are
Mixed (an row named

“excellent†appears beneath a
row

named “very goodâ€ÂÂÂÂ).

The rows don't sort themselves; your code would have to sort them in the order you
want before putting the data into the cells of the data sheet.

I checked the code in Debug mode and the insertion of the data to the chart
is in the right order,
but the chart displays them in the wrong order.
If I had access to the first 2 rows in the datasheet then it would look like
this –

A B C
colHeaderA colHeaderB colHeaderC
1 rowHeader2 valueA2
2 rowHeader1 valueA1
3 rowHeader3 valueA3
4 rowHeader4 valueA4

But because of the problem of inaccessibility to the first two rows,
I can only see this:

A B C
colHeaderA colHeaderB colHeaderC
3 rowHeader3 valueA3
4 rowHeader4 valueA4



-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================





-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================





-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

 

[Guest]

I tried again. This time it worked.

I've tried to send it to steve pptools dot com, but my smtp won't send it as
the address is wrong. Thanks

The address is deliberately obfuscated to prevent spam.
substitute @ for at-sign and . for dot and remove the spaces.

I’ve send it again.

Still no luck. You're sending it to steve at-sign pptools dot com (making the obvious
conversion to an email address) and not just hitting reply by email, right?



:

I’ve sent you the PP presentation, did you get it? Thanks.

Not that I can see (and it hasn't fallen into the bin with the investment opportunities,
pharmaco-anatomical improbabilities and Department of Phisheries either.)

Give it another ry if you would ... thanks.


:


Any chance you could email me an example chart that exhibits this behavior?
Dummy data's fine, of course.

steve at-sign pptools dot com

:

Hi,

I'm building a PP presentation in C#,
working with "VS2003" and "PowerPoint 11 Object Library".
When I double click a chart in a slide in the built presentation,
The DataSheet start at the third row,
and it is not possible to see the first and second rows in the data sheet.

Without seeing your code it's hard to say what the problem is.

I’m aware of the 1-based array, and I’ve being
working with PP automation
for a long time.
The code is basically –

oChart.Application.DataSheet.Cells["0" + Convert.ToString(optionCounter +
2), CCReportsGlobals.ABC[abcCounter]] = freqValidPercentageStr;
and at the end of all the data insertion –
oChart.Application.Update();

The problem is that when double clicking the chart slide,
in the done presentation, the DataSheet start at a row numbered
“3â€ÂÂÂÂ(instead
of number 1).
It looks like this:

A B C
colHeaderA colHeaderB colHeaderC
3 rowHeader3 valueA3
4 rowHeader4 valueA4

As you can see rows that have the numbers 1 and 2 (and I know these rows are
at location of rows 3 and 4 in the datasheet)
are not accessible through the DataSheet,
but these rows are shown in the chart object as bars.
Just to make thing clearer the DataSheet should looks like this according to
what is shown in the chart object –

A B C
colHeaderA colHeaderB colHeaderC
1 rowHeader1 valueA1
2 rowHeader2 valueA2
3 rowHeader3 valueA3
4 rowHeader4 valueA4

Why are rows numbered “1†and
“2†not accessible?


But keep in mind that the first row and column in the data sheet are reserved for
column/row names, not data. And while I don't remember offhand, I *think* that
the
datasheet is effectivly a 1-based not 0-based array.

In other words:

Cell(1,1) is the cell at top left that's always blank
Cell(1,2) is the first column title
cell(2,2) is the first cell that actually contains data

Another problem is that when I have negative values in the data sheet,
Sometimes the order of the rows in the datasheet that display in the chart
are
Mixed (an row named
“excellent†appears beneath a
row
named “very goodâ€ÂÂÂÂÂ).

The rows don't sort themselves; your code would have to sort them in the order you
want before putting the data into the cells of the data sheet.

I checked the code in Debug mode and the insertion of the data to the chart
is in the right order,
but the chart displays them in the wrong order.
If I had access to the first 2 rows in the datasheet then it would look like
this –

A B C
colHeaderA colHeaderB colHeaderC
1 rowHeader2 valueA2
2 rowHeader1 valueA1
3 rowHeader3 valueA3
4 rowHeader4 valueA4

But because of the problem of inaccessibility to the first two rows,
I can only see this:

A B C
colHeaderA colHeaderB colHeaderC
3 rowHeader3 valueA3
4 rowHeader4 valueA4



-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================





-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================





-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================





-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

 

[Steve Rindsberg]

I tried again. This time it worked.

Yes, thanks. But I see all rows here.
I just had to use the scrollbar to make them visible:


1/8/2006 - 10/8/2006
1
2 ????? ????? 36.36%
3 ????? ??? 54.55%
4 ????? ?? ???
5 ????? ???? ?? ??? -9.09%

Row 1 is blank, contains no row header data
Row 4 has a row header but no data
The graph looks pretty normal, given the data in the sheet.

I've tried to send it to steve pptools dot com, but my smtp won't send it as
the address is wrong. Thanks

The address is deliberately obfuscated to prevent spam.
substitute @ for at-sign and . for dot and remove the spaces.

:

I’ve send it again.

Still no luck. You're sending it to steve at-sign pptools dot com (making the obvious
conversion to an email address) and not just hitting reply by email, right?



:

I’ve sent you the PP presentation, did you get it? Thanks.

Not that I can see (and it hasn't fallen into the bin with the investment opportunities,
pharmaco-anatomical improbabilities and Department of Phisheries either.)

Give it another ry if you would ... thanks.


:


Any chance you could email me an example chart that exhibits this behavior?
Dummy data's fine, of course.

steve at-sign pptools dot com

:

Hi,

I'm building a PP presentation in C#,
working with "VS2003" and "PowerPoint 11 Object Library".
When I double click a chart in a slide in the built presentation,
The DataSheet start at the third row,
and it is not possible to see the first and second rows in the data sheet.

Without seeing your code it's hard to say what the problem is.

I’m aware of the 1-based array, and I’ve being
working with PP automation
for a long time.
The code is basically –

oChart.Application.DataSheet.Cells["0" + Convert.ToString(optionCounter +
2), CCReportsGlobals.ABC[abcCounter]] = freqValidPercentageStr;
and at the end of all the data insertion –
oChart.Application.Update();

The problem is that when double clicking the chart slide,
in the done presentation, the DataSheet start at a row numbered
“3â€ÂÂÂÂ(instead
of number 1).
It looks like this:

A B C
colHeaderA colHeaderB colHeaderC
3 rowHeader3 valueA3
4 rowHeader4 valueA4

As you can see rows that have the numbers 1 and 2 (and I know these rows are
at location of rows 3 and 4 in the datasheet)
are not accessible through the DataSheet,
but these rows are shown in the chart object as bars.
Just to make thing clearer the DataSheet should looks like this according to
what is shown in the chart object –

A B C
colHeaderA colHeaderB colHeaderC
1 rowHeader1 valueA1
2 rowHeader2 valueA2
3 rowHeader3 valueA3
4 rowHeader4 valueA4

Why are rows numbered “1†and
“2†not accessible?


But keep in mind that the first row and column in the data sheet are reserved for
column/row names, not data. And while I don't remember offhand, I *think* that
the
datasheet is effectivly a 1-based not 0-based array.

In other words:

Cell(1,1) is the cell at top left that's always blank
Cell(1,2) is the first column title
cell(2,2) is the first cell that actually contains data

Another problem is that when I have negative values in the data sheet,
Sometimes the order of the rows in the datasheet that display in the chart
are
Mixed (an row named
“excellent†appears beneath a
row
named “very goodâ€ÂÂÂÂÂ).

The rows don't sort themselves; your code would have to sort them in the order you
want before putting the data into the cells of the data sheet.

I checked the code in Debug mode and the insertion of the data to the chart
is in the right order,
but the chart displays them in the wrong order.
If I had access to the first 2 rows in the datasheet then it would look like
this –

A B C
colHeaderA colHeaderB colHeaderC
1 rowHeader2 valueA2
2 rowHeader1 valueA1
3 rowHeader3 valueA3
4 rowHeader4 valueA4

But because of the problem of inaccessibility to the first two rows,
I can only see this:

A B C
colHeaderA colHeaderB colHeaderC
3 rowHeader3 valueA3
4 rowHeader4 valueA4



-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================





-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================





-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================





-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

 

[Guest]

It maybe got write when I copied and pasted it.
But for the second problem – do you see that “36.36%†above “54.55%†in the
data sheet,
but in the chart “54.55%†is above?

I tried again. This time it worked.

Yes, thanks. But I see all rows here.
I just had to use the scrollbar to make them visible:


1/8/2006 - 10/8/2006
1
2 ????? ????? 36.36%
3 ????? ??? 54.55%
4 ????? ?? ???
5 ????? ???? ?? ??? -9.09%

Row 1 is blank, contains no row header data
Row 4 has a row header but no data
The graph looks pretty normal, given the data in the sheet.

I've tried to send it to steve pptools dot com, but my smtp won't send it as
the address is wrong. Thanks

The address is deliberately obfuscated to prevent spam.
substitute @ for at-sign and . for dot and remove the spaces.


:

I’ve send it again.

Still no luck. You're sending it to steve at-sign pptools dot com (making the obvious
conversion to an email address) and not just hitting reply by email, right?



:

I’ve sent you the PP presentation, did you get it? Thanks.

Not that I can see (and it hasn't fallen into the bin with the investment opportunities,
pharmaco-anatomical improbabilities and Department of Phisheries either.)

Give it another ry if you would ... thanks.


:


Any chance you could email me an example chart that exhibits this behavior?
Dummy data's fine, of course.

steve at-sign pptools dot com

:

Hi,

I'm building a PP presentation in C#,
working with "VS2003" and "PowerPoint 11 Object Library".
When I double click a chart in a slide in the built presentation,
The DataSheet start at the third row,
and it is not possible to see the first and second rows in the data sheet.

Without seeing your code it's hard to say what the problem is.

I’m aware of the 1-based array, and I’ve being
working with PP automation
for a long time.
The code is basically –

oChart.Application.DataSheet.Cells["0" + Convert.ToString(optionCounter +
2), CCReportsGlobals.ABC[abcCounter]] = freqValidPercentageStr;
and at the end of all the data insertion –
oChart.Application.Update();

The problem is that when double clicking the chart slide,
in the done presentation, the DataSheet start at a row numbered
“3â€ÂÂÂÂÂ(instead
of number 1).
It looks like this:

A B C
colHeaderA colHeaderB colHeaderC
3 rowHeader3 valueA3
4 rowHeader4 valueA4

As you can see rows that have the numbers 1 and 2 (and I know these rows are
at location of rows 3 and 4 in the datasheet)
are not accessible through the DataSheet,
but these rows are shown in the chart object as bars.
Just to make thing clearer the DataSheet should looks like this according to
what is shown in the chart object –

A B C
colHeaderA colHeaderB colHeaderC
1 rowHeader1 valueA1
2 rowHeader2 valueA2
3 rowHeader3 valueA3
4 rowHeader4 valueA4

Why are rows numbered “1†and
“2†not accessible?


But keep in mind that the first row and column in the data sheet are reserved for
column/row names, not data. And while I don't remember offhand, I *think* that
the
datasheet is effectivly a 1-based not 0-based array.

In other words:

Cell(1,1) is the cell at top left that's always blank
Cell(1,2) is the first column title
cell(2,2) is the first cell that actually contains data

Another problem is that when I have negative values in the data sheet,
Sometimes the order of the rows in the datasheet that display in the chart
are
Mixed (an row named
“excellent†appears beneath a
row
named ÃÆ’¢â‚¬Å“very goodÃÆ’¢â‚¬ÂÂÂÂÂÂ).

The rows don't sort themselves; your code would have to sort them in the order you
want before putting the data into the cells of the data sheet.

I checked the code in Debug mode and the insertion of the data to the chart
is in the right order,
but the chart displays them in the wrong order.
If I had access to the first 2 rows in the datasheet then it would look like
this –

A B C
colHeaderA colHeaderB colHeaderC
1 rowHeader2 valueA2
2 rowHeader1 valueA1
3 rowHeader3 valueA3
4 rowHeader4 valueA4

But because of the problem of inaccessibility to the first two rows,
I can only see this:

A B C
colHeaderA colHeaderB colHeaderC
3 rowHeader3 valueA3
4 rowHeader4 valueA4



-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================





-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================





-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================





-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================





-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

 

[Steve Rindsberg]

It maybe got write when I copied and pasted it.
But for the second problem – do you see that “36.36%†above “54.55%†in the
data sheet,
but in the chart “54.55%†is above?

We have a problem here. The chart shows Hebrew row titles when I view it in PPT (should it?),
but the same Hebrew (again, Im assuming that) gets converted to gibberish when I see it here
in the newsgroup, so I can't tell what you're seeing. Arrghh.

Is it possible to create an example using a roman font and characters? That might make it
easier for us to see the same thing.
I’ve sent you
the PP presentation, did you get it? Thanks.

Not that I can see (and it hasn't fallen into the bin with the investment opportunities,
pharmaco-anatomical improbabilities and Department of Phisheries either.)

Give it another ry if you would ... thanks.


:


Any chance you could email me an example chart that exhibits this behavior?
Dummy data's fine, of course.

steve at-sign pptools dot com

:

Iââ‚Ã
ƒÆ’‚¬Ã¢â€žÂ¢m
aware of the 1-based array, and
Iââ‚Ã
ƒÆ’‚¬Ã¢â€žÂ¢ve
being

ââ‚Ã
ƒâ€šÃ‚¬ÃƒÂ¢Ã¢â€šÂ¬Ã…â€Åâ€
œ

oChart.Application.DataSheet.Cells["0" + Convert.ToString(optionCounter +
2), CCReportsGlobals.ABC[abcCounter]] = freqValidPercentageStr;
and at the end of all the data insertion

ââ‚Ã
ƒâ€šÃ‚¬ÃƒÂ¢Ã¢â€šÂ¬Ã…â€Åâ€
œ ââ‚Ã
ƒâ€šÃ‚¬Ãƒâ€¦Ã¢â‚¬Å“3ÃÆâ
€™Ãƒâ€šÃ‚¢ÃƒÂ¢Ã¢â‚¬Å¡Ã‚ÂÂ
¬ÃƒÆ’‚ÂÂÂÂ(instead ââ‚Ã
ƒâ€šÃ‚¬ÃƒÂ¢Ã¢â€šÂ¬Ã…â€Åâ€
œ

ââ‚Ã
ƒâ€šÃ‚¬Ãƒâ€¦Ã¢â‚¬Å“1ÃÆâ
€™Ãƒâ€šÃ‚¢ÃƒÂ¢Ã¢â‚¬Å¡Ã‚ÂÂ
¬ÃƒÆ’‚ andââ‚Ã
ƒâ€šÃ‚¬Ãƒâ€¦Ã¢â‚¬Å“2ÃÆâ
€™Ãƒâ€šÃ‚¢ÃƒÂ¢Ã¢â‚¬Å¡Ã‚ÂÂ
¬ÃƒÆ’‚ not accessible?’¢ÃÃâ€Å
¡Ãƒâ€šÃ‚¢ÃƒÆ’¢â‚¬Å¡ÃâÃ
¢â€šÂ¬Ã…¡Ãƒâ€šÃ‚¬ÃƒÆ’…ÃÃ
ƒâ€šÃ‚¢ÃƒÂ¢Ã¢â‚¬Å¡Ã‚¬Ã…“excellentÃÆââ‚
¬â„¢ÃƒÆ’â€
’¢ÃÃâ€Å
¡Ãƒâ€šÃ‚¢ÃƒÆ’¢â‚¬Å¡ÃâÃ
¢â€šÂ¬Ã…¡Ãƒâ€šÃ‚¬ÃƒÆ’‚ÃÃ
ƒÂ¢Ã¢â€šÂ¬Ã…¡Ãƒâ€šÃ‚ appears beneath a

 

[Guest]

Do you see that 36.36% is above 54.55% in the
data sheet, but in the chart 54.55% is above.

It maybe got write when I copied and pasted it.
But for the second problem – do you see that “36.36%†above “54.55%†in the
data sheet,
but in the chart “54.55%†is above?

We have a problem here. The chart shows Hebrew row titles when I view it in PPT (should it?),
but the same Hebrew (again, Im assuming that) gets converted to gibberish when I see it here
in the newsgroup, so I can't tell what you're seeing. Arrghh.

Is it possible to create an example using a roman font and characters? That might make it
easier for us to see the same thing.
I’ve sent you
the PP presentation, did you get it? Thanks.

Not that I can see (and it hasn't fallen into the bin with the investment opportunities,
pharmaco-anatomical improbabilities and Department of Phisheries either.)

Give it another ry if you would ... thanks.


:


Any chance you could email me an example chart that exhibits this behavior?
Dummy data's fine, of course.

steve at-sign pptools dot com

:

Iââ‚Ã
ƒÆ’‚¬Ã¢â€žÂ¢m
aware of the 1-based array, and
Iââ‚Ã
ƒÆ’‚¬Ã¢â€žÂ¢ve
beingââ‚Ã
ƒâ€šÃ‚¬ÃƒÂ¢Ã¢â€šÂ¬Ã…â€Åâ€
Å“

oChart.Application.DataSheet.Cells["0" + Convert.ToString(optionCounter +
2), CCReportsGlobals.ABC[abcCounter]] = freqValidPercentageStr;
and at the end of all the data insertion

ââ‚Ã
ƒâ€šÃ‚¬ÃƒÂ¢Ã¢â€šÂ¬Ã…â€Åâ€
œÃƒÆ’ƒÆ’¢â‚Ã
ƒâ€šÃ‚¬Ãƒâ€¦Ã¢â‚¬Å“3ÃÆâ
€™Ãƒâ€šÃ‚¢ÃƒÂ¢Ã¢â‚¬Å¡Ã‚ÂÂ
¬ÃƒÆ’‚ÂÂÂÂÂ(insteadÃÆ’¢â‚Ã
ƒâ€šÃ‚¬ÃƒÂ¢Ã¢â€šÂ¬Ã…â€Åâ€
œÃƒÆ’ƒÆ’¢â‚Ã
ƒâ€šÃ‚¬Ãƒâ€¦Ã¢â‚¬Å“1ÃÆâ
€™Ãƒâ€šÃ‚¢ÃƒÂ¢Ã¢â‚¬Å¡Ã‚ÂÂ
¬ÃƒÆ’‚ andââ‚Ã
ƒâ€šÃ‚¬Ãƒâ€¦Ã¢â‚¬Å“2ÃÆâ
€™Ãƒâ€šÃ‚¢ÃƒÂ¢Ã¢â‚¬Å¡Ã‚ÂÂ
¬ÃƒÆ’‚ not accessible?’¢ÃÃâ€Å
¡Ãƒâ€šÃ‚¢ÃƒÆ’¢â‚¬Å¡ÃâÃ
¢â€šÂ¬Ã…¡Ãƒâ€šÃ‚¬ÃƒÆ’…ÃÃ
ƒâ€šÃ‚¢ÃƒÂ¢Ã¢â‚¬Å¡Ã‚¬Ã…“excellentÃÆââ‚
¬â„¢ÃƒÆ’â€
’¢ÃÃâ€Å
¡Ãƒâ€šÃ‚¢ÃƒÆ’¢â‚¬Å¡ÃâÃ
¢â€šÂ¬Ã…¡Ãƒâ€šÃ‚¬ÃƒÆ’‚ÃÃ
ƒÂ¢Ã¢â€šÂ¬Ã…¡Ãƒâ€šÃ‚ appears beneath a’¢ÃÃâ€Å
¡Ãƒâ€šÃ‚¢ÃƒÆ’¢â‚¬Å¡ÃâÃ
¢â€šÂ¬Ã…¡Ãƒâ€šÃ‚¬ÃƒÆ’…ÃÃ
ƒâ€šÃ‚¢ÃƒÂ¢Ã¢â‚¬Å¡Ã‚¬Ã…“very
goodÃÃâ€
’¢ÃÃâ€Å
¡Ãƒâ€šÃ‚¢ÃƒÆ’¢â‚¬Å¡ÃâÃ
¢â€šÂ¬Ã…¡Ãƒâ€šÃ‚¬ÃƒÆ’‚ÃÃ
ƒÂ¢Ã¢â€šÂ¬Ã…¡Ãƒâ€šÃ‚ÂÂÂ).ÃÆ’¢â‚Ã
ƒâ€šÃ‚¬ÃƒÂ¢Ã¢â€šÂ¬Ã…â€Åâ€
Å“
-----------------------------------------