It is currently Sun Dec 17, 2017 4:59 pm




Post new topic Reply to topic  [ 1 post ] 
Conditional formatting of floating point numbers 
Author Message

Joined: Fri Aug 22, 2008 1:03 pm
Posts: 94
Location: Australia
Post Conditional formatting of floating point numbers
Version: 6.0.0.8
Edition: Developer
Language: PHP
Floating point numbers between 1 and -1 will not display as expected when conditional formatting is specified. This is because dbQwiksite casts the value to an integer before the comparison as in the following:
if ( (int)$cellvalue < 0.00 )
print " style=\" color:#FF0000; font-style:normal; font-weight:normal\"";

This converts any numbers between 1 and -1 to a zero.
The workaround is to change the condition from 'less than' '0' to 'contains ' '-'.

_________________
www.conwave.com.au


Sat Nov 13, 2010 7:19 am
Profile E-mail WWW
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Copyright © 2004-2008 TheDevShop Ltd. All Rights Reserved