FiveTech Software tech support forums

Natter wrote:oRng.Find.MatchAllWordForms:=.T.[/code]

Try

Code: Select all  Expand view

oRng:Find:MatchAllWordForms := .T.

Note: colons instead of dots.

sorry, I have no idea

I need to find all the spellings of the string. To do this oRng:=oTb:Item(1):Cell(x,y):Range:Duplicate()[b]oRng.Find.MatchAllWordForms:=.T.[/b]oRng:Find:Execute("MyText") However, I get an error: Word.Application:ACTIVEDOCUMENT:TABLES:ITEM:CELL:RANGE:DUPLICATE:FIND/3 ...

No need to create array
Directly Xbrowse recordset.
If you set oCol:nEditType := 1 user can edit any cell he wants.
XBrowse automatically saves the changes.
What more you want to know?

By the way, is it possible to paste what I have on the clipboard into a cell with just one mouse click? Yes. Just by clicking Ctrl-V. For this we first need to set oBrw:lCanPaste := .t. We can paste text into text fields and even images into Image fields. All ...

Mr. Rao:

Thanks so much, I understood.

By the way, is it possible to paste what I have on the clipboard into a cell with just one mouse click?

Best regards

Now how do I know the new value after editing the cell? oCol:Value Notes: Do not use this for validation. This is called when the modified data is already written and also if the old data is different from the new data written. This codeblock is ...

kindly friends: With the code below I know the current value of the cell :bOnChange  := { |oCol, uOldVal| VerSaldo(uOldVal) }  Now how do I know the new value after editing the cell? I must compare the old content against the new ...

Thank you, Antonio! I'll try

Dear Yuri, oTb := oWord:ActiveDocument:TablesoCell := oTb:Item(1):Cell(x, y)oStartRange := oCell:Range:Duplicate()oEndRange := oCell:Range:Duplicate()oStartRange:MoveStart(5, -1) // MoveStart to character, ...

Hi, I need to select a fragment in a table cell. I do this: oTb := oWord:ActiveDocument:TablesoRng:=oTb:Item(1):Cell(x,y):RangeoRng:Select()oWrd:Selection:Find:Execute('Keyword') //keyword for getting coordinatesdim:={{oTb:Item(cnt):Cell(st,3):Start,oWrd:Selection:Start-1}, ...

Then, you can copy any text any where and then press Ctrl-V in the active cell. The value is pasted and browse updated.
This applies even for pasting images in memo fields.

Aprovechado el hilo, como debería definirse si quiero hacerlo con un Xbrowse con Array?

Code: Select all  Expand view

oCol:VarPut( newValie _

For pasting initially set

Code: Select all  Expand view

oBrw:lCanPaste := .t.

Then, you can copy any text any where and then press Ctrl-V in the active cell. The value is pasted and browse updated.
This applies even for pasting images in memo fields.

... Recordset of Excel ? Yes, you can. Clicking on header to sort the column and incremental seek/filter works just like any other datasource. Inline Cell Edit: Pressing Enter key starts inline cell edit, if the cell is editable. [A reason why we should not disturb the internal behavior of XBrowse ...

Hi, To find and color a phrase in the text of a Word table cell, I do this: oTb:Item(n).Cell(x,y):Select()oWrd:Selection.Find:Execute("MyText", .F., .T.)oWrd:Selection.Range:HighLightColorIndex=CLR_RED How can ...