Different format while Exporting to excel and copy data to Clipboard

[vlad_komarov]

Hello!

I have multiple charts in my application that displays some time trends:

I am using an Interval Number option in these charts with "h:mm" format pattern

But I have different results during different export methods:

Results after "Send Values to Excel"

Data is displayed in h:mm:ss format

Results after "Copy to Clipboard"--> "Values"-->"Paste to Excel"

Data is displayed as expected, in "h:mm" format.

Any suggestions how to make the "Send Values to Excel" option to follow the required format?

Thanks!

Best regards,

Vladimir

[vlad_komarov · Accepted solution]

The solutiuon is actually to use the time(Number, 'h:mm') method in all expressions and set the Number Option to "Expression Default". It sometimes creates a problem for displaying time values on chart's Y axis, but it seems to be working on all other cases.

Overall, it looks like a bug in QV.

[vlad_komarov]

But you need to be careful with Time() function if you are doing totals on the charts.

Using h:mm format leaves only hours and minutes and truncates Days from the total if sum of your time periods is big enough.