Search Results

This is quite hacky. NumberFormat returns a string which is them implicitly parsed to a number. The only reason that it works is that the implicit parsing returns a double which is the same type of the right hand side. I wouldn't consider it safe code. The correct way to compare two floating point
link: this works too: Dim Value As Float=8.21 Log(NumberFormat2(Value,1,2,0,False) <=8.20) 'FALSE' Log(NumberFormat2(Value,1,2,0,False) <=8.

B4XFormatter is an alternative to NumberFormat / NumberFormat2 keywords. It is implemented in B4X and it is cross platform. There are two types in the library: B4XFormatter - The main class. B4XFormatData - A type with various configurable fields. The formatter holds a list of format data objects

If you use NumberFormat(1000000,0,2) on Android it correctly displays as "1,000,000" but displays as "1000000" on B4J. B4J: 89007 B4A: 89006
link: Strange, I tested it and get 1,000,000 with both platforms! B4A version 9.80 B4J version 8.10
link: It also works for me. Are you sure that you are not using NumberFormat2(1000000,0,0,2,False) on B4J? Edit: You are right, this is what I get Log(Num
link: Yes, looking inside jCore.jar this seems to be this sems to be a bug in B4J. In B4A in Core.jar NumberFormat and NumberFormat2 use separate instances

It is correct. NumberFormat converts a Double into a String with "," as the thousand separator by default. To get the result you expect you should use: NumberFormat2(150, 5, 0, 0, False)
link: are you sure ? for me the right resut is 00150 NumberFormat(Number as Double,MinimumInteger As Int,MaximumFractions As Int) As String Example : Num
link: The NumberFormat statement in versione 8.50 wrong. for example : FormatNumber(150,5,0) = 00,150
link: Looks correct.

What exactly do you expect ? NumberFormat(Number As Double, MinimumIntegers As Int, MaximumFractions As Int) returns 2 fractions max but removes any non significant zeros. If you want at least one fraction you should use NumberFormat2: NumberFormat2(Number As Double, MinimumIntegers As Int, MaximumF
link: Aha! Thanks Klaus! I was unaware of numberformat2, don't know how I missed this. I was expecting the zero to remain...my bad :) Rusty

In the code you posted in the first post there is no difference between the two methods. NumberFormat is the preferred method. It encourages you to keep the most accurate value (stored in the Double variable) and only round the number when you display it to the user. Note that you can also use the
link: The NumberFormat methods are best suited to displaying data as they return strings. Round returns a Long type and Round2 returns a Double type. For
link: Use NumberFormat if you want to have a specific result. Store the value as Double or Float in your database. Use Numberformat to format the output
link: When rounding numbers for currencies, is there a preference between Round2 or NumberFormat2? I know that Erel prefers NumberFormat2 for rounding, but

NumberFormat is a B4X function, not an Excel function. So in this case, NumberFormat would execute before Summe.InitializeFormula places the cell contents into the Excel workbook and before Excel does any calculations. I don't think this is what you were trying to accomplish. This is before we get t
link: Hi, what ist wrong? Summe.InitializeFormula(7,4,NumberFormat("(E5-B5)*24", 2 ,2))

Use NumberFormat / B4XFormatter to convert a number to string.

Although the behaviour is indeed different, I honestly find what B4J (Java) produces confusing. If I ask for a minimum of two fractions, I would expect 0,00 not 0 I see quite some posts with questions on how numberformat works and what people expect as result.
link: This does indeed sound like a bug as it is the intention that both act the same. I will have a look.
link: Hi, It says that NumberFormat and NumberFormat2 is supported in BANano but I get a different behavior than in B4J. If I use: NumberFormat2(314.159265
link: Will be fixed in the next update. (All but that weird 0 <> 0.00 one where I have no idea what the reasoning in Java could be. Until I do, this case w

I use NumberFormat (and NumberFormat2) a lot. It's a life saver! I was just wondering if there's a particular reason, something evil or mysterious about number 3, or if I was doing something wrong. Fortunately, thanks to Erel, NumberFormat also "rounds" the number to the specified number of fraction
link: If you need to show this as 1.4 and not 1.40000000001 here is example. Not sure if there any other better ways to address this. value1 = 1.3 + 0.1 L
link: The binary representation cannot 100% accurately represent all decimal numbers. Never convert a number to a string without using NumberFormat (or one

Powered by ColBERT