SOLVED: Paste Validate
Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Report Control
Forum Description: Topics Related to Codejock Report Control
URL: http://forum.codejock.com/forum_posts.asp?TID=11466
Printed Date: 23 November 2024 at 2:23pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: SOLVED: Paste Validate
Posted By: ElvisM
Subject: SOLVED: Paste Validate
Date Posted: 16 July 2008 at 3:08pm
|
Hi, is possible validate the record meanwhile they're pasting (in the air)?
I'm using the PasteRecordFromText event, but I don't know how it works. Because I can't take control over the clipboard data and I can't decide which records are good and which records are bad...
Please, excuseme my bad english. ------------- Product: Xtreme SuitePro (ActiveX) version 17.2 Platform: Windows 10 64bits Language: Visual Basic 2015 |
Replies:
Posted By: Aaron
Date Posted: 17 July 2008 at 7:18am
|
Elvis,
Please, upload sample project and maybe I can help you and in the meantime you can change the topic descriptions I asked you to and look at post: https://forum.codejock.com/forum_posts.asp?TID=11225 - https://forum.codejock.com/forum_posts.asp?TID=11225
------------- Product: Xtreme SuitePro (ActiveX) version 15.0.2 Platform: Windows XP (32bit) - SP 2 Language: Visual Basic 6.0 Zero replies is not an option.... |
Posted By: ElvisM
Date Posted: 17 July 2008 at 12:50pm
|
Hi Aaron, I just have changed my signature.
Please, help me with my topic.
I need validate the text that the user is pasting in te reportcontrol, is this possible?
Elvis ------------- Product: Xtreme SuitePro (ActiveX) version 17.2 Platform: Windows 10 64bits Language: Visual Basic 2015 |
Posted By: Aaron
Date Posted: 31 July 2008 at 2:48am
|
Elvis,
It's either SOLVED: or it stays a question
 I'm not sure if I understand your question. If you would paste some text while editing report item, you want to check the contents?
If you use the:
Private Sub wndReportControl_InplaceEditChanging(ByVal Row As XtremeReportControl.IReportRow, ByVal Column As XtremeReportControl.IReportColumn, ByVal Item As XtremeReportControl.IReportRecordItem, NewValue As String, Cancel As Boolean)
Me.Caption = NewValue End Sub NewValue is contents of report item string (updates after typing or in your case pasting text).
Hope this helps
------------- Product: Xtreme SuitePro (ActiveX) version 15.0.2 Platform: Windows XP (32bit) - SP 2 Language: Visual Basic 6.0 Zero replies is not an option.... |
Posted By: ElvisM
Date Posted: 04 August 2008 at 3:04pm
|
Hi Aaron, definitively, I don't know express you my issue.
Look...
I'm pasting a lot of records from Excel, but I wolud like to validate this records by the same time (if is possible) they're pasting in the reortcontrol, not after they were pasted.
For instance, if one of this records has an invalid date field, I would like to exclude this record "in the air" (before the pasting execute). If I have 10 lines in Excel, and one of them are invalid then in the reportcontrol only 9 records must be pasted.
I tried to work with the reportcontrol's BeforePasteFromText property but I don't know how it work...
The codejock's help is vwry simple and doesn't have enough examples.
Do you understand me?
Regards,
Elvis
------------- Product: Xtreme SuitePro (ActiveX) version 17.2 Platform: Windows 10 64bits Language: Visual Basic 2015 |
Posted By: elchinote
Date Posted: 15 March 2013 at 12:11am
|
hi how are you? i'm searching how i can paste cells (data) from excel to the report control using VB6. I'm trying to copy/paste and transfer the data directly, without Excel References, only with clipboard. I've found this post. Can you show me how did you solve this issue?. regards
|