1

A user has created a document in excel (works in 2007 and above). This document contains some simple data in one sheet and a chart in the other.

The problem is the chart which displays fine in excel, loses the formatting when displayed in the web part. In this case the data is meant to be a percentage but appears to be displaying as a general number.

All the formatting in the document itself (for both the graph and the data) has been set to percentage but the problem persists.

Any ideas?

  • Might be a better idea to ask Office/Office Online forums of this one. SharePoint doesn't really do anything to the document. – Charles Mar 11 '16 at 17:10
  • Fair comment but it works in the office suite and Excel online. The only location it is not working is when the document is displayed via the web part in SharePoint. The question was focused on this and whether it was a common issue. – Keiron Mar 11 '16 at 17:59
1

I'm aware this got down voted but in case anyone has a similar issue:

To fix our issue the data in the spreadsheet had to be set to 2 decimal places e.g. 10.50%, the web part for whatever reason would not accept 1 decimal place for example the format the user wanted was 10.5%.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.