When exporting web report to Excel/Word file, the precision of high precision time data will decrease.
That is because of the display format of Excel/Word. For example, if there are time data of millisecond, it will changed to second after being exported to Excel/Word.
This is troublesome for users of web report. then, is there a way to keep the precision of time data with web reporting tool
The answer is yes!
As a professional web-based Java reporting tool, RAQ Report
pays a lot of attention to details. For this problem, RAQ Report provides a wonderful function — str().
Users only need to write the function as str(value(),”yyyy-MM-dd HH:mm s.S”) as shown below. Then, time data can be displayed correctly after being exported to Excel/Word file.
This post is from freezea's blog. You are welcomed cc it anywhere, and please indicate the source.
If you would like to read more articles about reporting tool, you are also welcome to refer to my blog