ReoGrid Forum
You are not logged in.
- Topics: Active | Unanswered
Announcement
This forum has been archived and no longer accepts new user registrations. Please report your questions, problems, and feedback to the issue page of ReoGrid on GitHub. Thank you for your cooperation.
Pages: 1
Topic closed
#1 2016-04-05 02:11:32
- asparatu
- Member
- Registered: 2014-08-20
- Posts: 196
Data Formatter Question
Hello Jing,
I was trying to use the SetRangeDataFormat property and using the example you have, but it does not find the DecimalPlaces, NegativeStyle, and UseSeparator for the unvell.ReoGrid.DataFormat.NumberDataFormatter.NumberFormatArgs
Shane
Offline
#2 2016-04-05 07:34:28
- Jingwood
- Moderator
- From: jing at reogrid.net
- Registered: 2014-06-03
- Posts: 615
Re: Data Formatter Question
Hi Shane, could you please show me your code.
Offline
#3 2016-04-05 09:27:52
- asparatu
- Member
- Registered: 2014-08-20
- Posts: 196
Re: Data Formatter Question
Hello Jing,
Sorry.. I always show the code and just didnt this time.
Sheet.SetRangeDataFormat("A5", CellDataFormatFlag.Number,
New unvell.ReoGrid.DataFormat.NumberDataFormatter.NumberFormatArgs() {DecimalPlaces = 4,
NegativeStyle = NumberDataFormatter.NumberNegativeStyle.RedBrackets,
UseSeparator = false})Shane
Last edited by asparatu (2016-04-05 09:29:07)
Offline
#4 2016-04-05 14:59:43
- Jingwood
- Moderator
- From: jing at reogrid.net
- Registered: 2014-06-03
- Posts: 615
Re: Data Formatter Question
Hi Shane, by my test the correct syntax for VB.NET looks like:
sheet.SetRangeDataFormat("A5", CellDataFormatFlag.Number,
New unvell.ReoGrid.DataFormat.NumberDataFormatter.NumberFormatArgs With {
.DecimalPlaces = 4,
.NegativeStyle = NumberDataFormatter.NumberNegativeStyle.RedBrackets,
.UseSeparator = False
})Offline
#5 2016-04-05 16:29:31
- alexeyrlx
- Moderator
- From: CIS
- Registered: 2015-07-14
- Posts: 36
- Website
Re: Data Formatter Question
Hi Shane, Jing
Last code is work)
For test:
Dim sheet As Worksheet = rGrid.CurrentWorksheet
sheet("A5") = "-3"
sheet.SetRangeDataFormat("A5", CellDataFormatFlag.Number,
New unvell.ReoGrid.DataFormat.NumberDataFormatter.NumberFormatArgs With {
.DecimalPlaces = 4,
.NegativeStyle = NumberDataFormatter.NumberNegativeStyle.RedBrackets,
.UseSeparator = False
})Result:
My English is perfect! (My version of the English language ;-) )
Offline
#6 2016-04-07 01:22:05
- asparatu
- Member
- Registered: 2014-08-20
- Posts: 196
Re: Data Formatter Question
Hello Jing,
That worked thank you..
Shane
Offline
Pages: 1
Topic closed