Formatted text not preserved Excel is published
Hi,I was successful at publishing my 2007 Excel spreadsheet to SharePoint 2007; however, all the text formatting (e.g., bold, indents, colored text, etc.) are stripped in SP. Is it possible to preserve these formats automatically? I know that in SP, I can change individual text fields to 'multiple lines of text' and then edit each cell but this is not a very sustainable/scalable process. Could someone show me the way? Many thanks!
February 18th, 2010 12:36am

Hi, Instead of publish the excel workbook as SharePoint list, you could use Excel Service to render the Excel document if you cares about the formatting. See Excel Services (http://office.microsoft.com/en-us/sharepointserver/CH101083521033.aspx) for more information. -lambertSincerely, Lambert Qin Posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
February 22nd, 2010 2:19pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics