Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #12995 > unrolled thread

How to use Clipboard:InsertRTF() to paste into EXCEL?

Started byJuan Chavarría <juan.chavarria.grillo@gmail.com>
First post2020-05-22 20:48 -0700
Last post2020-06-29 11:30 -0700
Articles 5 — 3 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  How to use Clipboard:InsertRTF() to paste into EXCEL? Juan Chavarría <juan.chavarria.grillo@gmail.com> - 2020-05-22 20:48 -0700
    Re: How to use Clipboard:InsertRTF() to paste into EXCEL? Gianluca72 <gianluca.pinoli@proximacentauri.it> - 2020-05-27 05:19 -0700
      Re: How to use Clipboard:InsertRTF() to paste into EXCEL? Juan Chavarría <juan.chavarria.grillo@gmail.com> - 2020-06-10 13:19 -0700
        Re: How to use Clipboard:InsertRTF() to paste into EXCEL? Arne Ortlinghaus <Arne.Ortlinghaus@acs.it> - 2020-06-14 07:54 +0200
          Re: How to use Clipboard:InsertRTF() to paste into EXCEL? Juan Chavarría <juan.chavarria.grillo@gmail.com> - 2020-06-29 11:30 -0700

#12995 — How to use Clipboard:InsertRTF() to paste into EXCEL?

FromJuan Chavarría <juan.chavarria.grillo@gmail.com>
Date2020-05-22 20:48 -0700
SubjectHow to use Clipboard:InsertRTF() to paste into EXCEL?
Message-ID<37dd0a8b-36fb-4b79-b01c-8f25d89a3c6d@googlegroups.com>
HI:
Can somebody tell me how to structure the text parameter in the Clipboard:InsertRTF() method in order to paste the clipboard in Excel?

I've tried with the folowing text:

y:="{\rtf1\ansi\deff0 {\fonttbl {\f0 Arial;} }"
y+="{\f0\fs14\par";
+"\trowd \trqc\trgaph108\trrh280\trleft36";
+"\clbrdrt\brdrth \clbrdrl\brdrth \clbrdrb\brdrdb";
+"\clbrdrr\brdrdb \cellx3636\clbrdrt\brdrth";
+"\clbrdrl\brdrdb \clbrdrb\brdrdb \clbrdrr\brdrdb";
+"\cellx7236\clbrdrt\brdrth \clbrdrl\brdrdb";
+"\clbrdrb\brdrdb \clbrdrr\brdrdb \cellx10836\pard \intbl";
+" CELDA-A1\cell \pard \intbl CELDA-A2\cell \pard \intbl CELDA-A3\cell \pard \intbl \row";
+"\trowd \trqc\trgaph108\trrh280\trleft36 \clbrdrt\brdrdb";
+"\clbrdrl\brdrth \clbrdrb \brdrsh\brdrs \clbrdrr\brdrdb";
+"\cellx3636\clbrdrt\brdrdb \clbrdr \brdrdb";
+"\clbrdrb\brdrsh\brdrs \clbrdrr\brdrdb";
+"\cellx7236\clbrdrt\brdrdb \clbrdr \brdrdb";
+"\clbrdrb\brdrsh\brdrs \clbrdrr\brdrdb \cellx10836\pard";
+"\intbl \fs50 CELDA-B1 \cell \pard \intbl \fs14 CELDA-B2 \cell \pard \intbl \fs35 Celda-B3 \cell \pard";
+"\intbl \row \pard"
y+="}"
cp:InsertRTF(y)

It works fine pasting in Word for Windows. But It does not work in Excel.

And if I paste IT in Word and later I re-copy it from Word...

Then it works fine in Excel!!! 

Thanks for any help,

Juan

[toc] | [next] | [standalone]


#12999

FromGianluca72 <gianluca.pinoli@proximacentauri.it>
Date2020-05-27 05:19 -0700
Message-ID<d757e0f0-8fc9-4615-bf6e-330449236b0e@googlegroups.com>
In reply to#12995
Hi Juan,
i have a simple function i use to copy data from a bBroaser object.
basically _chr(9) allow you to shift to the next coloumn , and _CHR(13) + _CHR(10) to the next line.

Regards
Gianluca

************************************************ 
FUNCTION Clip_bBrowser_XLS( obBrowser , aTitolo )
//oListView -> Oggetto ListView
//aTitolo	-> array di Stringhe x Titolo (ogni elemento andrà in una colonna separata)

LOCAL oClipboard AS Clipboard
LOCAL cClipboard AS STRING
LOCAL oLVI AS ListViewItem
LOCAL nT AS INT
LOCAL cTitle, cTemp AS STRING
LOCAL i, nI, nCol, nItem  AS INT
LOCAL cCrLf,cTestata  AS STRING
LOCAL sSymCol AS SYMBOL
LOCAL sFieldType AS STRING

LOCAL cClipboard1,cClipboard2,cClipboard3,cClipboard4 AS STRING

LOCAL aColumnList AS ARRAY
*LOCAL oColumn AS bDataColumn

