Error Msg: not a valid floating point value.

mikall · Post by **mikall** » Thu Feb 02, 2006 5:43 am

I have an ActiveX TeeChart with 21 custom axis. When I'm in the TeeChart editor in VB 6 and select some of the custom axis from the list of axis on the TeeChart editor "Axis" tab, I get a VB6 error dialog box saying:

"000,100" is not a valid floating point value.

or

'0.10%' is not a valid floating point value.

or

'0%' is not a valid floating point value.

or

'0.00%' is not a valid floating point value

This occurs just by selecting an axis listing in the list box

I recently have installed version 7.0.0.6

Regards,

Michael Rekoff

I should also add that these error messages only appear when the Axis / Scales tab is active.

Narcís · Post by **Narcís** » Thu Feb 02, 2006 12:12 pm

Hi Michael,

Could you please post an example project we can run "as-is" or the .tee file corresponding to that chart so that we can reproduce the problem here?

You can post your files at [url]news://www.steema.net/steema.public.attachments[/url] newsgroup.

Thanks in advance.

mikall · Post by **mikall** » Thu Feb 02, 2006 11:06 pm

I have posted the sample files to the newsgroup you mentioned. I have attached a ".tee" file of the chart with the custom axis problem along with an ".rar" archive that contains a small VB6 project that includes the same TeeChart. There is no code in the project just the TeeChart on a form.

As I mentioned before, the VB6 Error dialog box displays when in the TeeChart editor with the Axis / Scales tab selected. In the list of axis, selecting axis "Custom 9", "Custom 13", "Custom15", "Custom16" or "Custom 17" produces the error message.

In further investigation, I believe the problem is related to the "Values Format" under Axis / Labels / Format. It appears that any format string which contains a "%" produces this error. Additionally, axis "Custom 9" produces the error but does not contain a "%"

Regards,

Michael Rekoff

Narcís · Post by **Narcís** » Mon Feb 06, 2006 10:43 am

Hi Michael,

I solved that problem changing the decimal separator in custom 9 axis from "." to ",". I've also changed the decimal format of the custom 13 axis and the problems were gone.

You may want to check which decimal separator do you use at your machine Regional Settings usin:

Code: Select all

separator = Tchart1.Environment.DecimalSeparator

help:

Returns the System Decimal Separator according to the Locale as setup in Windows regional settings. This property can be useful when used in conjunction with the ISeriesTextSource component and importing text file data in differing locale environments.

mikall · Post by **mikall** » Mon Feb 06, 2006 12:28 pm

I think the problem is still there or perhaps there is still something I don't understand.

My decimal separator is set to use "."

Below are the Value Formats intended to be used.

Custom 9 #00,0000
Custom 13 #,##0.00%
Custom15 #,##0%
Custom16 #,##0.00%
Custom 17 #,##0%

So, for example, in Custom axis 13 the Numeric Format dialog box on the Labels/Format tab in the TeeChart editor shows "Number" with "Decimals: 2 Fixed", "Fixed: 1" and "Percent" selected. This setting produces the VB6 error Dialog box with the message "'0.01%' is not a valid floating point value." (note: this error only displays when the "Axis / Scales" tabs are selected). When you changed the decimal separator, what did the format string look like afterwards?

Regards,

Michael Rekoff

Narcís · Post by **Narcís** » Tue Feb 14, 2006 9:39 am

Hi mikall,

Could you please let us know your exact regional settings configuration so that we can reproduce the problem here and try to find a solution to it?

Thanks in advance.

mikall · Post by **mikall** » Mon Feb 20, 2006 3:18 am

I'm not exactly sure what configuration setting information you need but I'm running Windows XP Professional with the default Regional and Language Options for "English (United States)"

If you need additional or other information, let me know.

Regards,

Michael Rekoff

Narcís · Post by **Narcís** » Mon Feb 27, 2006 11:07 am

Hi Michael,

We have been able to reproduce the problem here. However, it works fine with TeeChart Pro v7.07 beta which we will release soon. I'm going to send you the .ocx file so that you can test it at your end.