Comments by Member 13922719

Member 13922719 25-Jul-18 2:30am View

Thank you..sorry but that is no possible because users can have formatted multi line contents.

Member 13922719 24-Jul-18 9:05am View

I tried by making the following change to code:
sheet.Cells[i,4].PasteSpecial(Microsoft.Office.Interop.Excel.XlPasteType.xlPasteFormulas);

It throws the "Unable to get the PasteSpecial property of the Range class" exception.

Member 13922719 24-Jul-18 7:42am View

Sure thank you..I'll check it and get back.

Member 13922719 24-Jul-18 6:03am View

Thank you..The list descriptionValuesForExcel has multiple elements each being html texts which gets written to clipboard. Okay now I understand that presence of and tags is taking the contents to adjacent cells. Sorry I dint understand the idea of pasting contents into formula bar. This list would have say 50 html texts will it still be a good idea to paste it as suggested.

Member 13922719 24-Jul-18 5:21am View

I have updated html strings. Kindly check it. Exactly, its inserting into the adjacent cells based on the spacing's yet I require the same formatting to be maintained within selected cell only.

Comments by Member 13922719 (Top 5 by date)