DisplayBlankAs property from Vfoxpro

jmorelo

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

dni


Display blank as "what" Where is the property

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.

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

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

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

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.

dni

You may need to add new property.

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'.

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.