Focal Point
[CASE-OPENED]Time value in excel

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9277085436

November 08, 2013, 10:08 AM
reinjy
[CASE-OPENED]Time value in excel
We have WF8 and WIN7. In table I have time value 10:05:23.000, in htm report all OK. When I get report in excel, then in time value cell number like (-698098098,909089080) and in excel cell user saw only ############## and I cant format this. In excel it works only when I have cell format datetime (12.11.2013 10:05:24.000).

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS 8
Windows 8, All Outputs
November 13, 2013, 07:33 PM
<Kathryn Henning>
Hi reinjy,

Where you're seeing the ##############, how is this field described in the Master File Description for the data source that you're reading? Are you reformatting the field in the FOCEXEC? What version of Excel are you using?

Regards,

Kathryn
November 14, 2013, 01:41 PM
reinjy
Hei Kathryn,

so in master fail it is so: HHISs and before, when we had WF7.6 it works well, but now after we change to WF8 (ver 8003) I got this error.
I'm not reformating the field.
We are using Win7 and Excel 2010.
I try'd formats EXL2K, EXL07, XLSX.
If I used HYYMDs and in FOCEXEC I reformat it for time, then it works normally, but I need specially only time value.

Regards,
Rein


WebFOCUS 8
Windows 8, All Outputs
November 14, 2013, 08:01 PM
<Kathryn Henning>
Hi reinjy,

Please open a case on InfoResponse Online so that we can look into what is occurring.

Thanks and regards,

Kathryn
April 08, 2016, 11:31 AM
Pondog
Has there been a resolution to this case? I'm experiencing the same situation.

Thanks,
Tony


WebFOCUS 8.1.05
Windows, All Outputs