Codejock Developer Community : Numbers xtpEditStyleNumber

Numbers xtpEditStyleNumber : Glad to help!

Thu, 15 Apr 2010 13:35:14 +0000

Author: jpbro
Subject: 16596
Posted: 15 April 2010 at 1:35pm

Glad to help!

Numbers xtpEditStyleNumber : Thanks jpbro that works for me. Cheers...

Thu, 15 Apr 2010 10:59:05 +0000

Author: markmark
Subject: 16596
Posted: 15 April 2010 at 10:59am

Thanks jpbro that works for me.

Cheers

Numbers xtpEditStyleNumber : You can use the InplaceEditChanging...

Thu, 15 Apr 2010 10:11:33 +0000

Author: jpbro
Subject: 16596
Posted: 15 April 2010 at 10:11am

You can use the InplaceEditChanging event along the lines of this:


Private Sub repServers_InplaceEditChanging(ByVal Row As XtremeReportControl.IReportRow, ByVal Column As XtremeReportControl.IReportColumn, ByVal Item As XtremeReportControl.IReportRecordItem, NewValue As String, Cancel As Boolean)
    If Len(NewValue) <> 0 Then
         Cancel = Not IsNumeric(NewValue)
    End If
End Sub

Although that would allow currency symbols as well (and negative values). You can expand your testing as required if you don't want to allow such values.

Numbers xtpEditStyleNumber : Hi I am using this code ...

Thu, 15 Apr 2010 08:45:00 +0000

Author: markmark
Subject: 16596
Posted: 15 April 2010 at 8:45am

Hi

I am using this code

    Set Item = rRecord.AddItem("")
    Item.CreateEditOptions
    Item.EditOptions.EditControlStyle = xtpEditStyleNumber

This allows only numbers, but I would like to be able to enter values with a decimal point ie 12.123

But it only allows whole numbers, is there away to do this?

Thanks

Mark