Not able to paste clipboard data in open office excel

Question

0.00/5 (No votes)

See more:

HI every one,

i am copying data from listview and pasting it in excel it is pasting.but instead of excel.I want to paste in open office excel(calc).for first time copying data from listview it was working fine.but if you copy second time and paste it in open office it is not pasting.but same thing you can paste in excel it is pasting.how to resolve this please any one tell me.here is my code.

C#

 StringBuilder buffer = new StringBuilder();

 for (int i = 0; i &lt; lv.Columns.Count; i++)
 {
    buffer.Append(lv.Columns[i].Text);
    buffer.Append("\t");
 }

 buffer.Append("\n");

 for (int i = 0; i < lv.Items.Count; i++)
 {
    buffer.Append(lv.Items[i].SubItems[0].Text);
    buffer.Append("\t");
    buffer.Append(lv.Items[i].SubItems[1].Text);
    buffer.Append("\t");
    buffer.Append(lv.Items[i].SubItems[2].Text);
//}

  buffer.Append("\n");

  Clipboard.SetDataObject(buffer.ToString();

thanking you.

Posted 9-Jan-14 5:58am

Bitto kumar

Updated 9-Jan-14 6:29am

bowlturner

v3

Add a Solution

Comments

CHill60 9-Jan-14 13:08pm

Try putting Clipboard.Clear(); before the .SetDataObject - I have a vague recollection that this will overcome an intermittent problem with the clipboard

Bitto kumar 10-Jan-14 4:14am

I tired but it is not working...thanks for reply

Bitto kumar 10-Jan-14 9:04am

Please give me any suggestion.....

CHill60 10-Jan-14 11:29am

Try separating the data items with commas instead of tabs and use Clipboard.SetData(DataFormats.CommaSeparatedValue, buffer) ... you might need to fiddle with buffer e.g. buffer.ToString() or (object)buffer - I can't check this at the moment

Bitto kumar 11-Jan-14 4:12am

i tired what you said.but in open office paste option is not visible.but in buffer has data..and i tried with all format's still it is not pasting..

ZurdoDev 9-Jan-14 15:10pm

It may also be that Open Office Calc does not support what you are sending it. Try it manually and see if it works.

Bitto kumar 10-Jan-14 9:03am

it supporting.when you copy data first time from listview it is pasting.when copy data from second time it is not pasting.but in excel it is pasting.....thank you

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)