Hi,
I am using current date time field in my data Excel, but in the excel I have bind is not automatically updated as the time chances frequently, the current date time. It only contains the value(date time) the time I have saved before.
I am using current date time field in my data Excel, but in the excel I have bind is not automatically updated as the time chances frequently, the current date time. It only contains the value(date time) the time I have saved before.
3 Answers, 1 is accepted
0
Hi Aruna,
I tested this using the forumla =TODAY() and it seems to be working as expected. Can you share with me the cell formula you are using, or even better yet the Excel file you are using? Please put the file into a .zip file and attached the .zip file.
Regards,
Cody
Telerik
I tested this using the forumla =TODAY() and it seems to be working as expected. Can you share with me the cell formula you are using, or even better yet the Excel file you are using? Please put the file into a .zip file and attached the .zip file.
Regards,
Cody
Telerik
0
aruna
Top achievements
Rank 1
Rank 1
answered on 20 Feb 2015, 04:36 AM
Hi,
Here I am attached our sample document, in that we used the last sheet (Bind Value) for excel bind. For example, in that excel the start date and end date is automatically calculated, I am saved that excel lastly in today, if tomorrow I bind that excel without saving, it cant updated as current date(tomorrow's date), it only take today's date.
Here I am attached our sample document, in that we used the last sheet (Bind Value) for excel bind. For example, in that excel the start date and end date is automatically calculated, I am saved that excel lastly in today, if tomorrow I bind that excel without saving, it cant updated as current date(tomorrow's date), it only take today's date.
0
Hello Aruna,
Thank you for the sample spreadsheet. After further investigation I find that you are correct. Test Studio can only load the last saved value that Excel stored in the spreadsheet file on disk. It cannot run the formula's contained in it. As an example, a cell containing "=NOW()" is stored in the file this way:
Test Studio (using the Excel API) is getting the last Excel calculated and stored value i.e. <v>42055.628697916669</v>. It cannot run the NOW() formula, or any other formula.
Regards,
Cody
Telerik
Thank you for the sample spreadsheet. After further investigation I find that you are correct. Test Studio can only load the last saved value that Excel stored in the spreadsheet file on disk. It cannot run the formula's contained in it. As an example, a cell containing "=NOW()" is stored in the file this way:
<row r="1" spans="1:1" x14ac:dyDescent="0.25"> <c r="A1" s="1"> <f ca="1">NOW()</f><v>42055.628697916669</v> </c></row>Test Studio (using the Excel API) is getting the last Excel calculated and stored value i.e. <v>42055.628697916669</v>. It cannot run the NOW() formula, or any other formula.
Regards,
Cody
Telerik