DataBar negative value bug

DataBar negative value bug

Posted by: andrea.traverso on 23 October 2017, 9:36 pm EST

• 

  andrea.traverso

  • Post Options:
  • Link
    Copy

  Posted 23 October 2017, 9:36 pm EST

  Hi,
  
  I found a bug with databar to solve.
  
  I have reconstructed in your sample “Expense Budget”
  
  https://www.grapecity.com/en/demos/spread/JS/TutorialSample/#/examples/expensebudget

  If you change all the value to negative value

  
  	    var dataTable = [];
              dataTable[0] = new Array("STATUS", "OPERATING", "BUDGET", "ACTUAL", "DIFFERENCE ($)", "DIFFERENCE (%)");
              dataTable[1] = new Array(0, "Advertising", -600, 545, 0, 0);
              dataTable[2] = new Array(0, "Debts", -125, 150, 0, 0);
              dataTable[3] = new Array(0, "Benefits", -100, 100, 0, 0);
              dataTable[4] = new Array(0, "Supplies", -100, 90, 0, 0);
              dataTable[5] = new Array(0, "Postage", -150, 145, 0, 0);
              dataTable[6] = new Array(0, "Rent or mortgage", -1000, 1000, 0, 0);
              dataTable[7] = new Array(0, "Sales expenses", -500, 630, 0, 0);
              dataTable[8] = new Array(0, "Taxes", -350, 375, 0, 0);
              dataTable[9] = new Array(0, "Utilities", -400, 370, 0, 0);
              dataTable[10] = new Array(0, "Other", -500, 435, 0, 0);
              dataTable[11] = new Array(0, "Total Expenses", 0, 0, 0, 0);
  
  

  Databar color the cell with no sense.

  If even one single value is positive all is correct
  
  For example with

  
  dataTable[1] = new Array(0, "Advertising", 600, 545, 0, 0);
  
  

  all appear correct

  I see previous “Expense Budget” with 9 and wijmo before that no have problems

  I hope you can solve
  
  Thanks

  Giovanni

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 26 October 2017, 3:55 am EST

  Hi,

  I am able to replicate this issue at my end. I will submit it as a bug to the development team.

  Thanks,
  
  Deepak Sharma

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 26 October 2017, 7:46 pm EST

  Hello,

  Tracking id for this issue is #248395. I will let you know once I get an update on this.

  Thanks,
  
  Deepak Sharma