SamuraiJackContributor15 years agoRecording an checkpoint Integer variable to excel as a string?The number in question is 0024248.. Currently usingdtaSheet.Cells(tcRw,"A") = aqConvert.VarToStr(page.PolNum.innerText)Records in Excel as 24248.Jack
1 ReplyReplies sorted by Most LikedSort ByMost LikedOldestNewestYMinaevStaff15 years agoHi Jack,This behavior is normal (by default). To force MS Excel not to truncate zeros, you need to set the cell format to Text by using its NumberFormat propety (cell.NumberFormat = "Text").
YMinaevStaff15 years agoHi Jack,This behavior is normal (by default). To force MS Excel not to truncate zeros, you need to set the cell format to Text by using its NumberFormat propety (cell.NumberFormat = "Text").
Related ContentCheckpointXML CheckpointHow to change value to variable in "Edit Property Checkpoint"?Checkpoint-like feature for Equalityhow to use a variable name in checkpoint?
Recent DiscussionsMultiple execution of a test plan with different values from an Excel tablePulling in Dynamic Links from a web pageDynamic ObjectYour thoughts about a REST API in TestCompleteKeyword Test - Click - use -1, -1 by default?