ColumnFormat

Opto_Will

I have a negative number, say -5.00, I am passing into a ReportTable.
The format mask for that related column is "$#,##0.00" (butI I have tried what seems like every combination of 0's and #'s in the mask)

The value displaying is -$50.00 (inflated by factor of 10).

If I pass through -50.0 I see -$500.00 (also inflated by factor of 10).
If I pass through -.500 I see -$0.50 (correct)

I am guessing it is something to do with the negative value.
I might need a little guidance on how to correctly display the negative value.

I am running SRPControls 4.1.5.

FrankTomeo

Hi Will,

I tested this out myself and I'm getting the same odd result (with a 4.1.6 version). I also tested the "$#,##0.00" format in Excel and it doesn't seem to have the same trouble with the -5.00 value. Not quite sure what is going on, but I think you are using the ColumnList format option correctly. This may be a display bug, but someone else is going to have to confirm that.

Opto_Will

Thanks for having a look Frank. Another staff member clocking in the OT!

Yep, your results replicate mine. I shall wait for further confirmation...

KevinFournier

I was able to recreate this as well. I'll take a look at this tomorrow and get you a fix as soon as possible.

Opto_Will

Thanks Kevin :)

KevinFournier

Fixed in 4.1.6.

Opto_Will

Kevin,

I downloaded 4.1.6 from the product page link you provided (4.1.6.5)
I copied it over my old OCX and re-registered.


It doesnt seem to make a difference?

this is my format
Set_Property(Ctrl , "OLE.ColumnFormat[15]" , "$#,##0.00")

This is my data:


This is my output:

(should be 1@-$5 and 2@-$1)

Any ideas what I might be doing wrong/not doing?

Opto_Will

No formatting proves the data is still right.

KevinFournier

Sorry. Bad build. I've replaced the builds on the products site. It's still version 4.1.6, but the full build number should be 4.1.6.6 instead of 4.1.6.5. Download again.

Opto_Will

Kevin,

Excellent. That works!

You were just messing with my head for a bit there ;-)