Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Copy String from Calc Cell

Hi there,

I seem to be having trouble copying a string from a calc cell. Every time I try to paste the copied information into a writer doc, it pastes the entire cell rather than just the text. Here is a code snippet, all terms have been defined and Frame and Frame2 are the Writer doc and Calc doc respectively.

InfoCell = CalcDoc.Sheets(2).getCellbyPosition(2, 3)
Info = InfoCell.String
CalcDoc.CurrentController.Select(Info)
dispatcher.executeDispatch(Frame2, ".uno:Copy", "", 0, Array())
dispatcher.executeDispatch(Frame, ".uno:Paste", "", 0, Array())