The long text area fields are output as a single line without line breaks.
Set the Alignment to "Wrap text" from "Format Cells" in Excel.
The currency symbols are not output.
The currency symbol is not output. Set the format to display the currency symbol from "Format Cells" in Excel.
The 3-digit comma symbol in numerical values is not output.
Three-digit commas are not output. Set the comma delimiter format from "Format Cells" in Excel.
Decimal points are truncated.
Use Excel's cell formatting to set the decimal point to be displayed.
Formulas in Excel are not output correctly. Formulas are output incorrectly.
If the Excel formula does not output correctly, create a formula field in Salesforce and set the formula field as a merge field. It is possible that the template is not supported by the application.
Graphs and pivot tables do not output correctly.
Excel features such as graphs and pivot tables are not available.
The error message "We found a problem with some content in 'filename.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes." is shown, and when opening the file, the contents are output as empty.
OFC may not support the output pattern. Try the following.
- If the file has a complex layout, simplify the layout.
- In Excel, delete unused rows and columns. Excel normally saves rows with values and formatting, but for some reason an empty row may be recognized as a used cell and a large number of unnecessary rows are saved.
- In Excel, check for hidden and unnecessary sheets, and delete any unnecessary sheets.
- If Office functions (e.g., graphs, pivot tables, etc.) are used, remove Office functions. OFC may not support them.
- If images are included in the template file, reduce the file size of the images by lowering the image quality.