On 27/05/2016 14:44, Kurt Wendt wrote:
So - here at my day job my main task is to support this one team of users. And,
they're job is the Most Time critical here in this co. As such, things must
always be done in a timely manner - and support of them is critical in that
they Can not have the system down at any point in time.
Well - part of the system outputs an Excel file that must be sent to the
clients. There is a problem that they have had over time. It's kind of
intermittent. Although - yesterday it happened to Four of the users about the
same time. So - they were kinda freakin' out.
Problem is - they can't generally replicate the problem. So - if they can't
give me instructions on how to re-create the problem, its Nearly impossible to
try and fix the problem.
Anyway - here's the issue. In a number of Cells in the spreadsheet - it
contains the following as a value: #NUM!
And - yeah - that's exactly what it looks like - and I just copied it right
from the cell.
Has anyone seen this kind of problem before???
Lastly - we are using VFP9 - and the Excel file is created using the COPY
command.
If the excel file is created using the copy command put a line before
the copy to copy to a dbf for your use. You can then play with this
file to try to copy to excel to reproduce the error.
I've seen this kind of thing with say C(1) fields that have numbers in.
After you copy to excel, if you try to sum the number it won't work. If
you do the copy above you can look at the structure of the field that
gives #NUM to check.
Peter
This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR.
Tel:0161 831 3700
Fax:0161 831 3715
London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/b68c3079-42ec-4848-c515-9021aba25...@whisperingsmith.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
