Office File Creator Instruction manual
  • Instruction manual
  • FAQ
  • Troubleshooting
  • Error List
  • Instruction manual
  • Troubleshooting
  • Error List

Decimal points are truncated.

Excel
2024.10.202024.11.12

 

Set the format from "Format Cells" in Excel.

 

Instruction manual

Excel

 

Excel
Currency and Number Fields
Office File Creator Instruction manual
Office File Creator Instruction manual

Related articles

Template Common

The currency symbol for the currency field is not output.

The currency symbol is not output. Excel Set the format from the cell formatting in the template file. Word/PowerPoint/P...
Template Common

Number fields are not output with 3-digit comma delimiters.

Excel Set the format from the cell formatting in the template file. Word/PowerPoint/PDF Check on "Adjust Format (commas/...
Merge Field

How do I output the currency symbol?

The data type is Currency or Date/Time can be set the formatting. Available in Ver.2.0 or later. Word/PowerPoint/PDF e.g...
Merge Field

How do I round a number to a specified number of decimal places?

The data type is Currency or Date/Time can be set the formatting. Available in Ver.2.0 or later. Word/PowerPoint/PDF e.g...
Template Common

Extra decimal places are displayed for number fields.

Excel Set the format from the cell formatting in the template file. Word/PowerPoint/PDF The values actually stored in Sa...
  • 1. Install
    • 1.1. Install
    • 1.2. License Information
  • 2. Grant Permissions
    • 2.1. Settings of permissions
    • 2.2. Note
  • 3. Create Template File
    • Template Common Settings
    • Excel
    • Word
    • PowerPoint
    • PDF
  • 4. Create Template Record
    • 4.1. Create Template Record
    • 4.2. Upload Template File
    • 4.3. Export Test and Verify Merge Fields
    • 4.4. Note
    • 4.5. Reference
  • 5. Output Options
    • 5.1 Common Options
      • Formatting of Date and Date/Time Fields
      • Formatting of Currency and Number Fields
      • Adding Text to Merge Fields
      • Replace True/False in Checkbox Fields with Other Values
      • Outputs Today's Date and Current Time (Today/Now)
      • Output Parent and Reference Object Field
      • Set Merge Fields to the File Name
      • Functions for Merge Fields
      • Attach Files to Records
      • File Save + Download
      • Preview PDF
      • Output Images
      • Output Attachment Files (List/Images)
      • Setting File Output Conditions
      • Save Logs
    • 5.2 Child Record Options
      • Create OFC_Child Object Option Record
      • Filter Output Conditions for Child Records
      • Sort Output Order of Child Records
      • Output by Index Numbers of Child Record
      • Block Output of Child Records (Excel)
      • Group Output of Child Records (Excel)
      • Output 3 or More Levels of Child Records
      • Settings Minimum/Maximum Number of Child Records
      • PDF Page Break Settings
      • Advanced Relationship Settings
  • 6. Create Custom Button
    • 6.1. Create Custom Button
    • 6.2. Put the custom button on the page layout
    • 6.3. Export to File
  • 7. Create Lightning Component Button
    • 7.1. Create Lightning component buttons
    • 7.2. About Icon
    • 7.3. Reference
  • 8. Advanced Features
    • Batch File Output from ListView
      • Create Visualforce page
      • Create Custom Button
      • Note
    • Use with Screen Flow
      • How to use in Flow
      • Flow Example
      • Note・Limitations
      • Reference
    • Use on Experience Cloud
      • Limitations
      • How to Use
      • Test Output
      • Considerations for Guest Users
  • 9. Migrate Resources
    • 9.1. Resources & How to Migrate
    • 9.2. References
  • 10. Operating Environment
  • 11. Limitations
  • 12. FAQ/Troubleshooting
  • 13. Error List

Office File Creator Product Page

Appexchange

Office File Creator Instruction manual
  • Privacy Policy
© 2022-2024 Generipse LLC.
    • Instruction manual
    • FAQ
    • Troubleshooting
    • Error List
  • Home
  • Top