[davedesh]

Background

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?

Solution

The answer is yes!

As a free web-based Java reporting tool, RAQ Report pays a lot of attention to details. For this problem, RAQ Report provides a wonderful function — str().

Easy Operation

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.