Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #12995 > unrolled thread
| Started by | Juan Chavarría <juan.chavarria.grillo@gmail.com> |
|---|---|
| First post | 2020-05-22 20:48 -0700 |
| Last post | 2020-06-29 11:30 -0700 |
| Articles | 5 — 3 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | Juan Chavarría <juan.chavarria.grillo@gmail.com> |
|---|---|
| Date | 2020-05-22 20:48 -0700 |
| Subject | How 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]
| From | Gianluca72 <gianluca.pinoli@proximacentauri.it> |
|---|---|
| Date | 2020-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]
| From | Juan Chavarría <juan.chavarria.grillo@gmail.com> |
|---|---|
| Date | 2020-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]
| From | Arne Ortlinghaus <Arne.Ortlinghaus@acs.it> |
|---|---|
| Date | 2020-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]
| From | Juan Chavarría <juan.chavarria.grillo@gmail.com> |
|---|---|
| Date | 2020-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