You can use the setCell method, which would allow you to specify whether or not to overwrite the formatted value of the cell:
data.setCell(row, column, value, undefined); // keep the formatted value as is data.setCell(row, column, value, null); // use the new value to create the formatted value data.setCell(row, column, value, formattedValue); // specify the formatted value yourself On Friday, January 18, 2013 12:10:30 PM UTC-5, Workaholic wrote: > > Thanks. > You are right, I have lots of lines in a for loop that goes like this: > data.setValue(i-1,j,((totalRevenues/impressions)*1000)); > > How do I set also the formatted value of cell? > Maybe I need to use setCell instead of setValue? > > > > On Fri, Jan 18, 2013 at 7:03 PM, asgallant > <[email protected]<javascript:> > > wrote: > >> The tooltip values are determined by the values in the DataTable, so >> somewhere along the way you are setting the formatted value of the cells to >> the wrong value. >> >> >> On Friday, January 18, 2013 11:42:24 AM UTC-5, Workaholic wrote: >> >>> It a little bit long, because it helds a lot of calculations on my data >>> table. >>> But after all the calculations I print all the elements from the data >>> table and the values are correct. >>> Also, the values on the y axis are good after drawing. Only the on mouse >>> over values not correct. >>> >>> I've posted all the code that deals with my data table after all the >>> calculations in the first message. >>> Maybe it because I'm not define the options correctly? Am I missing >>> something there? >>> >>> Thanks again >>> >>> >>> On Fri, Jan 18, 2013 at 6:21 PM, asgallant <[email protected]>wrote: >>> >>>> If you post your source code I'll take a look and see what might be the >>>> problem. >>>> >>>> >>>> On Friday, January 18, 2013 6:47:34 AM UTC-5, Workaholic wrote: >>>>> >>>>> >>>>> >>>>> On Friday, January 18, 2013 1:45:02 PM UTC+2, [email protected]: >>>>>> >>>>>> Hi, >>>>>> I've a strange bug. >>>>>> I'm building a linechart on google visualization using datasource. >>>>>> The drawing of the chart works great, >>>>>> but when I mouse over certain metrics in my line, the value is not >>>>>> presented with the real metrics values. >>>>>> For example, I attached a printscreen, where you can see that the >>>>>> value presented for imps for 1/5/13 is 923, where it actually 23,344,122. >>>>>> >>>>>> Here is the part of my code that I'm actually drawing the line chart: >>>>>> >>>>>> ==============================****================== >>>>>> var options = { >>>>>> width: 600, height: 400, >>>>>> vAxes: { 0: {format: "#,###"}, >>>>>> 1: {format: "#,###"} >>>>>> }, >>>>>> series: { >>>>>> 0:{targetAxisIndex: 0 }, >>>>>> 1: {targetAxisIndex: 1} >>>>>> } >>>>>> }; >>>>>> >>>>>> visualization = new google.visualization.**LineChart** >>>>>> (document.**getElementById('**visualization'**)); >>>>>> visualization.draw(data,**option**s); >>>>>> ==============================****=================== >>>>>> >>>>>> Any ideas why? >>>>>> >>>>>> Thanks. >>>>>> >>>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "Google Visualization API" group. >>>> To view this discussion on the web visit https://groups.google.com/d/** >>>> msg/google-visualization-api/-**/tKogZKkzH24J<https://groups.google.com/d/msg/google-visualization-api/-/tKogZKkzH24J> >>>> . >>>> >>>> To post to this group, send email to google-visua...@**googlegroups.com >>>> . >>>> >>>> To unsubscribe from this group, send email to google-visualization-api+ >>>> **[email protected]. >>>> For more options, visit this group at http://groups.google.com/** >>>> group/google-visualization-**api?hl=en<http://groups.google.com/group/google-visualization-api?hl=en> >>>> . >>>> >>> >>> -- >> You received this message because you are subscribed to the Google Groups >> "Google Visualization API" group. >> To view this discussion on the web visit >> https://groups.google.com/d/msg/google-visualization-api/-/M3JJW00dAKYJ. >> >> To post to this group, send email to >> [email protected]<javascript:> >> . >> To unsubscribe from this group, send email to >> [email protected] <javascript:>. >> For more options, visit this group at >> http://groups.google.com/group/google-visualization-api?hl=en. >> > > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/PxGVJ9S8QugJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
