Funnily enough we also had an issue with the clipboard earlier in the week when using DataToClip().
When using date fields or datetime fields in the cursor, running DataToCLip(<cursor>, <Option>) whether Option is set to 1 or 3 (Space delimited or tab delimited) and then pasting the clipboard into Excel, dates really do screw up as some dates go in British style DD/MM/YY and other dates get pasted in the American format MM/DD/YY regardless of the display format selected. Solution: In the cursor you are copying into the clipboard, send " "+dtoc(<datefield>) as opposed to the datefield. Note that just using dtoc(<datefield>) produces exactly the same results as sending a date field. All date fields then go into the spreadsheet as proper "Date" values and are displayed correctly. Just a heads up in case anyone else is pasting into Excel. Dave -----Original Message----- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Paul Newton Sent: 07 December 2017 10:44 To: profoxt...@leafe.com Subject: Issue with _cliptext Hi all If I run the following code = Adbobjects(laTables, 'Table') = Asort(laTables) _Cliptext = "" * The array has 365 rows For lnTable = 1 To Alen(laTables) Use (Right(Juststem(loData),1) + "_" + laTables(lnTable)) _Cliptext = _Cliptext + Padr(laTables(lnTable),20) + Replicate(Chr(9),2) + Str(Reccount(),10,0) + Chr(13) Endfor ? MemLines(_Cliptext) * _Cliptext only has 357 lines But if I use a variable lcCliptext instead of _Cliptext all is well (lcCliptext has 365 lines). It is as if _Cliptext can't keep up ... Paul Newton [excessive quoting removed by server] _______________________________________________ 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/18725b8cd2d5d247873a2baf401d4ab2bea75...@ex2010-a-fpl.fpl.LOCAL ** 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.
