Open one of the spreadsheets and click in a cell that says #NUM! -- literally, Not A Number.
Look in the bar across the top and see what the expression in the cell is.
You can add a little instrumentation to the application to capture what is requested and what is output -- memo fields are good for this, but remember to clean them out before the database gets too big (PACK MEMO).
On Fri, May 27, 2016 at 9:44 AM, Kurt Wendt Kurt_Wendt@globetax.com 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.
Also - did a Google search - and one hit was M$ and a help page - it claimed: Excel shows this error when a formula or function contains numeric values that aren't valid.
But - of course, its Straight data being exported - NO Formulas!
Any input would be greatly appreciated.
Regards, Kurt Wendt Senior Systems Analyst [GlobeTax_SecondaryLogo_TwoColor_Lo]https://www.globetax.com/ One New York Plaza - 34th Floor New York, NY 10004-1936, USA Tel. +1-212-747-9100 Direct +1-212-405-8246 www.GlobeTax.comhttps://www.globetax.com/
GlobeTax does not provide or offer, and this is not, tax, investment or legal advice. This email and any attachments hereto is intended only for use by the addressee(s) and may contain confidential information. If you are not the intended recipient of this email, please immediately notify the sender at +1-212-747-9100 and permanently delete the original and any copies of this email.
--- StripMime Report -- processed MIME parts --- multipart/related multipart/alternative text/plain (text body -- kept) text/html image/png
[excessive quoting removed by server]