Forum Discussion
Tiny Life Plaguing Boxes
Discovered the fix for the issue. It seems as if this was more an issue between communications with my c# scripting and word, rather excel. Excel I am sorry for questioning your abilities. He just can't read asciii symbols and apparently expresses them as boxes. I simply added the below code if anyone was ever encountering this issue when using Microsoft.Office.Interop interactions.
text = text.Substring(0, text.Length - 2);Simply removed the last two extra characters. I'd rather a better solution but this should get me through development.
Can't explain why the "boxes" appear, but can perhaps help get rid of them. Copy the "box" from within a cell. Select all cells. Press Ctrl- H (Find and replace). Paste the the "box" symbol in the "Find" field and leave the "Replace with" blank. Press "Replace all", OK and Close. This should remove all the "box" symbols in the entire sheet in one go.
Oh you almost made my day. Small issue though. As the box disappears once the cell begins edit, I can't quite only snag the box. And if I copy/paste the entire cell the box also decides to go. There is a development though, I believe this may be an issue of my script inserting the values in as var rather string or int. Possibly more a c# issue rather excel.
EDIT: Possible additional info. When cell is copied and pasted into outside source it is represented by quotations rather the evil rectangle. Another tidbit is my venture into variable types did not work either.