jmorelo


I need to change the DisplayBlankAs property from Vfoxpro, I need it in Interpolated, somebody knows since I can do this





Re: DisplayBlankAs property from Vfoxpro

dni


Display blank as "what" Where is the property







Re: DisplayBlankAs property from Vfoxpro

Naomi Nosonovsky

Look at SET NULLDISPLAY command in Help. There is no similar command for blank (empty) values. You may use default values for fields when you design your database.






Re: DisplayBlankAs property from Vfoxpro

hangover

Are you referring to the DisplayBlanksAs property of Excel Charts

If so, assuming that you already have an object reference to the Chart, the command would be something like:

oExcel.ActiveChart.DisplayBlanksAs = 3

Dom






Re: DisplayBlankAs property from Vfoxpro

jmorelo

You can specify how you want Microsoft Graph to handle blank or missing data. You do this through the DisplayBlanksAs

#DEFINE xlNotPlotted 1 && Default
#DEFINE xlZero 2
#DEFINE xlInterpolated 3
this.oleGraph.DisplayBlanksAs = xlZero

This would have to work, but it does not work

My object is mschart:

thisform.olecontrol

and it does not have the property DisplayBlanksAs

I not that to do

Thank for your help






Re: DisplayBlankAs property from Vfoxpro

hangover

I haven't had any experience with using MS Chart, but for what it's worth I just tried adding a Microsoft Chart object to a form.

Although the DisplayBlanksAs property is not shown in the Properties Window, it was possible to read and write to it through code.

Have you tried putting this is the INIT event of the form

THISFORM.oleControl.DisplayBlanksAs = 3






Re: DisplayBlankAs property from Vfoxpro

MarciaAkins

hangover wrote:

Although the DisplayBlanksAs property is not shown in the Properties Window, it was possible to read and write to it through code.

Have you tried putting this is the INIT event of the form

THISFORM.oleControl1.DisplayBlanksAs = 3

This line of code gives me an "Unknown Name" OLE error when I try it with MSChart.






Re: DisplayBlankAs property from Vfoxpro

dni

You may need to add new property.






Re: DisplayBlankAs property from Vfoxpro

hangover

Weird, it works for me (although I haven't a clue how). I used the Microsoft Graph Chart object added through the Controls tab in Tools ... Options (in VFP9). It has the OleClass property value 'MSGraph.Chart.8'.






Re: DisplayBlankAs property from Vfoxpro

MarciaAkins

hangover wrote:

I used the Microsoft Graph Chart object added through the Controls tab in Tools ... Options (in VFP9). It has the OleClass property value 'MSGraph.Chart.8'.

It worked for you because you were not using MSChart.ocx. The MSGraph chart object has the property in question.