LOCAL obArray AS bArrayServer
obArray := obBrowser:server

cCrLf := _CHR(13) + _CHR(10)

IF obBrowser:ColumnCount > 0
	oClipboard := Clipboard{}
	nCol := obBrowser:ColumnCount
	nItem := obBrowser:Server:LastRec
	aColumnList := obBrowser:ColumnList

	oClipboard:Clear()
	//Titolo
	FOR nT := 1 TO Len(aTitolo)
		IF nT == 1
			cTitle += aTitolo[nT]
		ELSE
			cTitle += _chr(9)+ aTitolo[nT]
		ENDIF
	NEXT	
	cClipboard := cTitle + cCrLf + cCrLf
	FOR i := 1 TO nCol
		IF ! Empty(aColumnList[i]:FieldSym)
			cTestata := aColumnList[i]:Caption		
			*cTestata := obArray:FIELDINFO(DBS_NAME,i)
			cClipboard := cClipboard + cTestata + _chr(9)
		ENDIF
	NEXT
	cClipboard := cClipboard + cCrLf

	FOR i := 1 UPTO nItem
		IF MOD(i,10) = 0
			GetAppObject():Exec(EXECWHILEEVENT)
		ENDIF	
		cTemp := ''
		*oLVI := oListView:GetNextItem( LV_GNIBYITEM,,,,,i-1 )
		obArray:GoTo(i)
		FOR nI := 1 TO nCol
			sSymCol := obArray:FieldSym(aColumnList[nI]:FieldSym)
			*sSymCol := oListView:GetColumn(nI):NameSym
			//controllo testata LV
			//se = 'COD..' o 'ART..' Stringa Excel
			*cTestata := Upper(Left(oListView:GetColumn(nI):Caption,3))
			*IF cTestata == 'COD' .OR. cTestata == 'ART'
			*	cTemp += "'"+oLVI:GetText(sSymCol)+ _chr(9)
			*ELSE
			*	cTemp += oLVI:GetText(sSymCol)+ _chr(9)
			*ENDIF
			IF ! Empty(aColumnList[nI]:FieldSym)
				sFieldType := AllTrim(obArray:FIELDINFO(DBS_TYPE,aColumnList[nI]:FieldSym))
	            DO CASE
	            CASE sFieldType = 'C'
	            	cTemp += "'"+obArray:FIELDGET(aColumnList[nI]:FieldSym)+ _chr(9)
	            CASE sFieldType = 'N'
	            	cTemp += Str(obArray:FIELDGET(aColumnList[nI]:FieldSym))+ _chr(9)
	            CASE sFieldType = 'L'
	            	cTemp += IF(obArray:FIELDGET(aColumnList[nI]:FieldSym),"V","F")+ _chr(9)
	            CASE sFieldType = 'D'
	            	cTemp += DToC(obArray:FIELDGET(aColumnList[nI]:FieldSym))+ _chr(9)	
	            ENDCASE
			ENDIF
			
		NEXT
		cClipboard += cTemp+cCrLf
	NEXT	

	oClipboard:Insert(cClipboard)
ENDIF
RETURN

[toc] | [prev] | [next] | [standalone]


#13006

FromJuan Chavarría <juan.chavarria.grillo@gmail.com>
Date2020-06-10 13:19 -0700
Message-ID<42b75098-5eb2-4f35-afd8-385e86b8308eo@googlegroups.com>
In reply to#12999
Hi Gianluca:
Thank you very much for your answer.

Effectively, for many years I've used TAB and CR+LF in order to copy columns and raws to EXCEL (but with simple text without formating).

But my problem is not how to create columns. My problem is how to copy RTF text to EXCEL using the InsertRTF() method.

