getting values out of specific cells

May 15, 2013 at 1:33 AM
Hi there, I have this project that requires me to extract data from an excel file and store it into database. One problem that I have encountered is how to read or get the value out of a specific cell with a formula like this: =TEXT(E16/1440,"h:mm")+G15
I tried using getValue() but it returns the actual formula, I also tried using getFormattedValue() and getCalculatedValue() but they all return #VALUE. I hope you can help me in this. :)
May 15, 2013 at 10:58 AM
Function TEXT is marked 'not yet implemented'. Try by getOldCalculatedValue.
May 16, 2013 at 4:42 AM
Thanks. getOldCalculatedValue() returns the value of the cell, I would just have to tweak my codes a little so that the value could be in H:MM format. :)