Wednesday, June 10, 2009

Excel Web Services format issue “Accounting” format vs “Currency”

Strange, but when you publish an Excel sheet to Sharepoint and view it with Excel Web Services, cells formatted as “Accounting” show as follows:

clip_image002

but when you change the format in Excel to “Currency”, it shows correctly:

clip_image004

Could it be some kind of spacing issue with the rendering of the “$” within the web page?

No comments:

Post a Comment