It seems that EXCEL does not recognize RTF text from the Clipboard

 :(

Regards,
Juan

El miércoles, 27 de mayo de 2020, 6:19:43 (UTC-6), Gianluca72 escribió:
> Hi Juan,
> i have a simple function i use to copy data from a bBroaser object.
> basically _chr(9) allow you to shift to the next coloumn , and _CHR(13) + _CHR(10) to the next line.
> 
> Regards
> Gianluca
> 
> ************************************************ 
> FUNCTION Clip_bBrowser_XLS( obBrowser , aTitolo )
> //oListView -> Oggetto ListView
> //aTitolo	-> array di Stringhe x Titolo (ogni elemento andrà in una colonna separata)
> 
> LOCAL oClipboard AS Clipboard
> LOCAL cClipboard AS STRING
> LOCAL oLVI AS ListViewItem
> LOCAL nT AS INT
> LOCAL cTitle, cTemp AS STRING
> LOCAL i, nI, nCol, nItem  AS INT
> LOCAL cCrLf,cTestata  AS STRING
> LOCAL sSymCol AS SYMBOL
> LOCAL sFieldType AS STRING
> 
> LOCAL cClipboard1,cClipboard2,cClipboard3,cClipboard4 AS STRING
> 
> LOCAL aColumnList AS ARRAY
> *LOCAL oColumn AS bDataColumn
> 
> LOCAL obArray AS bArrayServer
> obArray := obBrowser:server
> 
> cCrLf := _CHR(13) + _CHR(10)
> 
> IF obBrowser:ColumnCount > 0
> 	oClipboard := Clipboard{}
> 	nCol := obBrowser:ColumnCount
> 	nItem := obBrowser:Server:LastRec
> 	aColumnList := obBrowser:ColumnList
> 
> 	oClipboard:Clear()
> 	//Titolo
> 	FOR nT := 1 TO Len(aTitolo)
> 		IF nT == 1
> 			cTitle += aTitolo[nT]
> 		ELSE
> 			cTitle += _chr(9)+ aTitolo[nT]
> 		ENDIF
> 	NEXT	
> 	cClipboard := cTitle + cCrLf + cCrLf
> 	FOR i := 1 TO nCol
> 		IF ! Empty(aColumnList[i]:FieldSym)
> 			cTestata := aColumnList[i]:Caption		
> 			*cTestata := obArray:FIELDINFO(DBS_NAME,i)
> 			cClipboard := cClipboard + cTestata + _chr(9)
> 		ENDIF
> 	NEXT
> 	cClipboard := cClipboard + cCrLf
> 
> 	FOR i := 1 UPTO nItem
> 		IF MOD(i,10) = 0
> 			GetAppObject():Exec(EXECWHILEEVENT)
> 		ENDIF	
> 		cTemp := ''
> 		*oLVI := oListView:GetNextItem( LV_GNIBYITEM,,,,,i-1 )
> 		obArray:GoTo(i)
> 		FOR nI := 1 TO nCol
> 			sSymCol := obArray:FieldSym(aColumnList[nI]:FieldSym)
> 			*sSymCol := oListView:GetColumn(nI):NameSym
> 			//controllo testata LV
> 			//se = 'COD..' o 'ART..' Stringa Excel
> 			*cTestata := Upper(Left(oListView:GetColumn(nI):Caption,3))
> 			*IF cTestata == 'COD' .OR. cTestata == 'ART'
> 			*	cTemp += "'"+oLVI:GetText(sSymCol)+ _chr(9)
> 			*ELSE
> 			*	cTemp += oLVI:GetText(sSymCol)+ _chr(9)
> 			*ENDIF
> 			IF ! Empty(aColumnList[nI]:FieldSym)
> 				sFieldType := AllTrim(obArray:FIELDINFO(DBS_TYPE,aColumnList[nI]:FieldSym))
> 	            DO CASE
> 	            CASE sFieldType = 'C'
> 	            	cTemp += "'"+obArray:FIELDGET(aColumnList[nI]:FieldSym)+ _chr(9)
> 	            CASE sFieldType = 'N'
> 	            	cTemp += Str(obArray:FIELDGET(aColumnList[nI]:FieldSym))+ _chr(9)
> 	            CASE sFieldType = 'L'
> 	            	cTemp += IF(obArray:FIELDGET(aColumnList[nI]:FieldSym),"V","F")+ _chr(9)
> 	            CASE sFieldType = 'D'
> 	            	cTemp += DToC(obArray:FIELDGET(aColumnList[nI]:FieldSym))+ _chr(9)	
> 	            ENDCASE
> 			ENDIF
> 			
> 		NEXT
> 		cClipboard += cTemp+cCrLf
> 	NEXT	
> 
> 	oClipboard:Insert(cClipboard)
> ENDIF
> RETURN

[toc] | [prev] | [next] | [standalone]


#13010

FromArne Ortlinghaus <Arne.Ortlinghaus@acs.it>
Date2020-06-14 07:54 +0200
Message-ID<rc4e3f$92l$1@gioia.aioe.org>
In reply to#13006
Hi Juan,

probably you have to put your RTF text into the the value of a hidden 
RTF-control in your application and then call the copy method of the 
control to copy it into the clipboard.

I have done this way. It seems that the basic WINAPI clipboard functions 
don't work anymore correctly in different cases, whereas the WM_COPY 
message of the control does it correctly.

Arne Ortlinghaus
INFOMINDS GMBH

[toc] | [prev] | [next] | [standalone]


#13011

FromJuan Chavarría <juan.chavarria.grillo@gmail.com>
Date2020-06-29 11:30 -0700
Message-ID<677ea3fd-9c6c-4b56-ac08-2715f163789co@googlegroups.com>
In reply to#13010
Hi Arne,

I'm going to try it.

Thank you very much,

Juan

El sábado, 13 de junio de 2020, 23:55:03 (UTC-6), Arne Ortlinghaus escribió:
> Hi Juan,
> 
> probably you have to put your RTF text into the the value of a hidden 
> RTF-control in your application and then call the copy method of the 
> control to copy it into the clipboard.
> 
> I have done this way. It seems that the basic WINAPI clipboard functions 
> don't work anymore correctly in different cases, whereas the WM_COPY 
> message of the control does it correctly.
> 
> Arne Ortlinghaus
> INFOMINDS GMBH

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web