I'm open to another way but I think that the solution has got to be very simple I just can't seem to get it.
Under Orientation on the right side, in the Degrees box, use the up or down arrow to set the exact number of degrees that you want to rotate the selected cell text. First of all, make sure that the column in which your text is captured is wide enough to store the entire text in a single cell.
Now, under the Alignment tab, choose Right (Indent). the SDK says to add this next line to center the text but it doesn't work Select Home > Orientation > Format Cell Alignment. Select your data, right-click on it and choose Format Cells. This is how I am setting the custom widths of these columns and I would like to add to this function (method, whatevs) the capability to center the text: private static Column CreateColumnData(UInt32 StartColumnIndex, UInt32 EndColumnIndex, double ColumnWidth)
I have opened the document after manually center the columns in openXML SDK but the code that is reflected does not achieve the desired outcome. I have a document that my asp.net page is creating and I need to align the text of certain columns to center.